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.
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
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
The issue can be reproduced at will with the following steps:
1. Apply NLS patches
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