Search Accounts Payable invoices in Oracle Fusion. Examples: search_invoices({"supplier": "google"}) finds invoices from Google. search_invoices({"invoice_number": "INV-001"}) finds a specific invoice. search_invoices({"date_from": "2024-01-01", "date_to": "2024-03-31"}) finds invoices in Q1 2024.

Get full details for a single AP invoice by its numeric InvoiceId.

Search Accounts Payable payments in Oracle Fusion.

Get full details for a single AP payment by its numeric PaymentId.

List Accounts Payable payment terms defined in Oracle Fusion.

Search purchase orders in Oracle Fusion Procurement.

Get full details for a single purchase order by its numeric POHeaderId, including lines.

Search supplier master data in Oracle Fusion. Note: Status is not filterable via the Oracle REST API.

Get full details for a single supplier by its numeric SupplierId, including sites, contacts, and addresses.

Search purchase requisitions in Oracle Fusion.

Look up a goods receiving receipt by its receipt number. Receipt number is REQUIRED by the Oracle API.

Search the approved supplier list in Oracle Fusion Procurement.

Search procurement browsing categories in Oracle Fusion.

Search General Ledger journal batches in Oracle Fusion.

Get GL account balances. ALL parameters are REQUIRED by the Oracle API.

List defined ledgers in Oracle Fusion General Ledger.

List chart of accounts structures defined in Oracle Fusion.

Search daily currency exchange rates in Oracle Fusion.

Search Accounts Receivable invoices (customer billing) in Oracle Fusion.

Get full details for a single AR invoice by its numeric CustomerTransactionId.

Search AR receipts (customer payments received) in Oracle Fusion.

Search employee expense reports in Oracle Fusion. NOTE: May return 403 depending on service account privileges.

Search HCM user accounts in Oracle Fusion by username or email.

Test connectivity to Oracle Fusion REST API. Returns connection status and record counts. Use this first to verify the connection is working.

Compute an aggregate (sum, avg, min, max, median, count, count_nonnull) over a numeric field in a list of records. Use this for ANY arithmetic on Oracle Fusion data — do NOT compute sums, averages, or counts yourself. All math uses exact Decimal arithmetic to avoid float drift on currency values.

Conditional aggregation — like Excel SUMIF/COUNTIF/AVERAGEIF. Sum, count, or average a field where a condition matches. Operators: eq, neq, gt, gte, lt, lte, contains, startswith, in.

Group records by a field and aggregate another field per group. Like a SQL GROUP BY or Excel pivot. Returns sorted results with optional limit. Use for subtotals by supplier, business unit, status, etc.

Find a record by field value — like VLOOKUP/XLOOKUP. Returns the first match or all matches. Use for finding a specific invoice, supplier, etc.

Calculate each record's or group's share of the total for a numeric field. Optionally group by a field first. Returns percentages that sum to 100.

Divide two numbers with exact Decimal arithmetic. Returns null on divide-by-zero instead of erroring. Use for ratios, rates, per-unit costs.