ppa_wip.EMPLYHOMEDEPART not updated in WIP Adjustments and transfers
search cancel

ppa_wip.EMPLYHOMEDEPART not updated in WIP Adjustments and transfers

book

Article ID: 219340

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We have changed the financial department for a resource.

The transactions generated by the timesheets posted since the change do show the new Resource Department on the PPA_WIP table (EMPLYHOMEDEPART column).

Is there a way of updating the past transactions so they show the current financial department of the resource?

Cause

This was analyzed through DE39017

Resolution

The issue is resolved in 16.2.1

Additional Information

Details on DE39017:

STEPS TO REPRODUCE

1. Run Post Timesheets
2. Run Post Transaction job
3. Run Post to WIP job
4. Modify the 'Financial Department' and 'Resource Class' values for a resource that had transactions posted
5. From 'Create WIP Adjustment', select the resource that had the financial properties modified in step 4 and select a transaction date for one of the posted transactions and check 'Calculate new rates' box
6. Click Save & Return button
7.Go to Approve WIP adjustments and 'Approve' button
8. Query PPA_WIP.EMPLYHOMEDEPART

Expected Results:
EMPLYHOMEDEPART should reflect the value it was updated to in Resource Financial Properties

Actual Results: EMPLYHOMEDEPART is still pointing to the original value