R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 83

In the proces of upgrading from R12.1.3 to R12.2.4. I encountered an issue with autoconfig on database side

Below is the excert from error log

afdbprf.sh started at Mon May 4 23:09:23 PDT 2016

The environment settings are as follows …
ORACLE_HOME : /dev/oracle/product/11.2.0
Library Path :
Executable : /dev/oracle/product/11.2.0/bin/sqlplus

SQL*Plus: Release Production on Mon May 4 23:09:23 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: Connected.

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 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
.end std out.
.end err out.


1. Run adadmin–>Recreate Grants and Synonyms

2. Compile Apps Schema

This has resolved the issue with autoconfig on the database side.

  • June 29, 2016 | 39 views
  • Comments