My Oracle Support Banner

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.

Symptoms

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. 

 

 

Replication Steps:

1. Enter bills with interunit customers. 

2. Make the Bill in RDY status.

3. Run single action job BIJOB03.

 

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.