[ALRT] Event Alert

For Event alert, once you verified and saved it, Oracle will create a database trigger (db object) on the table you specified.

For example,

Table name in the Event alert is PO_ABC.

A database trigger will be created with name ALR_PO_ABC_UAR or ALR_PO_ABC_IAR. UAT denotes "Update After Record", whereas IAR denotes "Insert After Record".

Once Alert is fired, this database trigger will spawn (submit) a concurrent request with name starts with the table name, e.g. PO_ABC (Check Event Alert). The concurrent request will check SQL in Alert to determine whether to perform any action.