okltxcodes.ldt errors with ORA-06512 and ORA-01427: single-row subquery returns more than one row

(Doc ID 2318738.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply a translation synchronization patch, or any patch with okltxcodes.ldt, the following error occurs in the log file (F_okltxcodes_ldt.log, with F being the language_code).

ERROR
-----------------------
Uploading from the data file /data/applgeos12d4/geos12d4/fs2/EBSapps/appl/okl/12.0.0/patch/115/import/F/okltxcodes.ldt
Altering database NLS_LANGUAGE environment to FRENCH
Dumping from LCT/LDT files (/data/applgeos12d4/geos12d4/fs2/EBSapps/appl/okl/12.0.0/patch/115/import/okltxcodes.lct(120.2), /data/applgeos12d4/geos12d4/fs2/EBSapps/appl/okl/12.0.0/patch/115/import/F/okltxcodes.ldt) to staging tables
Dumping LCT file /data/applgeos12d4/geos12d4/fs2/EBSapps/appl/okl/12.0.0/patch/115/import/okltxcodes.lct(120.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /data/applgeos12d4/geos12d4/fs2/EBSapps/appl/okl/12.0.0/patch/115/import/F/okltxcodes.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (ZX_FC_CODES_B 20228 SALES_TRANSACTION TRX_BUSINESS_CATEGORY , ZX_FC_CODES_DENORM_B TRX_BUSINESS_CATEGORY CONTRACT OBLIGATION BOOKING ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  ORA-06512: Ã ligne 672

When trying to execute this file from the command line the error also includes this:

Error loading seed data for ZX_FC_CODES_TL: CLASSIFICATION_ID = 33230, CLASSIFICATION_CODE = INSURANCE, CLASSIFICATION_TYPE_CODE = PRODUCT_CATEGORY, PARENT_CLASSIFICATION_CODE = , CLASSIFICATION_ID = 33230, ORA-01427: single-row subquery returns more than one row
Program completed successfully but some rows have errors - check log for details


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply a patch with okltxcodes.ldt.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply the patch

Changes

 

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