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 FEBRUARY 19, 2019

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 document 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

    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.