OK ODI Processing Fails with ConstraintViolationException: ORA-00001 Error

(Doc ID 2118364.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Knowledge - Version 8.6 to 8.6 [Release 8.6]
Information in this document applies to any platform.


On : version.

When executing the PKG-ORACLE_KNOWLEDGE_MAIN it will start the PKG_LOAD_DIM_STG_TABLES sub-package and fail with an error.

ODI-1240: Flow INT-LOAD_FACT_RECOMMENDATION_STG fails while performing a
Integration operation. This flow loads target table FACT_RECOMMENDATION_STG.
ODI-1228: Task INT-LOAD_FACT_RECOMMENDATION_STG (Integration) fails on the
target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DW_REPORTING.FACT_RECOMMENDATION_STG_PK) violate




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