My Oracle Support Banner

EPC 9.2 : Manager Transaction Review (MTR)/Accounting Adjustments Are Incorrectly Populating the PS_PROJ_RESOURCE's GL_DISTRIB_STATUS/Account Fields When Doing Transaction Adjustments (Doc ID 2890086.1)

Last updated on FEBRUARY 07, 2024

Applies to:

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

Symptoms

Manager transaction review (MTR)/Accounting Adjustments are incorrectly populating the proj_resource’s GL_distrib_status/Account fields when doing transaction adjustments


Replication Steps:

  1. Create a Project/Activity
  2. Create a Transaction using Add Transaction Page. The amount being $100, the GL_DISTRIB_STATUS is 'N' and the Account is 'XXXX' and RESOURCE_TYPE is blank.
  3. Navigate to Project Costing > Interactive Reports > Manager Transaction Review. Search for the Project. You will find the transaction that was created in step 2. Select Adjust check box against the transaction and click Adjust. Click the "Adjust Chartfields Only" option and click next.
  4. In the next screen, populate the resource type as 'LABOR' and click the Finish button.
  5. The screen shows the source transaction, the offset transaction with the Ledger Distrib status of 'D', and the new transaction with the Ledger Distrib status of 'I'.
  6. No transactions are processed to CA_ACCTG_LN_PC. Yet for the offset transaction in the PS_PROJ_RESOURCE table, the Ledger Distrib status of 'D' is 'D" which is incorrect.
  7. Navigate to Project costing > Accounting > Accounting Adjustments. Find the transaction. Select the "Assign" check box for the transaction. Click on the Assign Chartfields button. Populate the different account on the new transaction and choose "Ledger Distrib Status" as "Not Done" and Save.
  8. This creates offset and new transaction accounting entries in CA_ACCTG_LN_PC. At this stage the PROJ_RESOURCE still shows that the New transaction has the Ledger Distrib status of 'I' and this is incorrect.
  9. When compared to Transaction Adjustment the behavior seems incorrect for Ledger Distribstatus from steps 5 through Step 8.

Replication Document

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.