ADOP Fails With Error “PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

When applying ADOP patch getting below error.,

AutoPatch 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


Solution:

Step 1:
Please login as applmgr.
Source the application RUN environment file.

Step 2:


 cd $AD_TOP/patch/115/sql/


check below files are present in the location.,
1.ADJRIS.pls

2. ADJRIB.pls


if these files are present in the above path , Login to database as apps database user and run below 2 SQL’s

incase the files are not present in the location then apply patch 1702376 and then re execute the patch.

  • September 28, 2018 | 16 views
  • Comments