Supported operations
| GET /ledgerBalances |
| GET /ledgerBalances/{id} |
Finders (3)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| AccountBalanceFinder | — |
| AccountGroupBalanceFinder | — |
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/ledgerBalances?finder=AccountBalanceFinder Queryable q fields (49)
Only these fields can appear in a q filter expression on
/ledgerBalances. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/ledgerBalances?q=AccountCombination='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccountCombination | string | = != |
| AccountGroupName | string | = != |
| AccountName | string | = != |
| ActualBalance | string | = != |
| AmountType | string | = != |
| BeginningBalance | string | = != |
| BudgetBalance | string | = != |
| Currency | string | = != |
| CurrencyType | string | = != |
| CurrentAccountingPeriod | string | = != |
| CurrentPeriodBalance | string | = != |
| DetailAccountCombination | string | = != |
| EndingBalance | string | = != |
| ErrorDetail | string | = != |
| LedgerName | string | = != |
| LedgerSetName | string | = != |
| PeriodActivity | string | = != |
| PeriodName | string | = != |
| Scenario | string | = != |
| Segment10TreeCode | string | = != |
| Segment11TreeCode | string | = != |
| Segment12TreeCode | string | = != |
| Segment13TreeCode | string | = != |
| Segment14TreeCode | string | = != |
| Segment15TreeCode | string | = != |
| Segment16TreeCode | string | = != |
| Segment17TreeCode | string | = != |
| Segment18TreeCode | string | = != |
| Segment19TreeCode | string | = != |
| Segment1TreeCode | string | = != |
| Segment20TreeCode | string | = != |
| Segment21TreeCode | string | = != |
| Segment22TreeCode | string | = != |
| Segment23TreeCode | string | = != |
| Segment24TreeCode | string | = != |
| Segment25TreeCode | string | = != |
| Segment26TreeCode | string | = != |
| Segment27TreeCode | string | = != |
| Segment28TreeCode | string | = != |
| Segment29TreeCode | string | = != |
| Segment2TreeCode | string | = != |
| Segment30TreeCode | string | = != |
| Segment3TreeCode | string | = != |
| Segment4TreeCode | string | = != |
| Segment5TreeCode | string | = != |
| Segment6TreeCode | string | = != |
| Segment7TreeCode | string | = != |
| Segment8TreeCode | string | = != |
| Segment9TreeCode | string | = != |
Response fields (49)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountCombinationAccountGroupNameAccountNameActualBalanceAmountTypeBeginningBalanceBudgetBalanceCurrencyCurrencyTypeCurrentAccountingPeriodCurrentPeriodBalanceDetailAccountCombinationEndingBalanceErrorDetailLedgerNameLedgerSetNamePeriodActivityPeriodNameScenarioSegment10TreeCodeSegment11TreeCodeSegment12TreeCodeSegment13TreeCodeSegment14TreeCodeSegment15TreeCodeSegment16TreeCodeSegment17TreeCodeSegment18TreeCodeSegment19TreeCodeSegment1TreeCodeSegment20TreeCodeSegment21TreeCodeSegment22TreeCodeSegment23TreeCodeSegment24TreeCodeSegment25TreeCodeSegment26TreeCodeSegment27TreeCodeSegment28TreeCodeSegment29TreeCodeSegment2TreeCodeSegment30TreeCodeSegment3TreeCodeSegment4TreeCodeSegment5TreeCodeSegment6TreeCodeSegment7TreeCodeSegment8TreeCodeSegment9TreeCode 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
- /taxExemptions Get all tax exemptions
- /jointVentureBasicSLADistributions Get all joint venture subledger distributions
- /jointVentureGLTransactions Get all joint venture general ledger transactions
- /jointVentureBasicGeneratedDistributions Get all distributions for joint venture generated transactions
- /expenseMileagePolicies Get all expense mileage policy line records
- 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