EBI9.2: For Interunit Bills the Billing Preload (BIPRELD) Process Abended at IU_PROCESSOR.U400.U400-010 with SQL Error: ORA-00001: unique constraint (SYSADM.PS_BI_ACCT_LN_STG2) violated
(Doc ID 2722541.1)
Last updated on JANUARY 12, 2021
Applies to:PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Preload (BIPRELD) is failing at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805 while trying to insert into PS_BI_ACCT_LN_STG2 table for interunit bills.
1. Enter bills with interunit customers.
2. Make the Bill in RDY status.
3. Run single action job BIJOB03.
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