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 JANUARY 29, 2023

Applies to:

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
/<EBS_BASE>/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
(/<EBS_BASE>/fs1/apps/appl/okc/12.0.0/patch/115/import/okcpdfsd.lct (120.3.12020000.2),
/<EBS_BASE>/fs1/apps/appl/oks/12.0.0/patch/115/import/US/okspdfsd.ldt) to staging tables Dumping LCT file
/<EBS_BASE>/fs1/apps/appl/okc/12.0.0/patch/115/import/okcpdfsd.lct (120.3.12020000.2) into FND_SEED_STAGE_CONFIG Dumping LDT file
/<EBS_BASE>/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.

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

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