11i.AD.I.6 Fails with Error “Pls-00302: Component ‘Is_patch_applied2′ Must Be Declared”

Posted by: Edi Yanto on: January 7, 2009

• In: Oracle
• Comment!

When attempting to apply Patch 6502082 – 11i.AD.I.6, the following error occurs

AutoPatch error:
Error while executing statement

AutoPatch error:
ORA-06550: line 3, column 10:
PLS-00302: component ‘IS_PATCH_APPLIED2′ must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

The issue is caused by the following setup:

Following package versions for package APPS.AD_PATCH are not created.
$AD_TOP/patch/115/sql adphpchb.pls   115.16
$AD_TOP/patch/115/sql adphpchs.pls   115.11

To implement the solution, please execute the following steps:
1. Go to $AD_TOP/patch/115/sql
2. Check the version of adphpchs.pls and adphpchb.pls
adident Header $AD_TOP/patch/115/sql/adphpch*.pls
It should be -
$AD_TOP/patch/115/sql/adphpchs.pls (version 115.11)
$AD_TOP/patch/115/sql/adphpchb.pls (version 115.16)

3. If it is not there, run them from <patch-top-directory>/ad/patch/115/sql
4. Once the proper versions are available, run them from sqlplus as APPS user
SQL> @adphpchs.pls
SQL> @adphpchb.pls

5. Check the version and status once again
SQL> select status, object_type, owner from dba_objects where object_name = ‘AD_PATCH’;
SQL> select text from dba_source where line = 2 and name = ‘AD_PATCH’;

6. Retest adpatch from beginning
7. Migrate the solution to appropriate environment

Reference: Doc ID 556785.1

Tags: AD_PATCH, ebiz, troubleshooting