Oracle Fusion FSCM endpoint reference

External Bank Accounts REST API

Get all external bank accounts

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

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud FSCM: 29 queryable q fields, 2 named finders, and 2 child resources. Unsure how q works? See the Oracle Fusion API guide.

Supported operations

GET /externalBankAccounts
GET /externalBankAccounts/{id}
PATCH /externalBankAccounts/{id}
POST /externalBankAccounts

Finders (2)

Finders are named, pre-built queries with bound parameters. They can search values plain q filters cannot reach.

Finder Bind variables
PrimaryKey
SearchExternalBankAccount

Example finder request

GET /fscmRestApi/resources/11.13.18.05/externalBankAccounts?finder=PrimaryKey

Queryable q fields (29)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/externalBankAccounts?q=AccountSuffix='<value>'&onlyData=true&limit=25
Field Type Operators
AccountSuffix string = !=
AccountType string = !=
AgencyLocationCode string = !=
AllowInternationalPaymentIndicator string = !=
AlternateAccountName string = !=
BIC string = !=
BankAccountId integer = !=
BankAccountName string = !=
BankAccountNumber string = !=
BankBranchIdentifier integer = !=
BankBranchName string = !=
BankBranchNumber string = !=
BankBranchPartyIndicator string = !=
BankIdentifier integer = !=
BankName string = !=
BankNumber string = !=
ChangeIndicator string = !=
CheckDigits string = !=
CountryCode string = !=
CurrencyCode string = !=
EndDate string = !=
IBAN string = !=
LastChangeHistoryIdentifier integer = !=
OriginApplicationId number = !=
PersonId integer = !=
SecondaryAccountReference string = !=
StartDate string = !=
VendorId integer = !=
VerificationStatus string = !=

Child resources (2)

Each child is reachable at /externalBankAccounts/{id}/child/<name> and most can also be inlined with expand.

accountOwnersattachments

Response fields (34)

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

AccountSuffixAccountTypeAgencyLocationCodeAllowInternationalPaymentIndicatorAlternateAccountNameBICBankAccountIdBankAccountNameBankAccountNumberBankBranchIdentifierBankBranchNameBankBranchNumberBankBranchPartyIndicatorBankIdentifierBankNameBankNumberChangeIndicatorCheckDigitsCountryCodeCurrencyCodeEndDateIBANIntentLastChangeHistoryIdentifierOriginApplicationIdPartyIdPayeeCreationPersonIdSecondaryAccountReferenceStartDateVendorIdVerificationStatusaccountOwnersattachments

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