> For the complete documentation index, see [llms.txt](https://docs.riff.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.riff.ai/integrations/native-integrations-v2/oracle-erp.md).

# Oracle ERP Cloud

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"*

{% hint style="info" %}
**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.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.riff.ai/integrations/native-integrations-v2/oracle-erp.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.