Supported operations
| DELETE /receivablesInvoices/{id} |
| GET /receivablesInvoices |
| GET /receivablesInvoices/{id} |
| PATCH /receivablesInvoices/{id} |
| POST /receivablesInvoices |
Finders (2)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| invoiceSearch | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/receivablesInvoices?finder=PrimaryKey Queryable q fields (18)
Only these fields can appear in a q filter expression on
/receivablesInvoices. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/receivablesInvoices?q=AllowCompletion='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AllowCompletion | string | = != |
| BillToPartyId | integer | = != |
| BillingDate | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CustomerTransactionId | integer | = != |
| DeliveryMethod | string | = != |
| string | = != | |
| InvoiceBalanceAmount | number | = != |
| InvoiceStatus | string | = != |
| LastPrintDate | string | = != |
| LastUpdateDate | string | = != |
| LastUpdatedBy | string | = != |
| OriginalPrintDate | string | = != |
| ReceiptMethod | string | = != |
| SalesPersonNumber | string | = != |
| ShipToContact | string | = != |
| TransactionNumber | string | = != |
Child resources (8)
Each child is reachable at
/receivablesInvoices/{id}/child/<name>
and most can also be inlined with expand.
attachmentsnotesreceivablesInvoiceDFFreceivablesInvoiceDistributionsreceivablesInvoiceGdfreceivablesInvoiceInstallmentsreceivablesInvoiceLinesreceivablesInvoiceTransactionDFF Response fields (84)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountingDateAllowCompletionBankAccountNumberBillToContactBillToCustomerNameBillToCustomerNumberBillToPartyIdBillToSiteBillingDateBusinessUnitCardHolderFirstNameCardHolderLastNameCarrierCommentsControlCompletionReasonConversionDateConversionRateConversionRateTypeCreatedByCreationDateCreditCardAuthorizationRequestIdentifierCreditCardErrorCodeCreditCardErrorTextCreditCardExpirationDateCreditCardIssuerCodeCreditCardTokenNumberCreditCardVoiceAuthorizationCodeCrossReferenceCustomerTransactionIdDefaultTaxationCountryDeliveryMethodDocumentFiscalClassificationDocumentNumberDueDateEmailEnteredAmountFirstPartyRegistrationNumberFreightAmountIntercompanyInternalNotesInvoiceBalanceAmountInvoiceCurrencyCodeInvoicePrintedInvoiceStatusInvoicingRuleLastPrintDateLastUpdateDateLastUpdatedByLegalEntityIdentifierOriginalPrintDatePayingCustomerAccountPayingCustomerNamePayingCustomerSitePaymentTermsPrepaymentPrintOptionPurchaseOrderPurchaseOrderDatePurchaseOrderRevisionReceiptMethodRemitToAddressSalesPersonNumberShipDateShipToContactShipToCustomerNameShipToCustomerNumberShipToSiteShippingReferenceSoldToPartyNumberSpecialInstructionsStructuredPaymentReferenceThirdPartyRegistrationNumberTransactionDateTransactionNumberTransactionSourceTransactionTypeattachmentsnotesreceivablesInvoiceDFFreceivablesInvoiceDistributionsreceivablesInvoiceGdfreceivablesInvoiceInstallmentsreceivablesInvoiceLinesreceivablesInvoiceTransactionDFF 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
- /expenseReports Get all expense report records
- /journalBatches Get all batches
- /expensePerDiemPolicies Get all expense per diem policies
- /payablesInterfaceInvoices Get all interface invoices
- /jointVentures Get all joint ventures
- 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