External Bank Accounts
externalBankAccounts Based on 26C
Create, change and look up External Bank Accounts, with account owners and intermediary bank accounts.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)
- Record key
BankAccountId- Required on create
- none marked
- At a glance
- 38 fields1 finders4 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/externalBankAccounts?fields=AccountSuffix,AccountType,AgencyLocationCode,AllowInternationalPaymentIndicator,AlternateAccountName&limit=25&onlyData=true
{
"items": [
{
"AccountSuffix": "<string, max 30>",
"AccountType": "<string, max 25>",
"AgencyLocationCode": "<string, max 30>",
"AllowInternationalPaymentIndicator": "N",
"AlternateAccountName": "<string, max 320>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 38
| Attribute | Type | Use |
|---|---|---|
AccountSuffix | text · max 30 | Optional on createUpdatableSearchable |
AccountType | text · max 25 | Optional on createUpdatableSearchable |
AgencyLocationCode | text · max 30 | Optional on createUpdatableSearchable |
AllowInternationalPaymentIndicator | text · max 1 · default N | Optional on createUpdatableSearchable |
AlternateAccountName | text · max 320 | Optional on createUpdatableSearchable |
BIC | text · max 30 | Optional on createUpdatableSearchable |
BankAccountId | number | Optional on createSearchable |
BankAccountName | text · max 80 | Optional on createUpdatableSearchable |
BankAccountNumber | text · max 100 | Optional on createUpdatableSearchable |
BankBranchIdentifier | number | Optional on createUpdatableSearchable |
BankBranchName | text · max 360 | Optional on createUpdatableSearchable |
BankBranchNumber | text · max 30 | Optional on createUpdatableSearchable |
BankBranchPartyIndicator | text · max 1 · default Y | Optional on createUpdatableSearchable |
BankIdentifier | number | Optional on createUpdatableSearchable |
BankName | text · max 360 | Optional on createUpdatableSearchable |
BankNumber | text · max 30 | Optional on createUpdatableSearchable |
ChangeIndicator | text · max 255 | Read-onlySearchable |
CheckDigits | text · max 30 | Optional on createUpdatableSearchable |
CountryCode | text · max 2 | Optional on createUpdatableSearchable |
CurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
Description | text · max 240 | Optional on createUpdatableSearchable |
EndDate | date | Optional on createUpdatableSearchable |
ExchangeRate | number | Optional on createUpdatableSearchable |
ExchangeRateAgreementNumber | text · max 80 | Optional on createUpdatableSearchable |
ExchangeRateAgreementType | text · max 80 | Optional on createUpdatableSearchable |
ExchangeRateAgreementTypeName | text · max 255 | Optional on createUpdatableSearchable |
IBAN | text · max 50 | Optional on createUpdatableSearchable |
Intent | text | Optional on createUpdatable |
LastChangeHistoryIdentifier | number | Read-onlySearchable |
OriginApplicationId | number | Optional on createUpdatableSearchable |
PartyId | number | Optional on createUpdatable |
PayeeCreation | text · max 255 | Optional on createUpdatable |
PaymentFactorFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
PersonId | number | Optional on createUpdatableSearchable |
SecondaryAccountReference | text · max 30 | Optional on createUpdatableSearchable |
StartDate | date | Optional on createUpdatableSearchable |
VendorId | number | Read-onlySearchable |
VerificationStatus | text · max 30 | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
SearchExternalBankAccount·BankAccountIdBankAccountNumberBankBranchIdentifierBankBranchNameBankIdentifierBankNameCountryCodeCurrencyCodeIBAN
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 4
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/externalBankAccounts/{BankAccountId}/child/<name>. Add them to a GET with expand.
accountOwnersGET · POST · PATCH Account Owners · 19 fieldsAccountOwnerIdAccountOwnerPartyIdentifierAccountOwnerPartyNameAccountOwnerPartyNumberAddJointAccountOwnerApprovalStatusBankAccountInternalVerificationStatusEndDateFinalVerificationStatusCodeFinalVerificationStatusDetailsFinalVerificationStatusMeaningIntentLastChangeHistoryIdentifierOriginApplicationIdentifierOwnerInternalVerificationStatusPersonIdPrimaryOwnerIndicatorStartDateVerificationStatusattachmentsGET · POST · PATCH · DELETE Account Attachments · 32 fields · 1 findersAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameexternalBankAccountDffGET · POST · PATCH External Bank Account Descriptive Flexfields · 3 fieldsExtBankAccountId__FLEX_Context__FLEX_Context_DisplayValueintermediaryBankAccountsGET · POST · PATCH Intermediary Bank Accounts · 13 fieldsBICBankAccountIdBankAccountNumberBankBranchNumberBankCodeBankNameCheckDigitsCityCommentsCountryCodeIBANIntermediaryAccountIdInternalBankAccountId
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/externalBankAccountsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
SearchExternalBankAccountfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AccountSuffix, notaccountsuffix. - 4 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.