PSA_ACCTGGL Is Not Creating Inter-Unit Accounting Lines When PCBU <> Resource GLBU

(Doc ID 1596672.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On :  9.1 version, Projects Utilities

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

ACTUAL BEHAVIOR  
---------------
PSA_ACCTGGL process is not creating the expected accounting entries in case of inter unit set up as described in the replication steps below.

EXPECTED BEHAVIOR
-----------------------
PSA_ACCTGGL process should create the expected accounting entries for the replication steps below.

STEPS
-----------------------
The issue can be reproduced at will with the following 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.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms