My Oracle Support Banner

NLS Patches After 12.2.9 Upgrade ends in error for amesappo_ldt ORA-01422 ORA-06512 (Doc ID 2629303.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Approvals Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

While applying NLS patches after 12.2.9 upgrade following error is raised during patching activity


ATTENTION: All workers either have failed or are waiting:

FAILED: file amesappo.ldt on worker 1.
FAILED: file amesappo.ldt on worker 2.
FAILED: file amesappo.ldt on worker 3.
FAILED: file amesappo.ldt on worker 4.
FAILED: file amesappo.ldt on worker 5.
FAILED: file amesappo.ldt on worker 6.
FAILED: file amesappo.ldt on worker 7.
FAILED: file amesappo.ldt on worker 8.


FNDLOAD APPS/***** 0 Y UPLOAD @AME:patch/115/import/amesappo.lct @AME:patch/115/import/F/amesappo.ldt - UPLOAD_MODE=NLS WARNINGS=TRUE


Uploading from the data file
/p01/foxtrotoltp/appl/fs1/EBSapps/appl/ame/12.0.0/patch/115/import/ZHS/amesapp
o.ldt
Altering database NLS_LANGUAGE environment to SIMPLIFIED CHINESE
Dumping from LCT/LDT files

.....................

Dumped the batch (AME_ACTION_TYPES production rule , AME_ACTIONS supervisory
level 7-  ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
ORA-01422: The number of rows actually returned exceeds the number of rows requested;
ORA-06512: exact fetch returns more than requested number of rows; "APPS.AME_ACTION_TYPES_API", line 459
ORA-06512: at line 252



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply NLS patches
 




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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