Adding Event Triggers on RA_INTERFACE_LINES_ALL data creation

Eros Mario Nicotra

Hi,

I'm looking to intercept the creation of a record from the supply chain to account receivables (DOO source). Specifically, I need to trigger an action when the record has been created in the RA_INTERFACE_LINES_ALL table, which is a standard table in Oracle Fusion.

Thank you
Eros

Sumanth V -Oracle

@John Hung-Oracle - This thread should be moved to the OTBI community. Please consider and assist with this, ensuring the user receives the appropriate assistance.

J Reinhart

Hi Eros,

Try creating an event based Alert. You would specify that the Alert fires on insertion of data into ra_interface_lines_all and then the action(s) would be whatever you need to do. As always, test in a test instance first.

Technically, you could create a database event directly on the table also, but the alert approach keeps it visible and allows you to easily turn it off from the front end if the need should arise.

Regards,

J

Eros Mario Nicotra

Hi J Reinhart,

could you provide us an userguide to create the alert on insertion of a standard table?

Thanks

Eros