05 July 2017

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
/u02/applgstR12/apps/apps_st/appl/admin/FMSGST/log/adadmin.log

for errors.

Solution:

The AD_JAR object not available in apps schema.

sqlplus apps/apps @$AD_TOP/patch/115/sql/ADJRIS.pls

sqlplus apps/apps @$AD_TOP/patch/115/sql/ADJRIB.pls

Run the below SQL to see whether objects are valid

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

rerun the adadmin again.

Reference: ADOP Fails With Error "PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared" (Doc ID 1610328.1)

No comments: