My Oracle Support Banner

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 DECEMBER 20, 2019

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 :

  1. 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;
  2. 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;
  3. Go to Allocation>Define Allocation Step and create a new step ALLOC1- –Tab Type and and Allocation Type=Copy and Extension =Add;
  4. 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;
  5. On Target Tab , specify the value for Business unit =TEST and project = 4;
  6. On Offset Tab, specify the value project = 4 all the others having the value from pool;
  7. Go to Allocation>Define Allocation Step and create a new step ALLOC2- –Tab Type and and Allocation Type=Copy and Extension =Add;
  8. 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;
  9. On Target Tab , specify the value for Business unit =TEST and project = 4;
  10. On Offset Tab, specify the value project = 4 all the others having the value from pool;
  11. Go to Allocation>define Allocation>Define Allocation group and create a new group with the 2 allocation steps;
  12. 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;
  13. 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;
  14. Check the tree DEPARTMENTS under the setid SHARE and tree node FIN_GRP ( Tree manager>Tree manager ) . It will have the values 13000-13999;
  15. Enter 3 journals for the 3 BU : US001, US003 and US004 with at least 1 with the foreign currency;
  16. Run Allocation process : Allocations>define and Perform Allocations >Request Allocation;
  17. Error message appears; 

 

Check the following Replication document

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
Cause
Solution
References


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