ADADMIN With Error “PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared”

While running ADOP / ADPATCH the below error occurs:

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : *****

AutoPatch is verifying your username/password.
Connecting to APPS……Connected successfully.

Error: Unable to execute statement <
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
> len = 63

AutoPatch error:
ORA-06550: line 3, column 1:
PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

AutoPatch error:

Unable to get passwords from Vault

Possible Reasons:

The AD_JAR object not available in apps schema.
SQL> desc AD_JAR
ORA-04043: object AD_JAR does not exist


1. Please login as applmgr (Unix user that own application binaries )

2. Source the application environment file . (APPS.env)

3. cd $AD_TOP/patch/115/sql/

4. Login to database as apps database user and run below 2 SQL’s


5. Run the below SQL to see whether objects are valid

select owner,object_type,status from dba_objects where object_name=’AD_JAR’;

6. If AD_JAR is available under apps schema re-run the failed patch

  • January 10, 2017 | 33 views
  • Comments