My Oracle Support Banner

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 JULY 16, 2018

Applies to:

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

Symptoms

When:

  1. Attempting to apply patch 17266068:R12.JE.B the following errors occur
  2. Trying to upgrade to R12.2.x (from 12.1.x) with standard upgrade dcoument the following error occur
  3. Applying JE/JG feature patches the following error 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


 

Changes

 

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
Changes
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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