adadmin worker fails on adappsgs.pls

Posted by VinodN on Jun 10, 2024; 12:42pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adadmin-worker-fails-on-adappsgs-pls-tp12564.html

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