PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

ERROR

PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

AD code level : [B.3]

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

AD Administration 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

AD Administration error:

Unable to get passwords from Vault

You should check the file
/u01/apps/apps_st/appl/admin/log/adadmin.log

for errors.

SOLUTION

1. $sqlplus apps/apps

2. SQL>@$AD_TOP/patch/115/sql/ADJRIS.pls

3. $sqlplus apps/apps

4. SQL>@$AD_TOP/patch/115/sql/ADJRIB.pls

Now, Run the below SQL to see whether objects are valid

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

rerun the adadmin again.