Get Holds Information for Invoices Without Unique Invoice Number
Your accounts payables supervisor wants to view holds information for a specific invoice. However, the same invoice number exists for more than one supplier. They pass additional information in the request to fetch invoice holds for a unique combination of invoice number, supplier and business unit.
Example URL
Here's an example of the resource URL to display data from Invoice Holds REST API:
GET
/fscmRestApi/resources/11.13.18.05/invoiceHolds?q=InvoiceNumber=AND_Unmatched_Invoice;Supplier='Advanced Network Devices';BusinessUnit='Vision Operations'
cURL Command
curl --location --request GET 'https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds?q=InvoiceNumber=AND_Unmatched_Invoice;Supplier='Advanced Network Devices';BusinessUnit='Vision Operations'
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"HoldId": 300100187353833,
"InvoiceNumber": "AND_Unmatched_Invoice",
"BusinessUnit": "Vision Operations",
"Supplier": "Advanced Network Devices",
"LineHeld": null,
"HoldDate": "2020-05-29T06:53:19.001+00:00",
"HoldDetails": null,
"HoldReason": "Invoice amount exceeded limit.",
"ReleaseReason": null,
"WorkflowStatus": null,
"ReleaseName": null,
"HoldName": "Amount",
"ReleaseDate": null,
"HeldBy": "Kerry Jones",
"CreatedBy": "AP_SUPV_OPERATIONS",
"CreationDate": "2020-05-29T06:53:19.001+00:00",
"LastUpdateDate": "2020-05-29T06:59:59.079+00:00",
"LastUpdatedBy": "AP_SUPV_OPERATIONS",
"LastUpdateLogin": "A645FBE0336AF85CE0538C96F40A2399",
"PurchaseOrderNumber": null,
"PurchaseOrderLineNumber": null,
"PurchaseOrderScheduleLineNumber": null,
"ReceiptNumber": null,
"ReceiptLineNumber": null,
"ConsumptionAdviceNumber": null,
"ConsumptionAdviceLineNumber": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds/300100187353833",
"name": "invoiceHolds",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds/300100187353833",
"name": "invoiceHolds",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds/300100187353833/lov/HoldNameLookupVVO1",
"name": "HoldNameLookupVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds/300100187353833/lov/ReleaseNameVVO1",
"name": "ReleaseNameVVO1",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds/300100187353833/child/invoiceHoldDff",
"name": "invoiceHoldDff",
"kind": "collection"
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoiceHolds",
"name": "invoiceHolds",
"kind": "collection"
}
]
}