Query re "Drop event alert triggers in custom schemas" step in 11.5.10.2 > 12.1.1 Upgrade
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?