PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared

 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 <

Begin

ad_jar.get_jripasswords(:l_storepass, :l_keypass);

End;

> 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

ERROR:

ORA-04043: object AD_JAR does not exist

Solution:

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

@ADJRIS.pls

@ADJRIB.pls

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

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