Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

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

AD_ZD_PREP invalid after AD 12.2 upgrade driver patch

Apr 24, 2017 1:43PM edited Aug 20, 2021 10:15AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

While upgrading from 12.1.3 to 12.2, I am getting the following two objects as invalid AD_ZD_PREP and AD_PATCH_ANALYSIS_ENGINE.

I copied the latest adgrants.sql (Version 120.67.12020000.36) to DB server and run it from sys user for APPS schema

Then applied the following two patches 10117518 and 22742061 after merging them as follow (README 10117518)

admrgpch -s ./AD_Source -d ./AD_Source/10117518_CUP7 -merge_name 10117518_cup7 -admode.

After the patch completed, I have two invalid objects which AD_ZD_PREP and AD_PATCH_ANALYSIS_ENGINE.

When I try to compile AD_ZD_PREP, I get the following error

SQL> alter PACKAGE AD_ZD_PREP compile body;Warning: Package Body altered with compilation errors.SQL> show errors

Tagged:

EBS-ATG-Upgrade

0

Howdy, Stranger!

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

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

Category Leaderboard

Top contributors this month