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 21, 2019

Applies to:

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


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.




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.