E-Business Suite 12.1.3 to 12.2 Upgrade Driver Fails On File okspdfsd.ldt With Worker Error 'Error loading seed data for OKC_PROCESS_DEFS: ID = 10007, ORA-1427: single-row subquery returns more than one row' (Doc ID 2150175.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

E-Business Suite 12.2 Applications DBA, Upgrade Related issues

 

 

 

During a 12.1.3 to 12.2 upgrade the patch driver fails on okspdfsd.ldt with the following errors in the worker log:
 

ERROR
-----------------------
Uploading from the data file
/u01/ebs/apps/fs1/apps/appl/oks/12.0.0/patch/115/import/US/okspdfsd.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/u01/ebs/apps/fs1/apps/appl/okc/12.0.0/patch/115/import/okcpdfsd.lct(120.
3.12020000.2),
/u01/ebs/apps/fs1/apps/appl/oks/12.0.0/patch/115/import/US/okspdfsd.ldt)
to staging tables
Dumping LCT file
/u01/ebs/apps/fs1/apps/appl/okc/12.0.0/patch/115/import/okcpdfsd.lct(120.3
.12020000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file
/u01/ebs/apps/fs1/apps/appl/oks/12.0.0/patch/115/import/US/okspdfsd.ldt
into FND_SEED_STAGE_ENTITY
Dumped the batch (OKC_PROCESS_DEFS 2 , OKC_PROCESS_DEFS 10608 ) into
FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for OKC_PROCESS_DEFS: ID = 10007, ORA-1427:
single-row subquery returns more than one row
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
NAME value changed to Check Investors(1)
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
DESCRIPTION value changed to Check Inventors(1)
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
NAME value changed to Check Investors(2)
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
DESCRIPTION value changed to Check Inventors(2)
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
NAME value changed to Check Investors(3)
Uploading seed data for OKC_PROCESS_DEFS: ID = 10023, Translatable column
DESCRIPTION value changed to Check Inventors(3)
Error loading seed data for OKC_PROCESS_DEFS: ID = 10023, ORA-1: unique
constraint (OKC.OKC_PROCESS_DEFS_B_U1) violated
Uploading seed data for OKC_PROCESS_DEFS: ID = 10024, Translatable column
NAME value changed to Check Managers(1)

Changes

 <Patch 22318703> was installed on the instance prior to the upgrade.

 

Note:

Pre-install <Patch 22318703>:R12.OKC.C has been removed from the list of pre-install patches in <Note 1448102.2> to avoid the problem going forward.

If <Patch 22318703> is not applied as part of the pre-install patches, the above failure during the upgrade should not occur.

If the upgrade is already started and patch 22318703:R12.OKC.C was applied, then patch 23229913:R12.OKS.C. will need to be installed after the upgrade.

To summarize:
1. If pre-install patch 22318703:R12.OKC.C is applied, the failure will occur and the post upgrade patch will be required.
2. If pre-install patch 22318703:R12.OKC.C is not applied the failure will not occur.

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