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.

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply