R12.2 Autoconfig failing with ORA-06512

Error while running R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 81

In the proces of upgrading from R12.1.3 to R12.2.4. there is an error running autoconfig at database end

$ afdbprf.sh started

The environment settings are as follows …

ORACLE_HOME : /u01/oracle/product/11.2.0

ORACLE_SID : appsdb

PATH : /u01/oracle/product/11.2.0/perl/bin:/u01/oracle/product/11.2.0/perl/bin:/u01/oracle/product/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/product/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracrp1/bin:.

Library Path : /u01/oracle/product/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/product/11.2.0/lib:/usr/dt/lib:/u01/oracle/product/11.2.0/ctx/lib

Executable : /u01/oracle/product/11.2.0/bin/sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 4 23:09:23 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
begin
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at “APPS.ADX_PRF_PKG”, line 83
ORA-01403: no data found
ORA-06512: at line 7

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.


Solution:

1. Run adadmin–>Recreate Grants and Synonyms
2. Compile Apps Schema

This workaround will resolve the issue with autoconfig on the database side.