My Oracle Support Banner

ECA/EPC: PSA_ACCTGGL Is Not Creating Inter-Unit Accounting Lines When PCBU <> Resource GLBU (Doc ID 1596672.1)

Last updated on AUGUST 03, 2020

Applies to:

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


Project Costing Inter-Unit Accounting lines are not getting generated when Project BU <> Resource BU.

Replication Steps

1. Set Up Financials/Supply Chain > Install> Installation Options - Project Costing - Enable Organization checked.
2. Set Up Financials/Supply Chain > Product Related > Project Costing >  General Options > Organization Hierarchy  - 2 Level Setup - BUSINESS_UNIT_GL and DEPT_ID.
3. Define Table Set control - For Set Control Value FRFS1 - FS_06 pointing to FRFS1 and FS_08 pointing to FRA01. Project will be created in FRFS1 Business Unit.
4. Define Table Set control - For Set Control Value US004 - FS_06 pointing to US004 and FS_08 pointing to USA. Resource belongs to this business unit.
5. Define Accounting Rules for analysis type 'ACT'. Inter-Organization levels - Default, Level1, Level2. The Org to Book at line level is chosen as Project for Debit line and Resource for Credit line.
6. Create a Project/Activity in FRFS1 BU.
7. Define project-owning organization - Business Unit is 'FRFS1' and Dept is 71138
8. Add an online ACT transaction for amount 300. The GL Business Unit is 'US004', From Business Unit GL is 'FRFS1'. Process the transaction
9. Once the PC_WRAPPER completes
10. Run the PSA_ACCTGGL process.

The expectation is that there accounting entries gets created in PS_CA_ACCTG_LN_PC. But the process completes with following message

10 10:55:57PM 1 rows selected from PROJ_RESOURCE into TA0.
10 10:56:00PM 0 revenue rows in TA1.
10 10:56:00PM 1 cost rows in TA1.
10 10:56:01PM 0 sharing rows in TA1.
10 10:56:01PM 0 sharing rows in TA1.
10 10:56:02PM Processing Project Transactions
10 10:56:32PM 2 rows before starting multi currency conversion.
10 10:56:32PM 2 rows successfully converted to the target currency
10 10:56:48PM Rows excluded due to invalid ChartField combinations.
10 10:56:55PM No Inter or Intra Unit row exists.
10 10:56:58PM 0 rows created in CA_ACCTG_LN_PC.
   10:57:31PM Successfully posted generated files to the report repository



This above step verifies for project validity. The rows returned should be 0. If not, eventually data is put into PS_PSA_CMBOERR_TA1 table flagging the rows as error rows failing combo edit.




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

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