Cannot find adjusted timesheet data in WIP tables
Article ID: 131316
Updated On:
Products
Clarity PPM On Premise
Clarity PPM SaaS
Issue/Introduction
After submitting an adjustment timesheet, the original adjusted timesheet cannot be found PPA_WIP table.
Cause
Here are the possible causes:
1. Check if the adjusted timesheet submitted was a 0-hour timesheet by running the following query:
select * from prtimesheet where prid in (timesheet_history_list)
Analyze and review the adjusted/adjustment timesheet pair results.
2. The transaction was deleted from the Invalid Transactions page.
1. Check if the adjusted timesheet submitted was a 0-hour timesheet by running the following query:
select * from prtimesheet where prid in (timesheet_history_list)
Analyze and review the adjusted/adjustment timesheet pair results.
2. The transaction was deleted from the Invalid Transactions page.
Environment
Release: All Supported
Component: ODFNM
Resolution
- 0-hour timesheets do not become financial transactions as it does not contain any actual hours logged to projects.
- New transactions that appear in the Administration > Invalid Transactions page can be on hold or deleted, which prevents it from being processed by the Post Transactions to Financial job.
Feedback
Powered by
