PC 9.2: GL Business Unit Blank On PC_FND_DIST_LN Causes PC_FND_DIST To Abend (Doc ID 2215747.1)

Last updated on DECEMBER 30, 2016

Applies to:

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

Symptoms

On : 9.2 version, Other

When attempting to run funds distribution process PC_FND_DIST, the following error occurs.

ERROR
-----------------------
Process 97711 ABENDED at Step PC_FND_DIST.CALCULAT.SetID (SQL) -- RC = 1407

File: e:\pt85506c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 26 Return: 1407 - ORA-01407: cannot update ("EMDBO"."PS_PC_FND_TA44"."SETID") to NULL Failed SQL stmt: UPDATE PS_PC_FND_TA44 SET SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNT RLVALUE = PS_PC_FND_TA44.BUSINESS_UNIT_GL AND RECNAME = 'GL_ACCOUNT_TBL'), SETID_TO = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = PS_PC_FND_TA44.BUS_UNIT_GL_TO AND RECNAME = 'GL_ACCOUNT _TBL') WHERE PROCESS_INSTANCE = 96700 AND ANALYSIS_TYPE <> 'ODL'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a Project/Activity
2. Associated a Fund Distribution Rule that uses an ACT transaction and creates the target FDS and FDF rows
3. The PC_FND_DIST_LN.BUSINESS_UNIT_GL is populated
4. Create a transaction ACT transaction
5. Closed the Project
6. The PC_FND_DIST_LN.BUSINESS_UNIT_GL is populated
7. Open the Fund Distribution Rule and go to target and click OK. This will do the blank out BUSINESS_UNIT_GL
8. The PC_FND_DIST_LN.BUSINESS_UNIT_GL is now blank
9. Make the Project Active and process the funds distribution process for this project

The above abend is received.

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