There's no dedicated Oracle EBS connector in Process Mining, but since Oracle EBS stores all its data in an Oracle Database, the Oracle Database connector is the correct and confirmed approach.
How to connect:
1. In Power Automate Process Mining, select Oracle Database as the data source
2. You'll need an on-premises data gateway installed on a machine that can reach your Oracle EBS database server. As of the June 2026 gateway release, the bundled Oracle Managed ODP.NET driver is enabled by default, so you no longer need to manually install the Oracle client on the gateway machine
3. Connect to the EBS database schema (typically APPS schema or a dedicated reporting schema)
For Process Mining specifically, the recommended approach is to create database views in Oracle EBS that expose the process event data in the format Process Mining expects (CaseId, Activity, Timestamp, plus any additional attributes). Querying the raw EBS tables directly works but the schema is complex. Views that pre-join the relevant tables make the Process Mining setup much cleaner.
For common EBS processes like Purchase to Pay or Order to Cash, look at Oracle's standard EBS reporting tables (e.g. PO_HEADERS_ALL, AP_INVOICES_ALL for P2P) to build your event log.
Best regards,
Valantis ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.
❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).
🏷️ For follow-ups @Valantis.
📝 https://valantisond365.com/
