Supported operations
| GET /preferredCurrenciesLOV |
| GET /preferredCurrenciesLOV/{id} |
Finders (4)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| GetActiveCurrenciesFinder | — |
| GetCurrenciesByLedgerSetFinder | — |
| KeywordFinder | — |
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/preferredCurrenciesLOV?finder=GetActiveCurrenciesFinder Queryable q fields (17)
Only these fields can appear in a q filter expression on
/preferredCurrenciesLOV. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/preferredCurrenciesLOV?q=CurrencyCode='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| CurrencyCode | string | = != |
| CurrencyFlag | boolean | = != |
| CurrencyFormat | string | = != |
| CurrencyFormatWithCode | string | = != |
| CurrencyFormatWithSymbol | string | = != |
| CurrencyName | string | = != |
| DisplaySequence | integer | = != |
| EnabledFlag | boolean | = != |
| EndDateActive | string | = != |
| ExtendedPrecision | integer | >= > = |
| IssuingTerritoryCode | string | = != |
| LedgerSetId | integer | = != |
| MinimumAccountableUnit | number | = != |
| Name | string | = != |
| Precision | integer | = != |
| StartDateActive | string | = != |
| Symbol | string | = != |
Response fields (17)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
CurrencyCodeCurrencyFlagCurrencyFormatCurrencyFormatWithCodeCurrencyFormatWithSymbolCurrencyNameDisplaySequenceEnabledFlagEndDateActiveExtendedPrecisionIssuingTerritoryCodeLedgerSetIdMinimumAccountableUnitNamePrecisionStartDateActiveSymbol 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
- /jointVentureAccountingHeaders Get all joint venture accounting headers
- /revenueContracts Get all revenue contracts
- /jointVentureContributions Get all joint venture partner contributions
- /cashBankBranches Get all bank branches
- 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