R12: Error Loading Seed Data For ZX_FC_CODES_B; ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated (Doc ID 2135624.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Financials for EMEA - Version 12 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply patch 17266068:R12.JE.B the following errors occur:

ERROR
+---------------------------------------------------------------------------+

Uploading from the data file /euu01/EBSEUSA/apps/apps_st/appl/je/12.0.0/patch/115/import/US/je12atbc.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/euu01/EBSEUSA/apps/apps_st/appl/je/12.0.0/patch/115/import/je12atbc.lct(120.0.12010000.4), /euu01/EBSEUSA/apps/apps_st/appl/je/12.0.0/patch/115/import/US/je12atbc.ldt) to stage tables
Dump LCT file /euu01/EBSEUSA/apps/apps_st/appl/je/12.0.0/patch/115/import/je12atbc.lct(120.0.12010000.4) into FND_SEED_STAGE_CONFIG
Dump LDT file /euu01/EBSEUSA/apps/apps_st/appl/je/12.0.0/patch/115/import/US/je12atbc.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (ZX_FC_CODES_B 21530 SALES_TRANSACTION TRX_BUSINESS_CATEGORY , ZX_FC_CODES_DENORM_B TRX_BUSINESS_CATEGORY MOD415_347PR INVOICE TYPE ) into FND_SEED_STAGE_ENTITY
Upload from stage tables
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37270, CLASSIFICATION_CODE = B, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37281, CLASSIFICATION_CODE = F, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37292, CLASSIFICATION_CODE = B, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37303, CLASSIFICATION_CODE = F, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37347, CLASSIFICATION_CODE = A, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 37369, CLASSIFICATION_CODE = G, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 39228, CLASSIFICATION_CODE = B, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347PR, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
Error loading seed data for ZX_FC_CODES_B: CLASSIFICATION_ID = 39229, CLASSIFICATION_CODE = F, CLASSIFICATION_TYPE_CODE = TRX_BUSINESS_CATEGORY, PARENT_CLASSIFICATION_CODE = MOD415_347PR, ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated


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