Oracle Fusion FSCM endpoint reference

Account Combinations LOV REST API

Get all account combinations

GET https://your-pod.oraclecloud.com/fscmRestApi/resources/11.13.18.05/accountCombinationsLOV

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud FSCM: 18 queryable q fields, 1 named finder. Unsure how q works? See the Oracle Fusion API guide.

Supported operations

GET /accountCombinationsLOV
GET /accountCombinationsLOV/{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/accountCombinationsLOV?finder=PrimaryKey

Queryable q fields (18)

Only these fields can appear in a q filter expression on /accountCombinationsLOV. Filtering on any other field returns 400 Bad Request.

Example q request

GET /fscmRestApi/resources/11.13.18.05/accountCombinationsLOV?q=AccountType='<value>'&onlyData=true&limit=25
Field Type Operators
AccountType string = != LIKE
DetailBudgetingAllowedFlag string = != LIKE
DetailPostingAllowedFlag string = != LIKE
EnabledFlag string = != LIKE
EndDateActive string = != LIKE
FinancialCategory string = != LIKE
JgzzReconFlag string = != LIKE
Reference3 string = != LIKE
StartDateActive string = != LIKE
SummaryFlag string = != LIKE
_CHART_OF_ACCOUNTS_ID string = != LIKE
_CODE_COMBINATION_ID string = != LIKE
vslAccount string = != LIKE
vslDept string = != LIKE
vslFunds string = != LIKE
vslLocation string = != LIKE
vslProgram string = != LIKE
vslProject string = != LIKE

Response fields (18)

Top-level attributes returned for each row. Use fields= to request a subset and shrink the payload.

AccountTypeDetailBudgetingAllowedFlagDetailPostingAllowedFlagEnabledFlagEndDateActiveFinancialCategoryJgzzReconFlagReference3StartDateActiveSummaryFlag_CHART_OF_ACCOUNTS_ID_CODE_COMBINATION_IDvslAccountvslDeptvslFundsvslLocationvslProgramvslProject

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