EGL9.2: Allocation Process With Multiple Steps in Allocation Group Abends at Step FS_ALLC_BCUR.uPrimLed.uLedger with SQL Error: ORA-01407: cannot update ("xxxxxx"."PS_ALC_GL_T_TAOn"."LEDGER")to NULL
(Doc ID 2598475.1)
Last updated on AUGUST 27, 2024
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running Allocation Process with multiple allocation steps included and with a specific setup in one of the Allocation steps, the process is failing with the following error message :
"Process xxxx ABENDED at Step FS_ALLC_BCUR.uPrimLed.uLedger (Action SQL) -- RC = 1407
SQL Error: ORA-01407: cannot update ("SYSADM"."PS_ALC_GL_T_TAO9"."LEDGER")to NULL --
UPDATE PS_ALC_GL_T_TAO9 SET LEDGER = ( SELECT A.LEDGER FROM PS_ALC_BULED_TAO9 A WHERE A.BUSINESS_UNIT = PS_ALC_GL_T_TAO9.BUSINESS_UNIT AND A.PRIMARY_LEDGER = 'Y' AND A.LEDGER_GROUP = 'AAAA' AND A.PROCESS_INSTANCE = xxxx)
WHERE PROCESS_INSTANCE = xxxx AND LEDGER = 'LEDGER' AND LOGICAL_RECORD IN ('T', 'O', 'B', 'C') ; "
If the 2 steps are run in different allocation processes, then the Allocation process runs correctly without error.
The issue can be replicated by following the next steps :
- Create a new Business unit TEST ( Setup Fin>Business unit related>General ledger>Ledger definition ) with Base Currency =GBP and also update the Interunit Template tab;
- Go to Setup Financial>Business unit related>General Ledger>Ledgers for a Unit for the new business unit TEST, and add the ledger group RECORDING;
- Go to Allocation>Define Allocation Step and create a new step ALLOC1- –Tab Type and and Allocation Type=Copy and Extension =Add;
- On Tab Pool , add 3 options :- Account - with value= 600010 //- Business unit - with value = US001 // Department - with Select Tree Nodes and Tree =Departments and Node= FIN_GRP;
- On Target Tab , specify the value for Business unit =TEST and project = 4;
- On Offset Tab, specify the value project = 4 all the others having the value from pool;
- Go to Allocation>Define Allocation Step and create a new step ALLOC2- –Tab Type and and Allocation Type=Copy and Extension =Add;
- On Tab Pool , add 3 options :- Account - with value= 600010 //- Business unit - with value = US003 and US004 // Department - with Select Tree Nodes and Tree =Departments and Node= FIN_GRP;
- On Target Tab , specify the value for Business unit =TEST and project = 4;
- On Offset Tab, specify the value project = 4 all the others having the value from pool;
- Go to Allocation>define Allocation>Define Allocation group and create a new group with the 2 allocation steps;
- Check Ledger group Recording and make sure that has 2 ledgers with primary ledger Local and secondary ledger with a different currency than the 1st one;
- Make sure that the ledger group RECORDING is attached to Bu US001, US004 , US003 - go to Setup Fin>Business unit related>General ledger>Ledger for a unit;
- Check the tree DEPARTMENTS under the setid SHARE and tree node FIN_GRP ( Tree manager>Tree manager ) . It will have the values 13000-13999;
- Enter 3 journals for the 3 BU : US001, US003 and US004 with at least 1 with the foreign currency;
- Run Allocation process : Allocations>define and Perform Allocations >Request Allocation;
- Error message appears;
Check the following Replication document
Changes
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 |
Changes |
Cause |
Solution |
References |