Supported operations
| GET /cashBankAccounts |
| GET /cashBankAccounts/{id} |
| PATCH /cashBankAccounts/{id} |
| POST /cashBankAccounts |
Finders (3)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| BankAccountCeLovFinder | — |
| BankAccountsSearchFinder | — |
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/cashBankAccounts?finder=BankAccountCeLovFinder Queryable q fields (55)
Only these fields can appear in a q filter expression on
/cashBankAccounts. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/cashBankAccounts?q=AccountHolderName='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccountHolderName | string | = != |
| AccountHolderNameAlt | string | = != |
| AccountSuffix | string | = != |
| AccountType | string | = != |
| AccountingConversionRateType | string | = != |
| AgencyLocationCode | string | = != |
| ApUseAllowedFlag | boolean | = != |
| ArUseAllowedFlag | boolean | = != |
| BankAccountId | integer | = != |
| BankAccountName | string | = != |
| BankAccountNameAlt | string | = != |
| BankAccountNumber | string | = != |
| BankAccountNumberElectronic | string | = != |
| BankBranchName | string | = != |
| BankCompanyIdentifier | string | = != |
| BankExchangeRateType | string | = != |
| BankName | string | = != |
| BankNumber | string | = != |
| CashAccountCombination | string | = != |
| CashCcidFixedSegments | string | = != |
| CashClearingAccountCombination | string | = != |
| CheckDigits | string | = != |
| CountryName | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CurrencyCode | string | = != |
| DataSecurityFlag | boolean | = != |
| Description | string | = != |
| EFTUserNumber | string | = != |
| GlReconStartDate | string | = != |
| IBANNumber | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LegalEntityName | string | = != |
| MaskedAccountNumber | string | = != |
| MaskedIBAN | string | = != |
| MaximumCheckAmount | number | = != |
| MaximumOutlay | number | = != |
| MinimumCheckAmount | number | = != |
| MultiCashReconEnabledFlag | boolean | = != |
| MultiCurrencyAllowedFlag | boolean | = != |
| NettingAccountFlag | boolean | = != |
| ParsingRuleSetName | string | = != |
| PayUseAllowedFlag | boolean | = != |
| PooledFlag | boolean | = != |
| ReconStartDate | string | = != |
| ReconciliationDifferenceAccountCombination | string | = != |
| ReversalProcessingMethod | string | = != |
| RulesetName | string | = != |
| SecondaryAccountReference | string | = != |
| TargetBalance | number | = != |
| ToleranceRuleName | string | = != |
| TransactionCalendar | string | = != |
| ZeroAmountAllowed | string | = != |
Child resources (6)
Each child is reachable at
/cashBankAccounts/{id}/child/<name>
and most can also be inlined with expand.
bankAccountGrantsbankAccountPaymentDocumentsbankAccountTransactionCreationRulesbankAccountUsescashBankAccountDFFcashBankAccountGlobalDFF Response fields (63)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountHolderNameAccountHolderNameAltAccountSuffixAccountTypeAccountingConversionRateTypeAgencyLocationCodeApUseAllowedFlagArUseAllowedFlagBankAccountIdBankAccountNameBankAccountNameAltBankAccountNumberBankAccountNumberElectronicBankBranchNameBankCompanyIdentifierBankExchangeRateTypeBankNameBankNumberBranchNumberCashAccountCombinationCashCcidFixedSegmentsCashClearingAccountCombinationCheckDigitsCountryNameCreatedByCreationDateCurrencyCodeDataSecurityFlagDescriptionEFTUserNumberEndDateGlReconStartDateIBANNumberLastUpdateDateLastUpdateLoginLastUpdatedByLegalEntityNameMaskedAccountNumberMaskedIBANMaximumCheckAmountMaximumOutlayMinimumCheckAmountMultiCashReconEnabledFlagMultiCurrencyAllowedFlagNettingAccountFlagParsingRuleSetNamePayUseAllowedFlagPooledFlagReconStartDateReconciliationDifferenceAccountCombinationReversalProcessingMethodRulesetNameSecondaryAccountReferenceTargetBalanceToleranceRuleNameTransactionCalendarZeroAmountAllowedbankAccountGrantsbankAccountPaymentDocumentsbankAccountTransactionCreationRulesbankAccountUsescashBankAccountDFFcashBankAccountGlobalDFF 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
- /jointVentureTransactions Get all joint venture transactions
- /cashExternalTransactions Get all external transactions
- /jointVentureGLDistributions Get all joint venture general ledger distributions
- /jointVentureGeneratedDistributions Get all distributions for joint venture generated transactions
- /jointVentureSLATransactions Get all joint venture subledger transactions
- 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