Supported operations
| GET /dataAccessSetLedgersLOV |
| GET /dataAccessSetLedgersLOV/{id} |
Finders (6)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| KeywordFinder | — |
| PrimaryKey | — |
| accessSetIdFinder | — |
| ledgerIdAttrRowFinder | — |
| ledgerSetIdsFinder | — |
| objectCodeLookupTypFinder | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/dataAccessSetLedgersLOV?finder=KeywordFinder Queryable q fields (16)
Only these fields can appear in a q filter expression on
/dataAccessSetLedgersLOV. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/dataAccessSetLedgersLOV?q=AccountedPeriodType='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccessSetId | integer | = != |
| AccountedPeriodType | string | = != |
| BalSegColumnName | string | = != |
| ChartOfAccountsId | integer | = != |
| Description | string | = != |
| EnableBudgetaryControlFlag | boolean | = != |
| LedgerCategoryCode | string | = != |
| LedgerId | integer | = != |
| LedgerSetIds | string | = != |
| LookupCode | string | = != |
| LookupType | string | = != |
| Meaning | string | = != |
| Name | string | = != |
| ObjectTypeCode | string | = != |
| PeriodSetName | string | = != |
| ShortName | string | = != |
Response fields (16)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccessSetIdAccountedPeriodTypeBalSegColumnNameChartOfAccountsIdDescriptionEnableBudgetaryControlFlagLedgerCategoryCodeLedgerIdLedgerSetIdsLookupCodeLookupTypeMeaningNameObjectTypeCodePeriodSetNameShortName 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
- /payablesAndProcurementOptions Get payables and procurement options for all business units
- /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