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

MOSC Banner

Query re "Drop event alert triggers in custom schemas" step in 11.5.10.2 > 12.1.1 Upgrade

edited Aug 20, 2021 10:05AM in Install, Upgrade, Clone, Patch - EBS (MOSC) Question


Hi,

My query is regarding the above step which is Step 4 of the 'Database and System Administration Tasks' in the "Preparing for the Upgrade' chapter of the main Upgrade Guide.

We don't have any event alert triggers in any custom schemas, however we do have a custom defined event alert which has a trigger that is stored in user_triggers in the APPS schema.

The application that owns the alert is our own custom application but the application in the Event Details tab is Payables and the table the event fires on is AP_BANK_ACCOUNTS_ALL.

My question is, do we need to drop this trigger at this step as it is owned by our custom application, or will the upgrade handle it as it is firing against a seeded table in the APPS schema?

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