Autoconfig Error after clone in 12.1.3 Instance

ERROR

Running autoconfig on a cloned instance , the below mentioned error occurred:

PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

AutoConfig could not successfully execute the following scripts:
    Directory: /u01/ebs/oracle/inst/apps/test_mine/admin/install
      adadmprf.sh             INSTE8_PRF         1 

 

 

 

 

SOLUTION

1.RUN the Following given Query with APPS user and notedown the SID from Output:

• select applications_system_name from applsys.fnd_product_groups; 

2.Update the entry with target instance name:

•  update applsys.fnd_product_groups set applications_system_name = ‘<target instance>’; 

3.Run autoconfig again.