Autoconfig Error during SETUP Phase (Oracle Applications DBA 11i)

Autoconfig failed during setup phase:

While running the script adgendbc.sh

Unable to update GUEST_USER_PWD in database to GUEST/ORACLE1 –
java.sql.SQLException: ORA-06550: line 1, column 323:
PLS-00201: identifier ‘FND_VAULT.PUT’ must be declared
ORA-06550: line 1, column 323:
PL/SQL: Statement ignored

Cause

AdminAppServer.java 115.32 calls fnd_app_server_pkg.update_server passing 5 parameters.
The versions of FND_APP_SERVER_PKG (AFSCASRS.pls/AFSCASRB.pls) accepts 5 parameters.

These version used in the database is older than the version at OS filesystem level.

Solution

1. Run following SQL query :

select text
from all_source
where name =’FND_APP_SERVER_PKG’ and line < 7;

2. If the versions in the database are older than the ones at the OS level, go to the

$FND_TOP/patch/115/sql directory and recreate the spec/body by running :

– sqlplus apps/<passwd> @AFSCASRS.pls

– sqlplus apps/<passwd> @AFSCASRB.pls

3. Rerun Autoconfig.

3 thoughts on “Autoconfig Error during SETUP Phase (Oracle Applications DBA 11i)”

  1. In this regard, Database Performance Management System could allow the upgrade to be performed in a much easier manner, simultaneously ensuring that the existing activities related to the system database aren't much affected in the upgrade process.dbdesigner.net

  2. I’ve really noticed that credit improvement activity should be conducted with tactics. If not, you might find yourself endangering your ranking. In order to succeed in fixing your credit ranking you have to make sure that from this minute you pay any monthly costs promptly in advance of their booked date. It’s really significant on the grounds that by not necessarily accomplishing that area, all other steps that you will take to improve your credit rating will not be efficient. Thanks for expressing your thoughts.

Leave a Reply

Your email address will not be published. Required fields are marked *