OBIA 11g - SIL Of W_PROJ_CLASSIFICATION_D Running Into "Unique Constraint" Error Every Time
Last updated on FEBRUARY 02, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.0 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.
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