All posts · General

Using Postman to Test Oracle Fusion REST APIs

Postman is the most effective tool for exploring and testing Oracle Fusion REST APIs before building OIC integrations or VBCS service connections.

Anurag Jangra · January 22, 2026 · 5 min read · ... views

Why Postman first, OIC second

Building an OIC integration against an Oracle Fusion REST API without first testing it in Postman is like writing code without reading the documentation. Postman lets you:

  • Explore the API response structure before committing to a schema
  • Test authentication without OIC overhead
  • Verify parameters, filters, and expand clauses work as expected
  • Save the working request as a reference for OIC configuration

Setting up OAuth authentication in Postman

  1. Create a new collection
  2. Under the collection’s Authorization tab: select OAuth 2.0
  3. Configure:
    • Token URL: https://your-idcs.identity.oraclecloud.com/oauth2/v1/token
    • Client ID and Secret: from your IDCS confidential application
    • Scope: the API scope (e.g. urn:opc:resource:consumer::all)
  4. Click Get New Access Token — Postman fetches and stores the token
  5. All requests in the collection use this token automatically

Testing a Fusion REST endpoint

GET https://your-fusion.fa.em2.oraclecloud.com/fscmRestApi/resources/latest/purchaseOrders
Authorization: Bearer {{access_token}}
Content-Type: application/json

Response 200 with JSON array — success. Response 401 — token issue. Response 403 — scope/role insufficient.

Using query parameters effectively

GET /purchaseOrders?q=Status='OPEN' and CreationDate>2026-01-01
                  &fields=PONumber,VendorName,TotalAmount,Status
                  &limit=10&offset=0
                  &orderBy=CreationDate:desc

Test each parameter individually to confirm the API behaves as expected. The fields parameter is critical — without it, Fusion returns dozens of fields you don’t need.

Saving the request as documentation

Once a request works, document it in the Postman collection with:

  • Description: what it does, when to use it
  • Example response: paste a sample
  • Parameter documentation: what each query param does

This becomes the team’s living API documentation and makes the OIC integration build much faster.

Postman environment variables

Create environments (dev, test, prod) with variables:

{
  "base_url": "https://dev-fusion.fa.em2.oraclecloud.com",
  "access_token": "{{auto-populated by OAuth}}",
  "org_id": "204"
}

Switch environments to test against different Fusion instances without changing requests.

Think Beyond the Implementation

Questions worth sitting with after reading this

01

Why is this architecture appropriate for this specific context — and where would it be the wrong choice?

02

What assumptions did we make that aren't stated explicitly? What happens if those assumptions are wrong?

03

What would break first if the requirements changed — volume doubled, a third system was added, or the deadline halved?

04

What alternatives did we reject, and why? Was the decision made on evidence — or habit?

AJ
Anurag Jangra
Oracle Cloud PaaS Consultant · OIC & VBCS Specialist

4.5+ years delivering enterprise Oracle Cloud integrations and VBCS applications across manufacturing, IT services, and financial sectors. OCI Certified — writes about real-world OIC, VBCS, SQL, and BI Publisher patterns from production experience.

Chat on WhatsApp