Oracle ERP Cloud
Connect Riff to Oracle ERP Cloud to build procurement apps and agents on live purchasing, receiving, and payables data.
Connect Riff to Oracle ERP Cloud (Fusion) to give your apps and agents live access to purchase orders, receipt transactions, supplier records, and AP invoices.
What you connect
Riff connects to Oracle ERP Cloud using its REST APIs (available from Oracle Fusion). Authentication uses OAuth 2.0 via Oracle IDCS (Identity Cloud Service) or Basic Authentication with a service account.
Credentials needed:
Oracle ERP Cloud base URL
Your Oracle instance URL (e.g. https://yourcompany.fa.us2.oraclecloud.com)
OAuth Client ID + Secret
Oracle IDCS → Applications → Confidential Application
Token endpoint
https://yourinstance.identity.oraclecloud.com/oauth2/v1/token
Username / Password (Basic Auth)
Service account created in Oracle Security Console
What your apps and agents can read
Purchase Orders
/fscmRestApi/resources/.../purchaseOrders
Confirmation status, delivery dates, line items
Receipt Transactions
/fscmRestApi/resources/.../receivingReceiptRequests
Goods received, quantity variances
Suppliers
/fscmRestApi/resources/.../suppliers
Supplier contacts, payment terms, certifications
AP Invoices
/fscmRestApi/resources/.../invoices
Invoice headers, match status, payment status
Purchase Order Lines
/purchaseOrders/{id}/child/lines
Line-level status, quantities, prices
Cost Centres
/fscmRestApi/resources/.../costCenters
Budget vs. actuals by cost centre
What your agents can do
Monitor PO confirmation
Query POs awaiting supplier acknowledgement → chase by Outlook
Delivery tracking
Read scheduled vs. actual delivery dates → flag late lines
Three-way match
PO → receipt → invoice comparison; auto-approve clean matches
Supplier performance
Calculate on-time delivery and invoice accuracy rates by supplier
Exception escalation
Route discrepancies to the right buyer or AP clerk with full context
App use cases
Supplier Delivery Dashboard
Build an App connected to Oracle ERP Cloud that shows open PO lines by supplier with promised delivery date, days remaining, and receipt status. Procurement managers see at a glance which lines are at risk — and can send a chase directly from the app without needing an Oracle login.
AP Invoice Matching Queue
Display pending invoices with their PO and receipt data side by side. AP clerks see exactly which lines match and which have variances. One-click to approve matched batches; exceptions go to a review queue with full context.
Supplier Performance Scorecard
Pull delivery performance, invoice accuracy, and dispute rate from Oracle ERP Cloud by supplier over a rolling 12-month window. Rank suppliers by composite score. Exportable for supplier review meetings.
Agent use cases
PO Confirmation Chaser
Trigger: Daily at 07:00 Input: Open POs in Oracle with no supplier acknowledgement, older than 2 business days Action: Send confirmation request to supplier contact on record via Outlook Output: Log supplier response back to Oracle; escalate non-responses to buyer; summary digest to Slack
Invoice Matching Agent
Trigger: New invoice event (webhook) or daily at 06:00 Input: AP invoice lines from Oracle Action: Three-way match against PO lines and receipt quantities Output: Auto-approve clean matches; queue exceptions for AP review with variance detail
Delivery Exception Monitor
Trigger: Daily at 06:30 Input: Open PO lines with delivery date before today and no receipt posted Action: Group by supplier and site; calculate financial exposure Output: Exception report to procurement manager; individual chase emails to suppliers
Connecting Oracle ERP Cloud in Riff
In Oracle Security Console, create a service account with read access to Procurement and Payables modules
(Recommended) In Oracle IDCS, create a confidential application to get OAuth credentials
Open Secrets in Riff and store your base URL, Client ID, and Client Secret
In your app or agent, reference the secrets to authenticate and call the Oracle REST API
Ask your agent: "Read all open purchase orders from Oracle ERP Cloud where the acknowledged delivery date is before today and no receipt has been posted"
Oracle Cloud version: These REST resources are available on Oracle ERP Cloud (Fusion) 24B and later. For older versions, REST endpoint paths may differ — check your Oracle documentation for the correct version-specific paths.
Last updated
Was this helpful?