1. REST API Get Started V4REST API for Oracle Fusion Cloud Financials
  2. Use Cases
  3. Manage Payables Invoices
  4. Query Payables Invoices
  5. Get Specific Details for Invoices and Installments

Get Specific Details for Invoices and Installments

Your Accounts Payable Supervisor or Manager would like to view a limited set of information from both invoice header and installments. They are:
  1. Invoices:
    • Invoice ID
    • Invoice Number
    • Pay Group
  2. Invoice Installments:
    • Unpaid Amount
    • Payment Method

Example URL

Here's an example of the resource URL to display data from the invoices and invoice installments resources:

GET

/fscmRestApi/resources/11.13.18.05/invoices?expand=invoiceInstallments&fields=InvoiceId,InvoiceNumber,PayGroup;invoiceInstallments:UnpaidAmount,PaymentMethod&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?expand=invoiceInstallments&fields=InvoiceId,InvoiceNumber,PayGroup;invoiceInstallments:UnpaidAmount,PaymentMethod&onlyData=true

Example Response

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

{
  "items": [
    {
      "InvoiceId": 338908,
      "InvoiceNumber": "Withholding tax - 300100151967070-2",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 50,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 339908,
      "InvoiceNumber": "Withholding tax - 300100152264186-2",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 80,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 338909,
      "InvoiceNumber": "Withholding tax - 300100152264179-2",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 200,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 338910,
      "InvoiceNumber": "Withholding tax - 300100152264183-2",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 30,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 339909,
      "InvoiceNumber": "Withholding tax - 300100152264213-2",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 150,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100152264213,
      "InvoiceNumber": "TH_05",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100152264186,
      "InvoiceNumber": "TH_04",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100152264179,
      "InvoiceNumber": "TH_02",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100151967070,
      "InvoiceNumber": "TH_01",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100152264183,
      "InvoiceNumber": "TH_03",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 361908,
      "InvoiceNumber": "Withholding tax - 300100171617230-4",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 5,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 361909,
      "InvoiceNumber": "Withholding tax - 300100171617230-6",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 1,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 361910,
      "InvoiceNumber": "Withholding tax - 300100171617230-5",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 10,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100171617230,
      "InvoiceNumber": "WHT_181016_1",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 0,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 300100023308217,
      "InvoiceNumber": "Test1",
      "PayGroup": "Priority",
      "invoiceInstallments": [
        {
          "UnpaidAmount": 1000,
          "PaymentMethod": "Check"
        }
      ]
    },
    {
      "InvoiceId": 189097,
      "InvoiceNumber": "AP_RRF_CCU_I637",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 2925,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189098,
      "InvoiceNumber": "AP_RRF_CCU_I647",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3175,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189099,
      "InvoiceNumber": "AP_RRF_CCU_I648",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3200,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189100,
      "InvoiceNumber": "AP_RRF_CCU_I650",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3250,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189101,
      "InvoiceNumber": "AP_RRF_CCU_I656",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3400,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189102,
      "InvoiceNumber": "AP_RRF_CCU_I657",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3425,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189103,
      "InvoiceNumber": "AP_RRF_CCU_I659",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3475,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189104,
      "InvoiceNumber": "AP_RRF_CCU_I666",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3650,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189105,
      "InvoiceNumber": "AP_RRF_CCU_I668",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3700,
          "PaymentMethod": "Electronic"
        }
      ]
    },
    {
      "InvoiceId": 189106,
      "InvoiceNumber": "AP_RRF_CCU_I675",
      "PayGroup": null,
      "invoiceInstallments": [
        {
          "UnpaidAmount": 3875,
          "PaymentMethod": "Electronic"
        }
      ]
    }
  ],
  "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"
    },
    {
      "rel": "action",
      "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepayments",
      "name": "applyPrepayments",
      "kind": "other"
    }
  ]
}