Supported operations
| GET /invoiceHolds |
| GET /invoiceHolds/{id} |
| PATCH /invoiceHolds/{id} |
| POST /invoiceHolds |
Finders (1)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/invoiceHolds?finder=PrimaryKey Queryable q fields (28)
Only these fields can appear in a q filter expression on
/invoiceHolds. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/invoiceHolds?q=BusinessUnit='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| BusinessUnit | string | = != |
| ConsumptionAdviceLineNumber | number | = != |
| ConsumptionAdviceNumber | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| HeldBy | string | = != |
| HoldDate | string | = != |
| HoldDetails | string | = != |
| HoldId | integer | = != |
| HoldName | string | = != |
| HoldReason | string | = != |
| InvoiceNumber | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LineHeld | number | = != |
| Party | string | = != |
| PartyId | string | = != |
| PurchaseOrderLineNumber | number | = != |
| PurchaseOrderNumber | string | = != |
| PurchaseOrderScheduleLineNumber | number | = != |
| ReceiptLineNumber | integer | = != |
| ReceiptNumber | string | = != |
| ReleaseDate | string | = != |
| ReleaseName | string | = != |
| ReleaseReason | string | = != |
| Supplier | string | = != |
| WorkflowStatus | string | = != |
Child resources (1)
Each child is reachable at
/invoiceHolds/{id}/child/<name>
and most can also be inlined with expand.
invoiceHoldDff Response fields (29)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
BusinessUnitConsumptionAdviceLineNumberConsumptionAdviceNumberCreatedByCreationDateHeldByHoldDateHoldDetailsHoldIdHoldNameHoldReasonInvoiceNumberLastUpdateDateLastUpdateLoginLastUpdatedByLineHeldPartyPartyIdPurchaseOrderLineNumberPurchaseOrderNumberPurchaseOrderScheduleLineNumberReceiptLineNumberReceiptNumberReleaseDateReleaseNameReleaseReasonSupplierWorkflowStatusinvoiceHoldDff Build this query visually in OPAL
OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.
Related reference & reading
- /expenseProfileAttributes Get all records of a person's expense profile attributes
- /preferredCurrenciesLOV Get all currencies
- /jointVentureAccountingHeaders Get all joint venture accounting headers
- /revenueContracts Get all revenue contracts
- /jointVentureContributions Get all joint venture partner contributions
- Oracle Fusion API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages