My Oracle Support Banner

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

Last updated on JUNE 06, 2024

Applies to:

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


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(
at oracle.jdbc.driver.T4CTTIoer11.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatemen => ORA-20942:
ORA-06512: at line 59


 No customization done to OOTB logic


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

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