Event based alerts

[Harry]

Hi,
During Ebiz upgrade from R12.1 to R12.2.3,what happens to  custom event based alerts,do they need to be recreted or they are saved.
while deininting alert table is mentioned,but where is rigger created on editioned view or table.

Thanks
Harry

[ErmanArslansOracleBlog]

Did you check the Upgrade guide?

For example in here ->

Oracle® E-Business Suite
Upgrade Guide
Release 12.0 and 12.1 to 12.2
 Part No. E73540-08

The instruction about alerts is clear.
Here it says:
drop all event alert database triggers in custom schemas, run the alrdtrig.sql script,
located in $ALR_TOP/patch/115/sql. Re-create the triggers after the upgrade is
complete.

As for your trigger-editioned view related question, I didn't check it yet, I have found some info in "Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)"..
I checked this document , because it is related and here is what I found ->

A table trigger must be on the editioning view (EV), not the table, if the editioning view exists. (dbcc: SECTION-13) [minimal]

Triggers on tables will be automatically moved to the corresponding editioning view during the Release 12.2 upgrade. For information on editioning views, see: Oracle Database Advanced Application Developer's Guide.