R12: AP: ORA-20000: ORA-01422: Exact Fetch Returns More Than Requested Number Of Records While Running adadmin Maintain Applications Database Entities
(Doc ID 2949126.1)
Last updated on MAY 23, 2023
Applies to:Oracle Payments - Version 12.2.10 and later
Information in this document applies to any platform.
While running adadmin Maintain Applications Database Entities > Create Grants and Synonyms worker is failing with below error.
ERROR at line 1:
ORA-20000: ORA-01422: exact fetch returns more than requested number of
In Synonyms Loop:do_apps_ddl(APPS,CREATE SYNONYM "IBY_DOCS_PAYABLE_GT" FOR
ORA-06512: at line 5
The issue can be reproduced at will with the following steps:
1. Initiate the Adadmin utility
2. Invoke the Create Grants and Synonyms task
3. Fails on above stated task
Due to this issue, Adadmin utility can not be completed
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