REST API for Oracle Fusion Cloud Financials

Get Specific Details for Invoices

Your accounts payable user wants to view details for invoices they created. Specifically:

Invoice ID
Business unit
Supplier
Supplier site
Invoice number
Pay group

Example URL

Here's an example of the resource URL to display data from only the invoices resource:

GET

fscmRestApi/resources/11.13.18.05/invoices?fields=InvoiceId,BusinessUnit,Supplier,SupplierSite,InvoiceNumber,PayGroup&onlyData=true

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?fields=InvoiceId,BusinessUnit,Supplier,SupplierSite,InvoiceNumber,PayGroup&onlyData=true

Example Response

Here's an example of the response body in JSON format:

{
  "items": [
    {
      "InvoiceId": 361908,
      "BusinessUnit": "Vision Thailand- BU01 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617230-4",
      "PayGroup": null
    },
    {
      "InvoiceId": 361909,
      "BusinessUnit": "Vision Thailand- BU01 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617230-6",
      "PayGroup": null
    },
    {
      "InvoiceId": 361910,
      "BusinessUnit": "Vision Thailand- BU01 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617230-5",
      "PayGroup": null
    },
    {
      "InvoiceId": 300100171617230,
      "BusinessUnit": "Vision Thailand- BU01 New",
      "Supplier": "Vision Thailand Supplier",
      "SupplierSite": "Park66",
      "InvoiceNumber": "WHT_181016_1",
      "PayGroup": null
    },
    {
      "InvoiceId": 361911,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617251-3",
      "PayGroup": null
    },
    {
      "InvoiceId": 361912,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617251-4",
      "PayGroup": null
    },
    {
      "InvoiceId": 362908,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617263-3",
      "PayGroup": null
    },
    {
      "InvoiceId": 362909,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Thailand Tax Authority",
      "SupplierSite": "Tax Authority O",
      "InvoiceNumber": "Withholding tax - 300100171617263-4",
      "PayGroup": null
    },
    {
      "InvoiceId": 300100171617251,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Vision Thailand Supplier",
      "SupplierSite": "Park66",
      "InvoiceNumber": "WHT_181016_2",
      "PayGroup": null
    },
    {
      "InvoiceId": 300100171617284,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Vision Thailand Supplier",
      "SupplierSite": "Park66",
      "InvoiceNumber": "VAT_181016_2",
      "PayGroup": null
    },
    {
      "InvoiceId": 300100171617263,
      "BusinessUnit": "Vision Thailand- BU02 New",
      "Supplier": "Vision Thailand Supplier",
      "SupplierSite": "Park66",
      "InvoiceNumber": "VAT_181016_1",
      "PayGroup": null
    },
    {
      "InvoiceId": 300100166952340,
      "BusinessUnit": "Vertex BU",
      "Supplier": "Advanced Network Devices",
      "SupplierSite": "FRESNO 1",
      "InvoiceNumber": "AC_Test",
      "PayGroup": null
    },
    {
      "InvoiceId": 294895,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119154019-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119154390,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 004",
      "SupplierSite": "Gall P1 004BU01",
      "InvoiceNumber": "WHT_SC_TOT_02",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 293903,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119490486-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119154009,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 001",
      "SupplierSite": "Gall P1 001 B01",
      "InvoiceNumber": "WHT_P1_01",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 293895,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119154009-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 294896,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119154723-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119154807,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 001",
      "SupplierSite": "Gall P1 001 B01",
      "InvoiceNumber": "WHT_SC_ST_194A_01",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 293901,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119154807-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119490395,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 001",
      "SupplierSite": "Gall P1 001 B01",
      "InvoiceNumber": "WHT_SC_ST_194D_01",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 293902,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119490395-2",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119154019,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 004",
      "SupplierSite": "Gall P1 004BU01",
      "InvoiceNumber": "WHT_SC_TOT_01",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 300100119154723,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "Gallant P1 001",
      "SupplierSite": "Gall P1 001 B01",
      "InvoiceNumber": "WHT_SC_MT_01",
      "PayGroup": "Standard"
    },
    {
      "InvoiceId": 293896,
      "BusinessUnit": "Vision India - BU01",
      "Supplier": "India Tax Authority",
      "SupplierSite": "IL Tax BU01",
      "InvoiceNumber": "Withholding tax - 300100119154019-2-Canceled",
      "PayGroup": "Standard"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices",
      "name": "invoices",
      "kind": "collection"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoice",
      "name": "cancelInvoice",
      "kind": "other"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelLine",
      "name": "cancelLine",
      "kind": "other"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/validateInvoice",
      "name": "validateInvoice",
      "kind": "other"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/calculateTax",
      "name": "calculateTax",
      "kind": "other"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/generateDistributions",
      "name": "generateDistributions",
      "kind": "other"
    }
  ]
}