Supported operations
| GET /payablesPayments |
| GET /payablesPayments/{id} |
| PATCH /payablesPayments/{id} |
| POST /payablesPayments |
Finders (2)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PaidInvoicesFinder | — |
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/payablesPayments?finder=PaidInvoicesFinder Queryable q fields (82)
Only these fields can appear in a q filter expression on
/payablesPayments. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/payablesPayments?q=AccountingDate='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccountingDate | string | = != |
| AccountingStatus | string | = != |
| AddressLine1 | string | = != |
| AddressLine2 | string | = != |
| AddressLine3 | string | = != |
| AddressLine4 | string | = != |
| AnticipatedValueDate | string | = != |
| BankChargeAmount | number | = != |
| BusinessUnit | string | = != |
| CheckId | integer | = != |
| City | string | = != |
| ClearingAmount | number | = != |
| ClearingConversionDate | string | = != |
| ClearingConversionRate | number | = != |
| ClearingConversionRateType | string | = != |
| ClearingDate | string | = != |
| ClearingLedgerAmount | number | = != |
| ClearingValueDate | string | = != |
| ConversionDate | string | = != |
| ConversionRate | number | = != |
| ConversionRateType | string | = != |
| Country | string | = != |
| County | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CrossCurrencyRateType | string | = != |
| DisbursementBankAccountName | string | = != |
| DisbursementBankAccountNumber | string | = != |
| DocumentCategory | string | = != |
| DocumentSequence | string | = != |
| EmployeeAddress | string | = != |
| ExternalBankAccountId | integer | = != |
| FundingCardAccount | string | = != |
| IbyPaymentStatus | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LegalEntity | string | = != |
| MaturityConversionDate | string | = != |
| MaturityConversionRate | number | = != |
| MaturityConversionRateType | string | = != |
| MaturityDate | string | = != |
| PaperDocumentNumber | integer | = != |
| PartyId | integer | = != |
| Payee | string | = != |
| PayeeSite | string | = != |
| PaymentAmount | number | = != |
| PaymentBaseAmount | number | = != |
| PaymentBaseCurrency | string | = != |
| PaymentCurrency | string | = != |
| PaymentDate | string | = != |
| PaymentDescription | string | = != |
| PaymentDocument | string | = != |
| PaymentFileReference | integer | = != |
| PaymentFunction | string | = != |
| PaymentId | integer | = != |
| PaymentMethod | string | = != |
| PaymentMethodCode | string | = != |
| PaymentMode | string | = != |
| PaymentNumber | integer | = != |
| PaymentProcessProfile | string | = != |
| PaymentProcessProfileCode | string | = != |
| PaymentProcessRequest | string | = != |
| PaymentReference | integer | = != |
| PaymentStatus | string | = != |
| PaymentType | string | = != |
| ProcurementBU | string | = != |
| Province | string | = != |
| ReconciledFlag | boolean | = != |
| RemitToAccountNumber | string | = != |
| SeparateRemittanceAdviceCreated | string | = != |
| State | string | = != |
| StopDate | string | = != |
| StopReason | string | = != |
| StopReference | string | = != |
| SupplierNumber | string | = != |
| ThirdPartyAddressName | string | = != |
| ThirdPartySupplier | string | = != |
| VoidDate | string | = != |
| VoucherNumber | integer | = != |
| WithheldAmount | number | = != |
| Zip | string | = != |
Child resources (3)
Each child is reachable at
/payablesPayments/{id}/child/<name>
and most can also be inlined with expand.
paymentDffpaymentGdfrelatedInvoices Response fields (86)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountingDateAccountingStatusAddressLine1AddressLine2AddressLine3AddressLine4AnticipatedValueDateBankChargeAmountBusinessUnitCheckIdCityClearingAmountClearingConversionDateClearingConversionRateClearingConversionRateTypeClearingDateClearingLedgerAmountClearingValueDateConversionDateConversionRateConversionRateTypeCountryCountyCreatedByCreationDateCrossCurrencyRateTypeDisbursementBankAccountNameDisbursementBankAccountNumberDocumentCategoryDocumentSequenceEmployeeAddressExternalBankAccountIdFundingCardAccountIbyPaymentStatusLastUpdateDateLastUpdateLoginLastUpdatedByLegalEntityMaturityConversionDateMaturityConversionRateMaturityConversionRateTypeMaturityDatePaperDocumentNumberPartyIdPayeePayeeSitePaymentAmountPaymentBaseAmountPaymentBaseCurrencyPaymentCurrencyPaymentDatePaymentDescriptionPaymentDocumentPaymentFileReferencePaymentFunctionPaymentIdPaymentMethodPaymentMethodCodePaymentModePaymentNumberPaymentProcessProfilePaymentProcessProfileCodePaymentProcessRequestPaymentReferencePaymentStatusPaymentTypeProcurementBUProvinceReconciledFlagRemitToAccountNumberSeparateRemittanceAdviceCreatedStateStopDateStopReasonStopReferenceSupplierNumberThirdPartyAddressNameThirdPartySupplierVoidAccountingDateVoidDateVoucherNumberWithheldAmountZippaymentDffpaymentGdfrelatedInvoices 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
- /jointVentures Get all joint ventures
- /jointVentureSLADistributions Get all joint venture subledger distributions
- /cashExternalTransactions Get all external transactions
- /jointVentureGLDistributions Get all joint venture general ledger distributions
- /jointVentureTransactions Get all joint venture transactions
- 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