My Oracle Support Banner

EPC: When Doing Transaction Adjustment Using Manager Transaction Review Page, the Resource ID for Adjustment Rows Does Not Match in Tables PROJ_RESOURCE and CA_ACCTG_LN_PC (Doc ID 2809655.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

These are the 2 ways of performing adjustment transactions.

  1. Main Menu > Project Costing > Transaction Definitions > Transaction Adjustment
  2. Main Menu > Project Costing > Interactive Reports > Manager Transaction Review

RESOURCE_ID value is the same in PROJ_RESOURCE and CA_ACCTG_LN_PC tables when adjustments are done from the Transaction Adjustment page.
RESOURCE_ID value is different in PROJ_RESOURCE and CA_ACCTG_LN_PC tables when adjustments are done from the Manager Transaction Review page.

Since the resource id is different when adjustments are done from the Manager Transaction Review page, it becomes difficult to reconcile the transactions.

Replication Steps:

  1. Create a Project and Activity.
  2. Add a Transaction using Add Transaction page. Main Menu > Project Costing > Transaction Definitions > Add Transaction.
  3. Do Transaction adjustment using Main Menu > Project Costing > Transaction Definitions > Transaction Adjustment.
  4. Review the RESOURCE_ID field values for the adjusted transaction rows in PROJ_RESOURCE and CA_ACCTG_LN_PC. They match. << This is correct
  5. Add another Transaction using Add Transaction page.
  6. Now do Transaction adjustment using Main Menu > Project Costing > Interactive Reports > Manager Transaction Review.
  7. Do Accounting Adjustment using Main Menu > Project Costing > Accounting > Accounting Adjustments.
  8. Review the RESOURCE_ID field values for the adjusted transaction rows in PROJ_RESOURCE and CA_ACCTG_LN_PC. They do not match. << This is incorrect

Demo Replication Steps

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.