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.
[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0.5” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]
[edsanimate_end]