What is an Oracle Fusion API Explorer?
Oracle Fusion Cloud exposes thousands of REST API endpoints across its product modules: HCM (Human Capital Management), FSCM (Financials and Supply Chain Management), BPM (Business Process Management), CRM, and more. Finding the right endpoint, understanding its query parameters, constructing a valid q filter, selecting the right finder, and navigating child API relationships takes significant time when done manually through the online documentation.
An Oracle Fusion API Explorer is a dedicated tool that puts all of that in one place — with search, schema browsing, visual query building, and live request testing — without switching between browser tabs, terminal windows, or sprawling PDF specifications.
How OPAL API works
OPAL (Oracle Platform API Lab) ships with the full Oracle Fusion Cloud REST API specification pre-indexed in a local SQLite database. No internet connection is required to search or browse. The index covers over 59,000 endpoints and is updated with each OPAL release to track Oracle's latest published specifications.
Search Oracle Fusion REST API endpoints
Type any keyword — resource name, field name, HTTP method, or description fragment — into the search bar. OPAL returns matching Oracle Fusion REST API endpoints in under 200 ms, showing the method, path, summary, and parameter count. Click any result to open the full endpoint detail: path parameters, query parameters, request body schema, and response schema.
Build q filters visually
Oracle Fusion REST APIs accept a q query parameter for server-side filtering. The syntax varies by endpoint and field type, and valid fields are buried in the specification. OPAL's Q Builder surfaces only the queryable fields for the selected endpoint, lets you choose an operator, type a value, and generates the complete q= expression — no documentation lookup, no syntax memorization.
For example, filtering GET /workers by active status and person number produces: q=ActiveFlag=Y;PersonNumber=EMP-10042. OPAL generates and encodes this automatically.
Use finders
Finders are named query patterns built into Oracle Fusion REST APIs that replace complex q expressions with a finder name and a set of bound parameters. Common finders include PrimaryKey, findByPersonId, and findReports. OPAL's Finder Builder lists the available finders for each endpoint and shows the required parameters — you fill in the values and OPAL generates the full URL.
Navigate child APIs
Oracle Fusion REST API responses often include links to child resources. A parent resource like /workers has child APIs for assignments, payrolls, addresses, and more. OPAL displays these child API relationships inline on the endpoint detail panel so you can jump directly to a child resource — with its own q fields, finders, and schema — without manually constructing paths or cross-referencing the specification.
Test live requests
Pro users can send authenticated REST API requests directly from OPAL to their Oracle Fusion Cloud instance. Set up an environment once with your instance URL and credentials — stored locally, encrypted with AES-256-GCM, never sent to any external server — then send requests with one click. Responses are displayed in a structured tree view or raw JSON. Copy the full request as a cURL command or chain it into a multi-step flow.
Who is OPAL API for?
- → Oracle Fusion integration developers — building and maintaining HCM, FSCM, and BPM REST API integrations.
- → Oracle HCM and FSCM consultants — exploring endpoints and building queries for client implementations.
- → HR IT and Finance IT teams — building or maintaining integrations without dedicated API tooling.
Try OPAL API free
Download OPAL API and get immediate access to 59,000+ Oracle Fusion REST API endpoints — no account, no internet connection required. The free tier includes the full endpoint catalog, Q Builder, Finder Builder, and schema viewer.