Authenticate using HTTP Basic auth with an Oracle Fusion Cloud user that has the appropriate data role (e.g., Accounts Payable Manager), or obtain a JWT via Oracle IDCS OAuth 2.0 client credentials flow if REST API OAuth is enabled for the pod.
Send a GET request to the Payables Invoices endpoint, typically at /fscmRestApi/resources/11.13.18.05/invoices (version segment may differ by pod; consult the REST API catalog for your release).
Use query parameters such as q=InvoiceStatus=UNPAID and fields=InvoiceId,InvoiceNumber,InvoiceAmount,Supplier to filter and project; use limit and offset for pagination.
Parse the 'items' array in the JSON response for invoice records; the 'hasMore' boolean and 'links' array contain pagination context.
For child collections (invoice lines, distributions) follow the child resource URLs in the 'links' array of each invoice object rather than constructing URLs manually.
Known gotchas
The REST API version segment in the URL path (e.g., 11.13.18.05) changes with quarterly Oracle Fusion updates; hard-coding it will break after upgrades — use the catalog discovery endpoint or make it a configurable parameter.
Basic auth over REST requires that the user's password not be expired and that the IP allowlist on the Oracle pod permits the calling host; OAuth is preferred for production integrations.
Field names in the REST API are camelCase and may differ from the corresponding FBDI column headers or BI Cloud Connector field names; always validate against the official REST API catalog for the specific pod version.
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp