OBIA 7.9.6.x - SIL_SalesBookingLinesFact_Load_OrderLine_Credit Failes With ORA-00001: Unique Constraint (Doc ID 2014104.1)

Last updated on JANUARY 31, 2017

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.

Symptoms

OBIA 7.9.6.x with EBS R12.1.3

Informatica ETL job SIL_SalesBookingLinesFact_Load_OrderLine_Credit fails with the following error:

ORA-00001: unique constraint (BIAPPS.W_SLS_BKG_LN_F_U1) violated

The execution plan contains only "Enterprise Sales - Booking Lines & Order Lines" subject area so <Note 1203806.1> OBIA - SIL_SalesBookingLinesFact_Load_OrderLine_Debt Fails with ORA-00001, ORA-01452 or ORA-00054  does not help,

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