Supported operations
| GET /payablesOptions |
| GET /payablesOptions/{id} |
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/payablesOptions?finder=PrimaryKey Queryable q fields (71)
Only these fields can appear in a q filter expression on
/payablesOptions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/payablesOptions?q=AccountingDateBasis='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccountingDateBasis | string | = != |
| IncomeTaxCombinedFilingProgram | string | = != |
| USSGLTransactionCode | string | = != |
| USSGLTrxDescriptiveFlexfieldContext | string | = != |
| accountForPayment | string | = != |
| allowAddressChange | string | = != |
| allowAdjustmentsToPaidInvoicesFlag | boolean | = != |
| allowFinalMatchingFlag | boolean | = != |
| allowForceApprovalFlag | boolean | = != |
| allowInvoiceBackdatingForSelfServiceInvoicesFlag | boolean | = != |
| allowInvoiceDocumentCategoryOverrideFlag | boolean | = != |
| allowMatchingDistributionOverrideFlag | boolean | = != |
| allowOverrideOfSupplierSiteBankAccountFlag | boolean | = != |
| allowPayeeOverrideForThirdPartyPaymentsFlag | boolean | = != |
| allowPaymentDateBeforeTheSystemDateFlag | boolean | = != |
| allowPaymentDocumentCategoryOverrideFlag | boolean | = != |
| allowRemitToSupplierOverrideForThirdPartyPaymentsFlag | boolean | = != |
| allowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices | string | = != |
| alwaysTakeDiscFlag | boolean | = != |
| amountTolerances | string | = != |
| attachmentMandatoryForSelfServiceInvoicesFlag | boolean | = != |
| bankChargeDeductionType | string | = != |
| budgetDateBasis | string | = != |
| businessUnitId | integer | = != |
| businessUnitName | string | = != |
| createInterestInvoicesFlag | boolean | = != |
| createdBy | string | = != |
| creationDate | string | = != |
| disallowAttachmentDeleteFlag | boolean | = != |
| discountAllocationMethod | string | = != |
| enableInvoiceAccountCodingWorkflowFlag | boolean | = != |
| enableInvoiceApprovalFlag | boolean | = != |
| excludeFreightFromDiscountCalculationFlag | boolean | = != |
| excludeTaxFromDiscountCalculationFlag | boolean | = != |
| federalIdentificationNumber | string | = != |
| glDateFromReceiptFlag | boolean | = != |
| includeWitholdingDistInIncometaxreports | string | = != |
| incomeTaxRegion | string | = != |
| interestAllocationMethodFlag | boolean | = != |
| interestExpenseDistribution | string | = != |
| invoiceCurrency | string | = != |
| lastUpdateDate | string | = != |
| lastUpdateLogin | string | = != |
| lastUpdatedBy | string | = != |
| ledgerCurrency | string | = != |
| ledgerId | integer | = != |
| limitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag | boolean | = != |
| locationId | integer | = != |
| minimumInterestAmount | number | = != |
| payDateBasis | string | = != |
| payGroup | string | = != |
| paymentCurrency | string | = != |
| paymentPriority | integer | between |
| paymentRequestPayGroup | string | = != |
| paymentRequestPaymentPriority | integer | between |
| paymentRequestPaymentTerms | string | = != |
| paymentTerms | string | = != |
| prepaymentPaymentTerms | string | = != |
| quantityTolerances | string | = != |
| recalculateInvoiceInstallmentsFlag | boolean | = != |
| receiptAcceptanceDays | integer | = != |
| requireAccountingBeforeApproval | string | = != |
| requireConversionRateEntryForPaymentsFlag | boolean | = != |
| requireInvoiceGroup | string | = != |
| requireValidationBeforeApprovalFlag | boolean | = != |
| settlementDays | integer | = != |
| showAvailablePrepaymentsDuringInvoiceEntryFlag | boolean | = != |
| supplierTaxRegion | string | = != |
| termsDateBasis | string | = != |
| transferPOdistributionAdditionalInformationFlag | boolean | = != |
| useDistributionFromPurchaseOrderFlag | boolean | = != |
Response fields (71)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountingDateBasisIncomeTaxCombinedFilingProgramUSSGLTransactionCodeUSSGLTrxDescriptiveFlexfieldContextaccountForPaymentallowAddressChangeallowAdjustmentsToPaidInvoicesFlagallowFinalMatchingFlagallowForceApprovalFlagallowInvoiceBackdatingForSelfServiceInvoicesFlagallowInvoiceDocumentCategoryOverrideFlagallowMatchingDistributionOverrideFlagallowOverrideOfSupplierSiteBankAccountFlagallowPayeeOverrideForThirdPartyPaymentsFlagallowPaymentDateBeforeTheSystemDateFlagallowPaymentDocumentCategoryOverrideFlagallowRemitToSupplierOverrideForThirdPartyPaymentsFlagallowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoicesalwaysTakeDiscFlagamountTolerancesattachmentMandatoryForSelfServiceInvoicesFlagbankChargeDeductionTypebudgetDateBasisbusinessUnitIdbusinessUnitNamecreateInterestInvoicesFlagcreatedBycreationDatedisallowAttachmentDeleteFlagdiscountAllocationMethodenableInvoiceAccountCodingWorkflowFlagenableInvoiceApprovalFlagexcludeFreightFromDiscountCalculationFlagexcludeTaxFromDiscountCalculationFlagfederalIdentificationNumberglDateFromReceiptFlagincludeWitholdingDistInIncometaxreportsincomeTaxRegioninterestAllocationMethodFlaginterestExpenseDistributioninvoiceCurrencylastUpdateDatelastUpdateLoginlastUpdatedByledgerCurrencyledgerIdlimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlaglocationIdminimumInterestAmountpayDateBasispayGrouppaymentCurrencypaymentPrioritypaymentRequestPayGrouppaymentRequestPaymentPrioritypaymentRequestPaymentTermspaymentTermsprepaymentPaymentTermsquantityTolerancesrecalculateInvoiceInstallmentsFlagreceiptAcceptanceDaysrequireAccountingBeforeApprovalrequireConversionRateEntryForPaymentsFlagrequireInvoiceGrouprequireValidationBeforeApprovalFlagsettlementDaysshowAvailablePrepaymentsDuringInvoiceEntryFlagsupplierTaxRegiontermsDateBasistransferPOdistributionAdditionalInformationFlaguseDistributionFromPurchaseOrderFlag 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
- /jointVentureSLATransactions Get all joint venture subledger transactions
- /jointVentureGeneratedDistributions Get all distributions for joint venture generated transactions
- /jointVentureOverheadDistributions Get all overhead distributions
- /jointVentureGLTransactions Get all joint venture general ledger transactions
- /cashBankAccounts Get all bank accounts
- 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