OBIA 7964 SIL_PayTypeDimension 'ORA-00001: unique constraint' Error Message Due To Duplicate Records (Doc ID 1997185.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

BI Apps 7.9.6.4 ETL failes in the SIL_PayTypeDimension mapping with the following error :-

Mar 15 21:01:14 2015
2015-03-15 21:01:14 : ERROR : (17010 | WRITER_1_*_1) : (IS | OBIUAT5_7964_Integration_service) : node01_xxxxx.uk.local : WRT_8229 : Database errors occurred:
ORA-00001: unique constraint (OLAP.W_PAY_TYPE_D_U1) violated

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO W_PAY_TYPE_D(ROW_WID,W_PAY_TYPE_FLG,PAY_TYPE_CODE,PAY_TYPE_NAME,PAY_TYPE_DESC,W_PAY_TYPE_GRP_CODE,W_PAY_TYPE_GRP_DESC,PAY_TYPE_CAT_CODE,PAY_TYPE_CAT_NAME,PAY_TYPE_CAT_DESC,COMP_FLG,TAXABLE_FLG, PENSION_COMP_FLG,ACTIVE_FLG,CREATED_BY_WID,CHANGED_BY_WID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,SRC_EFF_FROM_DT,SRC_EFF_TO_DT ,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,DELETE_FLG,CURRENT_FLG,W_INSERT_DT,W_UPDATE_DT,DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_PAY_TYPE_D(ROW_WID,W_PAY_TYPE_FLG,PAY_TYPE_CODE,PAY_TYPE_NAME,PAY_TYPE_DESC,W_PAY_TYPE_GRP_CODE,W_PAY_TYPE_GRP_DESC,PAY_TYPE_CAT_CODE,PAY_TYPE_CAT_NAME,PAY_TYPE_CAT_DESC,COMP_FLG,TAXABLE_FLG, PENSION_COMP_FLG,ACTIVE_FLG,CREATED_BY_WID,CHANGED_BY_WID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,SRC_EFF_FROM_DT,SRC_EFF_TO_DT, EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,DELETE_FLG,CURRENT_FLG,W_INSERT_DT,W_UPDATE_DT,DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2015-03-15 21:01:14 : ERROR : (17010 | WRITER_1_*_1) : (IS | OBIUAT5_7964_Integration_service) : node01_xxxxx.uk.local : WRT_8425 : ERROR: Writer execution failed.
2015-03-15 21:01:14 : ERROR : (17010 | WRITER_1_*_1) : (IS | OBIUAT5_7964_Integration_service) : node01_xxxxx.uk.local : WRT_8114 :
Row # [1] in bad file

 

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