Cannot find adjusted timesheet data in WIP tables

book

Article ID: 131316

calendar_today

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. Check Prrmexported column in the Prtimeentry table to see if the value is set to 1 (one) indicating data has been posted to Financial table;

    select * from prtimeentry where prtimesheetid in (timesheet ids)


3. The transaction was deleted from the Invalid Transactions page.

Environment

Release: All Supported
Component: ODFNM

Resolution

  1. 0-hour timesheets do not become financial transactions as it does not contain any actual hours logged to projects.
  2. 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.