My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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