adadmin worker fails on adappsgs.pls

[VinodN]

Hi Erman,

Need your help on this issue:

sqlplus -s APPS/***** @/oraapp/EBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oraapp/EBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adappsgs.pls 1 APPLSYS APPLSYS APPS'
Connected.

PL/SQL procedure successfully completed.

begin
*
ERROR at line 1:
ORA-20000: ORA-01422: exact fetch returns more than requested number of
rows:create_grants_and_synonyms(1,APPLSYS,APPLSYS,APPS):
create_base_gs(APPLSYS,APPS): In Synonyms Loop:
ORA-06512: at line 5

We are on 12.2.10

[ErmanArslansOracleBlog]

Seems like you have a synonym problem in the database.

Go through the NOTE : 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)

This is just for giving you an idea, you got to find your own way, since you are getting this for create_grants_and_synonyms(1,APPLSYS,APPLSYS,APPS)