OBIA 11g Procurement Load Plan Is Throwing Unique Constraint Error In SIL W_XACT_TYPE_D (Doc ID 1960786.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.7.1 DataWarehouse

When attempting to run the load for SIL W_XACT_TYPE_D the following error occurs.

ODI-1519: Serial step "Start Load Plan (InternalID:10446601)" failed because child step "Global Variable Refresh (InternalID:10447601)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:10447601)" failed because child step "Warehouse Load Phase (InternalID:11455601)" is in error.
ODI-1519: Serial step "Warehouse Load Phase (InternalID:11455601)" failed because child step "1 SIL Load (InternalID:11456601)" is in error.
ODI-1519: Serial step "1 SIL Load (InternalID:11456601)" failed because child step "2 SIL Dimension Group (InternalID:11457601)" is in error.
ODI-1519: Serial step "2 SIL Dimension Group (InternalID:11457601)" failed because child step "Parallel - Others (InternalID:11523601)" is in error.
ODI-1518: Parallel step "Parallel - Others (InternalID:11523601)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: 3 SIL Dims TRXTYPE_DIM (InternalID:11793601)
ODI-1519: Serial step "3 SIL Dims TRXTYPE_DIM (InternalID:11793601)" failed because child step "Finalize TRXTYPE_DIM (InternalID:11799601)" is in error.
ODI-1519: Serial step "Finalize TRXTYPE_DIM (InternalID:11799601)" failed because child step "EXEC_TABLE_MAINT_PROC (InternalID:11800601)" is in error.
ODI-1217: Session EXEC_TABLE_MAINT_PROC (4723601) fails with return code 20000.
ODI-1226: Step TABLE_MAINT_PROC fails after 1 attempt(s).
ODI-1232: Procedure TABLE_MAINT_PROC execution fails.
ODI-1228: Task TABLE_MAINT_PROC (Procedure) fails on the target ORACLE connection BIAPPS_DW.


You have checked for distinct rows in the Flow tab of SIL_TransactionTypeDimension Interface and re-generated the scenario in the package and regenerated the Loadplan after refreshing the datawarehouse but still giving the same error


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