Supported operations
| GET /payablesAndProcurementOptions |
| GET /payablesAndProcurementOptions/{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/payablesAndProcurementOptions?finder=PrimaryKey Queryable q fields (41)
Only these fields can appear in a q filter expression on
/payablesAndProcurementOptions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/payablesAndProcurementOptions?q=accrueExpenseItems='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| accrueExpenseItems | string | = != |
| alwaysTakeDiscount | string | = != |
| automaticOffsets | string | = != |
| billPayable | string | = != |
| billToLocation | string | = != |
| billToLocationId | integer | = != |
| businessUnit | string | = != |
| businessUnitId | integer | = != |
| buyingCompanyIdentifier | string | = != |
| conversionRateType | string | = != |
| conversionRateVarianceGain | string | = != |
| conversionRateVarianceLoss | string | = != |
| createdBy | string | = != |
| creationDate | string | = != |
| discountTaken | string | = != |
| freight | string | = != |
| gaplessInvoiceNumberingFlag | boolean | = != |
| holdUnmatchedInvoicesFlag | boolean | = != |
| invoiceCurrency | string | = != |
| lastUpdateDate | string | = != |
| lastUpdateLogin | string | = != |
| lastUpdatedBy | string | = != |
| liability | string | = != |
| miscellaneous | string | = != |
| offsetSegments | string | = != |
| oneTimePaymentExpense | string | = != |
| oneTimePaymentLiability | string | = != |
| payAlone | string | = != |
| payDateBasis | string | = != |
| paymentConversionRateType | string | = != |
| paymentCurrency | string | = != |
| paymentTerms | integer | = != |
| prepayment | string | = != |
| prepaymentTaxDifference | string | = != |
| realizedGainDistribution | string | = != |
| realizedLossDistribution | string | = != |
| requireConversioRateEntryFlag | boolean | = != |
| taxCountryCode | string | = != |
| taxRegistrationMemberState | string | = != |
| taxRegistrationNumber | string | = != |
| termsDateBasis | string | = != |
Response fields (41)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accrueExpenseItemsalwaysTakeDiscountautomaticOffsetsbillPayablebillToLocationbillToLocationIdbusinessUnitbusinessUnitIdbuyingCompanyIdentifierconversionRateTypeconversionRateVarianceGainconversionRateVarianceLosscreatedBycreationDatediscountTakenfreightgaplessInvoiceNumberingFlagholdUnmatchedInvoicesFlaginvoiceCurrencylastUpdateDatelastUpdateLoginlastUpdatedByliabilitymiscellaneousoffsetSegmentsoneTimePaymentExpenseoneTimePaymentLiabilitypayAlonepayDateBasispaymentConversionRateTypepaymentCurrencypaymentTermsprepaymentprepaymentTaxDifferencerealizedGainDistributionrealizedLossDistributionrequireConversioRateEntryFlagtaxCountryCodetaxRegistrationMemberStatetaxRegistrationNumbertermsDateBasis 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
- /dataAccessSetLedgersLOV Get all ledgers or ledger sets
- /receivablesCreditMemos Get all receivables credit memos
- /expenseCashAdvances Get all cash advance records
- /expenseDffSegments Get all descriptive flexfield segments for expenses and expense reports
- /payeeBankAccountsLOV Get all payee 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