Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

ad_zd_prep is invalid with compilation errors

edited Sep 6, 2018 11:21AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center