My Oracle Support Banner

When Upgrading, More then one Developer Primary Key is defined on table CN_PERIOD_TYPES_ALL. (Doc ID 2726447.1)

Last updated on NOVEMBER 09, 2020

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When upgrading from EBS 12.1.3 to 12.2, the following error occurs.

ERROR
-----------------------
Log file: /u300/xxxx/fs1/EBSapps/appl/admin/ONIX/log/US_cndictsys_ldt.log
Error calling FNDLOAD function.

The US_cndictsys_ldt.log contained in the zip file shows the following:  


Uploading from the data file /u300/xxxx/fs1/EBSapps/appl/cn/12.0.0/patch/115/import/US/cndictsys.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u300/xxxx/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afdict.lct(120.4.12020000.3), /u300/xxxx/fs1/EBSapps/appl/cn/12.0.0/patch/115/import/US/cndictsys.ldt) to staging tables
Dumping LCT file /u300/xxxx/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afdict.lct(120.4.12020000.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u300/xxxx/fs1/EBSapps/appl/cn/12.0.0/patch/115/import/US/cndictsys.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_TABLE CN SYSTEM CN_MODULES_ALL_B , FND_FOREIGN_KEY CN_PERIOD_STATUSES_ALL_FK1 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for FND_PRIMARY_KEY:  APPLICATION_SHORT_NAME = CN, BUILDING_BLOCK_NAME = SYSTEM, TABLE_NAME = CN_PERIOD_TYPES_ALL, PRIMARY_KEY_NAME = CN_PERIOD_TYPES_UK1,  ORA-20001: APP-FND-02003: More then one Developer Primary Key is defined on table CN_PERIOD_TYPES_ALL.

Changes

 Upgrade from EBS release 12.1.3 to 12.2.x

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


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