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

MOSC Banner

Invalid triggers FND_PROFILE_OPTION_VALUES+ and FND_LOOKUP_TYPES+ after upgrade to 12.2.11

edited Jan 2, 2022 6:11PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Trigger refers to function ad_zd.get_run_edition which does not exist.

Anyone find a patch for this?

EDIT: Upon trying to add further patches, trigger FND_LOOKUP_TYPES+ is also now invalid and trying to execute ad_zd.get_run_edition. ADOP session fails due to this.

FINAL EDIT:

R12.AD.C.DELTA.13 (Patchset)

$PATCH_TOP/32394134/ad/patch/115/sql/ADZDXS.pls

/* $Header: ADZDXS.pls 120.25.12020000.20 2021/03/13 16:12:43 jwsmith ship $ */

** Does NOT contain get_run_edition



Patch 33303547: PERFORMANCE ISSUE - FULL CLEANUP ACTION AFTER AN ACTUALIZE_ALL

$PATCH_TOP/33303547/ad/patch/115/sql/ADZDXS.pls

/* $Header: ADZDXS.pls 120.25.12020000.18.1221200.3 2021/10/27 13:22:24 vpalakur ship $ */

** DOES contain get_run_edition

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