OBIA - SIL_SalesBookingLinesFact_Load_OrderLine_Debt Fails with ORA-00001, ORA-01452 or ORA-00054 (Doc ID 1203806.1)

Last updated on MARCH 03, 2015

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] to 7.9.6.4 [Release V7]
Information in this document applies to any platform.
This knowledge document is a replacement for 1439487.1, 1114403.1, 956362.1 & 1464476.1 which have been deleted

***Checked for relevance on 03-March-2015***

Symptoms

In Oracle BI Applications 7.9.6.x, SIL_SalesBookingLinesFact_Load_OrderLine_Debt load is failing with any of the following errors:

Database errors occurred:
ORA-00001: unique constraint (W_SLS_BKG_LN_F_U1) violated

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO W_SALES_BOOKING_LINE_F ...

OR

ANOMALY INFO::: Error while executing : CREATE INDEX:W_SALES_BOOKING_LINE_F:W_SLS_BKG_LN_F_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_SLS_BKG_LN_F_U1
ON
W_SALES_BOOKING_LINE_F

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

OR

DROP INDEX:W_SALES_BOOKING_LINE_F:W_SLS_BKG_LN_F_U1 has started.
ANOMALY INFO::: Error while executing : DROP INDEX:W_SALES_BOOKING_LINE_F:W_SLS_BKG_LN_F_U1
MESSAGE:::java.lang.Exception: Error while execution : DROP INDEX W_SLS_BKG_LN_F_U1
with error DataWarehouse:DROP INDEX W_SLS_BKG_LN_F_U1
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

 

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