Event based trigger to capture change on any transaction

Question

Can we extract oracle data based on an event. Is it available only against few PVO or expose for all kinds of event - Like invoice creation, invoice update, invoice cancellation, GL creation, Intercompany etc.

We would like to keep our data warehouse in sync as soon as an update is made in Fusion.

Do we have any event based mechanism to generate the extracts.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28683/event-based-trigger-to-capture-change-on-any-transaction

Welcome to Oracle Analytics Community.

As per my knowledge, this is not supported for most of the transactions. Normally we schedule the extracts to sync the DWH.

Thanks.

Gaurav Kumar · Answer

Events are available for a lot of transactions and you can search in Oracle documentation for them.

For ex.

https://docs.oracle.com/en/cloud/saas/financials/25c/faipp/business-events-for-payables.html