OBIA 12c: OOTB SILOS_SIL_INVENTORYPRODUCTDIMENSION Fails With ORA-00001: unique constraint Error During Incremental Load (Doc ID 2855165.1)

Last updated on OCTOBER 03, 2022

Applies to:

Symptoms

OOTB SILOS_SIL_INVENTORYPRODUCTDIMENSION Fails on Incremental Load when an Item associated to multiple Category ids and is in turn assigned under same category set & Organization
The session was failing with below error

<Field name="ErrorMessage" type="java.lang.String"><![CDATA[ODI-1217: Session SILOS_SIL_INVENTORYPRODUCTDIMENSION (98676) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Procedure-Diagnostics Raise Exception-Raise Diagnostic Error fails on the target connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: ODI-1228: Task Insert new dimension records-IKM BIAPPS Oracle Slowly Changing Dimension- fails on the target connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint () violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatemen => ORA-20942:
ORA-06512: at line 59

Changes

 No customization done to OOTB logic

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.