ad_zd_prep is invalid with compilation errors
RDBMS : 12.1.0.2
Initial Version of R12: R12.1.3
As per Doc #E73540-03 Upgrading database R12.0 and R12.1 to R12.2 (started with R12.1.3)
Can I ignore and continue to apply the "Online Patching Enablement Patch, 13543062 R12.AD.C" ?
SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_PREP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1385/6 PL/SQL: SQL Statement ignored
1388/14 PL/SQL: ORA-00942: table or view does not exist
1432/5 PL/SQL: Statement ignored
1432/26 PLS-00364: loop index variable 'R_TYPE' use is invalid
SQL>
-------
As per Doc# 1681051.1:
select * from ad_bugs
where bug_number = 17903664; exists : Looks like, it got created during the R12.2 upgrade portion