Overview
Oracle ERP Cloud (Fusion) is Oracle's flagship cloud ERP – GL, payables, receivables, procurement, projects, fixed assets. The Automize Oracle ERP Cloud connector covers these modules via REST.
- Regions: Multi-region OCI.
- Plans: Enterprise per-user.
Setting up the connection
Auth type: HTTP Basic.
- Oracle Fusion admin → Service user with API access + REST API privileges.
- In Automize → Settings → Connectors → Oracle ERP Cloud. Paste credentials + tenant URL.
Find your credentials at https://docs.oracle.com/en/cloud/saas/financials/.
Rate limits
Per-tenant.
Data model
Fusion ERP modules:
Tenant ─┬─ Suppliers + Customers
├─ GL Journals
├─ Payables (Invoices, Payments)
├─ Receivables (Invoices, Receipts)
├─ Procurement (Requisitions, POs)
├─ Projects (Tasks, Resources, Costs)
└─ Fixed AssetsAvailable operations
24 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Create Journal | General | Create a GL journal |
| Create AP Invoice | General | Create a payables invoice |
| Create Purchase Order | General | Create a purchase order |
| Create Requisition | General | Create a purchase requisition |
| Create Supplier | General | Create a supplier |
| Get ESS Job Status | General | Get ESS job status |
| Get Fixed Asset | General | Get fixed asset details |
| Get Journal | General | Get journal details |
| Get AP Invoice | General | Get payables invoice details |
| Get Project | General | Get project details |
| Get Purchase Order | General | Get purchase order details |
| Get AR Invoice | General | Get receivables invoice details |
| Get Supplier | General | Get supplier details |
| List Business Units | General | List business units |
| List Fixed Assets | General | List fixed assets |
| List GL Journals | General | List general ledger journals |
| List Ledgers | General | List ledgers |
| List AP Invoices | General | List payables invoices |
| List Projects | General | List projects |
| List Purchase Orders | General | List purchase orders |
| List Requisitions | General | List purchase requisitions |
| List AR Invoices | General | List receivables invoices |
| List Suppliers | General | List suppliers |
| Submit ESS Job | General | Submit an ERP integration job |
Operations
Create Journal
Create a GL journal
No input parameters.
Create AP Invoice
Create a payables invoice
No input parameters.
Create Purchase Order
Create a purchase order
No input parameters.
Create Requisition
Create a purchase requisition
No input parameters.
Create Supplier
Create a supplier
No input parameters.
Get ESS Job Status
Get ESS job status
| Parameter | Required | Type | Description |
|---|---|---|---|
Request Id request_id | Yes | text |
Get Fixed Asset
Get fixed asset details
| Parameter | Required | Type | Description |
|---|---|---|---|
Asset Id asset_id | Yes | text |
Get Journal
Get journal details
| Parameter | Required | Type | Description |
|---|---|---|---|
Journal Id journal_id | Yes | text |
Get AP Invoice
Get payables invoice details
| Parameter | Required | Type | Description |
|---|---|---|---|
Invoice Id invoice_id | Yes | text |
Get Project
Get project details
| Parameter | Required | Type | Description |
|---|---|---|---|
Project Id project_id | Yes | text |
Get Purchase Order
Get purchase order details
| Parameter | Required | Type | Description |
|---|---|---|---|
Po Id po_id | Yes | text |
Get AR Invoice
Get receivables invoice details
| Parameter | Required | Type | Description |
|---|---|---|---|
Invoice Id invoice_id | Yes | text |
Get Supplier
Get supplier details
| Parameter | Required | Type | Description |
|---|---|---|---|
Supplier Id supplier_id | Yes | text |
List Business Units
List business units
No input parameters.
List Fixed Assets
List fixed assets
No input parameters.
List GL Journals
List general ledger journals
No input parameters.
List Ledgers
List ledgers
No input parameters.
List AP Invoices
List payables invoices
No input parameters.
List Projects
List projects
No input parameters.
Tips
- Project Portfolio Management. Returns projects + tasks.
List Purchase Orders
List purchase orders
No input parameters.
Tips
- Procurement. Filter by supplier + status.
List Requisitions
List purchase requisitions
No input parameters.
List AR Invoices
List receivables invoices
No input parameters.
List Suppliers
List suppliers
No input parameters.
Submit ESS Job
Submit an ERP integration job
No input parameters.
FAQ
- REST vs SOAP?
- REST is preferred for new builds. Some niche services still SOAP-only.
- OIC vs direct REST?
- Oracle Integration Cloud (OIC) provides pre-built adapters + workflow. Direct REST gives control but more wiring.