ALTER TABLE APPLSYS.FND_JAF_ASYNC_QUEUE ADD CONSTRAINT "SYS_C001108447" PRIMARY KEY ( SEQUENCE_NO ) Error message is ORA-02260: table can have only one primary key (Doc ID 2180024.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Applications DBA - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Upgrade related issues

When applying the 12.2.4 upgrade (adop phase=apply apply_mode=downtime patches=17919161,21900859,21540405,19829320,20226944 merge=yes) worker fails with the following error:

ERROR
-----------------------
Error in executing statement ALTER TABLE APPLSYS.FND_JAF_ASYNC_QUEUE ADD CONSTRAINT "SYS_C001108447" PRIMARY KEY ( SEQUENCE_NO ) Error message is ORA-02260: table can have only one primary key
Applying XDF file : .../product/r122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/xdf/fnd_eid_dff_reg.xdf

 

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