Home / APPS DBA / PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

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.

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply