Patch 33664089 Errors On Jtfumsub.ldt - ORA-01422: exact fetch returns more lines than ordered (Doc ID 2868774.1)

Last updated on MAY 11, 2022

Applies to:

Symptoms

On applying the Patch 33664089, following errors are obtained when jtfumsub.ldt is executed.

ERROR
-----------------------
CURRENT SESSION_ID is : 228327512
CURRENT EDITION_NAME is : V_20211223_1358
 
Uploading from the data file /u11/EBS12.2/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/PL/jtfumsub.ldt
Altering database NLS_LANGUAGE environment to POLISH
Dumping from LCT/LDT files (/u11/EBS12.2/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfumr.lct(120.3), /u11/EBS12.2/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/PL/jtfumsub.ldt) to staging tables
Dumping LCT file /u11/EBS12.2/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfumr.lct(120.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u11/EBS12.2/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/PL/jtfumsub.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_UM_SUBSCRIPTIONS JTF_PRIMARYUSERUPGRADE 2001/09/19 12:44:05 , JTF_UM_SUBSCRIPTION_RESP JTF_PRIMARY_USER 690 2002/06/19 10:51:36 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  ORA-01422: dokładne pobranie zwraca większą liczbę wierszy niż zamówiono
  ORA-06512: przy "APPS.JTF_UM_SUBSCRIPTIONS_PKG", linia 453
ORA-06512: przy "APPS.JUMF_LCT_PKG", linia 546
ORA-06512: przy linia 335

Concurrent request completed

Note:
=======================
ORA-01422: dokładne pobranie zwraca większą liczbę wierszy niż zamówiono

means:
******
ORA-01422: exact fetch returns more lines than ordered
=======================

STEPS
1. Apply the patch: 33664089, and ensure to execute the jtfumsub.ldt, get the above mentioned errors.

Changes

Cause

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