Oracle Fusion predefined reports
Updated
info
This connector is currently in Early Access. Contact support for details.
The Oracle Fusion Cloud Applications source in Data Integration comes with the following predefined reports, covering Financials (AP, GL, AR), Procurement (Suppliers), and Supply Chain Management (Item Costs).
Accounts Payable
| Report | Description | Sync type |
|---|---|---|
| AP Invoices | Invoice headers. | Incremental on Last Update Date |
| AP Invoice Lines | Invoice line items, retrieved expanded on the invoices call. | Incremental on Last Update Date |
| AP Invoice Distributions | GL distribution splits for each invoice line, retrieved expanded on the invoices call. | Incremental on Last Update Date |
| AP Invoice Installments | Payment due-date schedule for each invoice, retrieved expanded on the invoices call. | Incremental on Last Update Date |
Suppliers
| Report | Description | Sync type |
|---|---|---|
| Suppliers | Supplier headers. | Incremental on Last Update Date |
| Supplier Sites | Pay sites with payment terms and method, retrieved expanded on the suppliers call. | Incremental on Last Update Date |
| Supplier Addresses | Supplier address geography, retrieved expanded on the suppliers call. | Incremental on Last Update Date |
General Ledger
| Report | Description | Sync type |
|---|---|---|
| GL Journal Batches | Journal batch headers. | Incremental on Last Update Date |
| GL Journal Headers | Journal headers (category, source, period, posting status), retrieved expanded on the journal batches call. | Incremental on Last Update Date |
| GL Journal Lines | Journal debit/credit lines, retrieved expanded two levels deep on the journal batches call. | Incremental on Last Update Date |
| GL Journal Categories | List of valid journal categories. | Full refresh |
| GL Journal Sources | List of valid journal sources. | Full refresh |
| GL Ledgers | Ledgers and ledger sets visible to your integration user's Data Access Set. Feeds the Ledgers filter on GL Ledger Balances. | Full refresh |
| GL Ledger Balances | Account balances. Requires selecting Ledgers and Accounting Periods; runs once per ledger × accounting period combination. Optionally filter by amount type, currency type, balance detail mode, and the 10,000-record validation bypass. | Full refresh per run (re-pulled every time, no Last Update Date on this resource) |
| GL Account Combinations | Valid account combinations (chart of accounts code combinations). | Full refresh |
| GL Accounting Periods | Accounting periods. Feeds the Accounting Periods filter on GL Ledger Balances. | Full refresh |
| GL Accounting Period Statuses | Open/closed status of each accounting period. | Full refresh |
Accounts Receivable
| Report | Description | Sync type |
|---|---|---|
| AR Invoices | Receivables invoice headers. | Incremental on Last Update Date |
| AR Invoice Lines | Receivables invoice line items (revenue by product/category), retrieved expanded on the AR invoices call. | Incremental on Last Update Date |
| AR Invoice Distributions | Receivable/revenue/tax/freight account splits, retrieved expanded on the AR invoices call. | Incremental on Last Update Date |
| AR Invoice Installments | Payment due-date schedule for each AR invoice, retrieved expanded on the AR invoices call. | Incremental on Last Update Date |
| AR Transaction Types | List of valid receivables transaction types. | Full refresh |
Supply Chain Management
| Report | Description | Sync type |
|---|---|---|
| Item Costs | Item cost records across cost organizations and cost books. | Full refresh |
Known limitations
- Every AP, AR, Supplier, and GL Journal report filters on a Last Update Date range. Each report's date range narrows calls to its own parent resource — AP Invoice Lines/Distributions/Installments, Supplier Sites/Addresses, and GL Journal Headers/Lines all use the same date range as their parent header report, since they're retrieved expanded on that same call rather than fetched separately.
- GL Ledger Balances has no Last Update Date and is re-pulled in full for every selected ledger/period combination on every run — select only the ledgers and periods you actually report on.
- GL Ledger Balances' currency bind is hardcoded to USD; there's no picker since Oracle exposes no list-of-values endpoint for it.
- Item Costs has no filter exposed — it pulls the full cost set every run, since Oracle documents no list-of-values endpoint for cost organization/cost book/item to filter on.
If you need a report or object that isn't currently supported, contact support so it can be evaluated for a future release.
