PC_FND_DIST_LN.BUSINESS_UNIT_GL Incorrectly Assigned A Blank Value In Some Case And Due to This PC_FND_DIST ABENDED at Step PC_FND_DIST.CALCULAT.SetID (SQL) -- RC = 1407

(Doc ID 2227732.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : 9.1 version, Other

When attempting to funds distribution process PC_FND_DIST in the following scenario.
the following error occurs.

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

 File: e:\pt85508b-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 = 97711 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