Setting up event Alert on custom table
I appologize for placing my question in probably the wrong forum, but I know you guys are the sharpest and I'm spent on this problem.
Overview: I have a form that runs a report to print out some of the form's data. If the user wants to email that same data, after the print job is completed, the form updates a table with the output file name created by running the report. Here's where my problem comes in... I'm trying to create an event driven alert, but I get the below error when I go to save:
--------------------------------------------------
Event Table : REPORT_HDRS
ORACLE ID : APPS
The listed ORACLE ID is missing the event table or does not have the correct privileges to Application Object Library or Oracle Alert objects.
Please verify that the event table exists, or re-register the ORACLE ID with Application Object Library as necessary. Then re-enable (or disable)
the event alert as desired.
If the ORACLE ID is for a shared installation of an application, it may be normal for the event table to not be present.
--------------------------------------------------
Any ideas as to what I'm missing would be greatly appreciated.