OBIA 11g - SIL Of W_PROJ_CLASSIFICATION_D Running Into "Unique Constraint" Error Every Time (Doc ID 2119507.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

Running into "Unique Constraint" error for W_PROJ_CLASSIFICATION_D every time when the load is run. Also noticed:

1. There is no incremental logic defined for SDE of W_PROJ_CLASSIFICATION_D. So, every time when the load (incremental or Full) is run, all the data is getting loaded to the staging table.
2. IS_INCREMENTAL variable is Set to 'N' in the package of SIL of W_PROJ_CLASSIFICATION_D. So, even during an incremental load, the Knowledge Module is trying to Insert all the Rows that are loaded in SDE resulting in "Unique Constraint" 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