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:

Credential	Where to find it
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

Oracle object	REST resource	Common use
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

Action	Example
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

1. In Oracle Security Console, create a service account with read access to Procurement and Payables modules

2. (Recommended) In Oracle IDCS, create a confidential application to get OAuth credentials

3. Open Secrets in Riff and store your base URL, Client ID, and Client Secret

4. In your app or agent, reference the secrets to authenticate and call the Oracle REST API

5. 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.