Brazil: How can we derive Oracle 3-digit Bank Code from IBAN 8-digit Bank Code?

Feb 11, 2025 9:46PM

Summary:

Brazil: How to derive Oracle 3-digit Bank Code from IBAN 8-digit Bank Code.

Content (please ensure you mask any confidential information):

The Brazil IBAN (International Bank Account Number) format is 29 characters - BR kk bbbb bbbb ssss sccc cccc ccct n where:

k = IBAN checksum digits

b = National bank code

s = Branch code

c = Account number

t = Account type (cheque account, savings account etc.)

n = Owner account number ("1", "2" etc.)

(Wikipedia https://en.wikipedia.org/wiki/International_Bank_Account_Number)

According to Oracle documents (https://docs.oracle.com/en/cloud/saas/financials/24a/faofc/bank-account-validation-by-country-albania-to-guatemala.html), the Bank Code length "should be a maximum of 3 numeric characters". How are we to determine the 3-digit Bank Code from the 8-digit National bank code?

Brazil: How can we derive Oracle 3-digit Bank Code from IBAN 8-digit Bank Code?

Howdy, Stranger!