Skip to content

Archive for

ORA-01422: exact fetch returns more than requested number of rows

When you’re doing clone of EBS 12.2, you may get below issue

INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. and Re-Run the entire cloning cycle , after fixing the problem.

Checked the logfile :

AutoConfig could not successfully execute the following scripts:
Directory: /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/LEBEBSDEV/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/LEBEBSDEV/fs2/inst/apps/EBSLEBBI_bid-leb-119-60/admin/install INSTE8_APPLY 1

AutoConfig is exiting with status 1

ERROR: RC-50014: Fatal: Execution of AutoConfig was failed
Raised by


I am trying to get node value


SQL> SELECT ad_zd_adop.get_node_type(‘node name’) from dual;
SELECT ad_zd_adop.get_node_type(‘node name’) from dual
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “APPS.AD_ZD_ADOP”, line 3062


Solution :


PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

Run autoconfig on database tier and application tier.