CE_BANK_ACCOUNTS is the table used by Oracle to keep the information of your own bank accounts ( Accounts from which you’ll be making the payments ). To get the bank name, one must connect this table with hz_parties( party_id) table using column bank_id.
You may need to check MASKED_ACCOUNT_NUM to get the masked account number to mask the account number which is a security requirement.
in this post we will discuss the table structure and indexes of this table.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Table Structure
| COLUMN_NAME | DATA_TYPE | NULLABLE |
| BANK_ACCOUNT_ID | NUMBER | N |
| TARGET_BALANCE | NUMBER | Y |
| TRANSACTION_CALENDAR_ID | NUMBER | Y |
| BANK_ACCOUNT_NAME | VARCHAR2(1440) | N |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| CREATION_DATE | TIMESTAMP(6) | N |
| CREATED_BY | VARCHAR2(256) | N |
| BANK_ACCOUNT_NUM | VARCHAR2(120) | Y |
| BANK_BRANCH_ID | NUMBER | N |
| BANK_ID | NUMBER | Y |
| CURRENCY_CODE | VARCHAR2(60) | Y |
| DESCRIPTION | VARCHAR2(960) | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(600) | Y |
| ATTRIBUTE1 | VARCHAR2(600) | Y |
| ATTRIBUTE2 | VARCHAR2(600) | Y |
| ATTRIBUTE3 | VARCHAR2(600) | Y |
| ATTRIBUTE4 | VARCHAR2(600) | Y |
| ATTRIBUTE5 | VARCHAR2(600) | Y |
| ATTRIBUTE6 | VARCHAR2(600) | Y |
| ATTRIBUTE7 | VARCHAR2(600) | Y |
| ATTRIBUTE8 | VARCHAR2(600) | Y |
| ATTRIBUTE9 | VARCHAR2(600) | Y |
| ATTRIBUTE10 | VARCHAR2(600) | Y |
| ATTRIBUTE11 | VARCHAR2(600) | Y |
| ATTRIBUTE12 | VARCHAR2(600) | Y |
| ATTRIBUTE13 | VARCHAR2(600) | Y |
| ATTRIBUTE14 | VARCHAR2(600) | Y |
| ATTRIBUTE15 | VARCHAR2(600) | Y |
| REQUEST_ID | NUMBER | Y |
| PROGRAM_APPLICATION_ID | NUMBER | Y |
| PROGRAM_ID | NUMBER | Y |
| PROGRAM_UPDATE_DATE | DATE | Y |
| CHECK_DIGITS | VARCHAR2(120) | Y |
| BANK_ACCOUNT_NAME_ALT | VARCHAR2(1280) | Y |
| ACCOUNT_HOLDER_ID | NUMBER | Y |
| EFT_REQUESTER_IDENTIFIER | VARCHAR2(100) | Y |
| SECONDARY_ACCOUNT_REFERENCE | VARCHAR2(120) | Y |
| ACCOUNT_SUFFIX | VARCHAR2(120) | Y |
| DESCRIPTION_CODE1 | VARCHAR2(240) | Y |
| DESCRIPTION_CODE2 | VARCHAR2(240) | Y |
| IBAN_NUMBER | VARCHAR2(200) | Y |
| SHORT_ACCOUNT_NAME | VARCHAR2(120) | Y |
| ACCOUNT_OWNER_PARTY_ID | NUMBER | N |
| ACCOUNT_OWNER_ORG_ID | NUMBER | N |
| ACCOUNT_CLASSIFICATION | VARCHAR2(120) | N |
| AP_USE_ALLOWED_FLAG | VARCHAR2(4) | Y |
| AR_USE_ALLOWED_FLAG | VARCHAR2(4) | Y |
| XTR_USE_ALLOWED_FLAG | VARCHAR2(4) | Y |
| PAY_USE_ALLOWED_FLAG | VARCHAR2(4) | Y |
| MULTI_CURRENCY_ALLOWED_FLAG | VARCHAR2(4) | Y |
| ZERO_AMOUNT_ALLOWED | VARCHAR2(4) | Y |
| MAX_OUTLAY | NUMBER | Y |
| MAX_CHECK_AMOUNT | NUMBER | Y |
| MIN_CHECK_AMOUNT | NUMBER | Y |
| BANK_ACCOUNT_TYPE | VARCHAR2(100) | Y |
| AGENCY_LOCATION_CODE | VARCHAR2(120) | Y |
| START_DATE | DATE | Y |
| END_DATE | DATE | Y |
| ACCOUNT_HOLDER_NAME_ALT | VARCHAR2(600) | Y |
| ACCOUNT_HOLDER_NAME | VARCHAR2(960) | Y |
| CASHFLOW_DISPLAY_ORDER | NUMBER | Y |
| POOLED_FLAG | VARCHAR2(4) | Y |
| MIN_TARGET_BALANCE | NUMBER | Y |
| MAX_TARGET_BALANCE | NUMBER | Y |
| EFT_USER_NUM | VARCHAR2(120) | Y |
| MASKED_ACCOUNT_NUM | VARCHAR2(400) | Y |
| MASKED_IBAN | VARCHAR2(200) | Y |
| INTEREST_SCHEDULE_ID | NUMBER | Y |
| CASHPOOL_MIN_PAYMENT_AMT | NUMBER | Y |
| CASHPOOL_MIN_RECEIPT_AMT | NUMBER | Y |
| CASHPOOL_ROUND_FACTOR | NUMBER | Y |
| CASHPOOL_ROUND_RULE | VARCHAR2(16) | Y |
| ASSET_CODE_COMBINATION_ID | NUMBER | Y |
| CASH_CLEARING_CCID | NUMBER | Y |
| BANK_CHARGES_CCID | NUMBER | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| NETTING_ACCT_FLAG | VARCHAR2(4) | Y |
| POOL_PAYMENT_METHOD_CODE | VARCHAR2(120) | Y |
| POOL_BANK_CHARGE_BEARER_CODE | VARCHAR2(120) | Y |
| POOL_PAYMENT_REASON_CODE | VARCHAR2(120) | Y |
| POOL_PAYMENT_REASON_COMMENTS | VARCHAR2(1020) | Y |
| POOL_REMITTANCE_MESSAGE1 | VARCHAR2(1020) | Y |
| POOL_REMITTANCE_MESSAGE2 | VARCHAR2(1020) | Y |
| POOL_REMITTANCE_MESSAGE3 | VARCHAR2(1020) | Y |
| FX_CHARGE_CCID | NUMBER | Y |
| BANK_ACCOUNT_NUM_ELECTRONIC | VARCHAR2(400) | Y |
| RECON_FOREIGN_BANK_XRATE_TYPE | VARCHAR2(120) | Y |
| RECON_FOR_BANK_XRATE_DATE_TYPE | VARCHAR2(40) | Y |
| XTR_BANK_ACCOUNT_REFERENCE | VARCHAR2(80) | Y |
| RECON_RULESET_ID | NUMBER | Y |
| MANUAL_TOLERANCE_RULE_ID | NUMBER | Y |
| RECON_START_DATE | DATE | Y |
| BANK_EXCHANGE_RATE_TYPE | VARCHAR2(120) | Y |
| RECON_DIFFERENCE_CCID | NUMBER | Y |
| PARSING_RULE_SET_ID | NUMBER | Y |
| DATA_SECURITY_FLAG | VARCHAR2(4) | Y |
| GL_CUR_EXC_RATE_TYPE | VARCHAR2(120) | Y |
| REVERSAL_PROCESS_CODE | VARCHAR2(120) | Y |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE1 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE2 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE3 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE4 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE5 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE6 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE7 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE8 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE9 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE10 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE11 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE12 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE13 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE14 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE15 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE16 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE17 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE18 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE19 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE20 | VARCHAR2(600) | Y |
| ATTRIBUTE_NUMBER1 | NUMBER | Y |
| ATTRIBUTE_NUMBER2 | NUMBER | Y |
| ATTRIBUTE_NUMBER3 | NUMBER | Y |
| ATTRIBUTE_NUMBER4 | NUMBER | Y |
| ATTRIBUTE_NUMBER5 | NUMBER | Y |
| ATTRIBUTE_DATE1 | DATE | Y |
| ATTRIBUTE_DATE2 | DATE | Y |
| ATTRIBUTE_DATE3 | DATE | Y |
| ATTRIBUTE_DATE4 | DATE | Y |
| ATTRIBUTE_DATE5 | DATE | Y |
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Y |
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Y |
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Y |
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Y |
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Y |
| MULTI_CASH_RECON_ENABLED_FLAG | VARCHAR2(4) | Y |
| CASH_CCID_FIXED_SEGMENTS | VARCHAR2(1200) | Y |
| GL_RECON_START_DATE | DATE | Y |
Indexes
| INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN_NAME |
| CE_BANK_ACCOUNTS_N1 | NORMAL | NONUNIQUE | BANK_BRANCH_ID |
| CE_BANK_ACCOUNTS_N10 | FUNCTION-BASED NORMAL | NONUNIQUE | SYS_NC00143$ |
| CE_BANK_ACCOUNTS_N11 | NORMAL | NONUNIQUE | LAST_UPDATE_DATE |
| CE_BANK_ACCOUNTS_N12 | FUNCTION-BASED NORMAL | NONUNIQUE | SYS_NC00142$ |
| CE_BANK_ACCOUNTS_N2 | NORMAL | NONUNIQUE | BANK_ACCOUNT_NAME |
| CE_BANK_ACCOUNTS_N3 | NORMAL | NONUNIQUE | BANK_ACCOUNT_NUM |
| CE_BANK_ACCOUNTS_N3 | NORMAL | NONUNIQUE | BANK_ACCOUNT_TYPE |
| CE_BANK_ACCOUNTS_N4 | NORMAL | NONUNIQUE | SHORT_ACCOUNT_NAME |
| CE_BANK_ACCOUNTS_N5 | NORMAL | NONUNIQUE | ACCOUNT_OWNER_PARTY_ID |
| CE_BANK_ACCOUNTS_N6 | NORMAL | NONUNIQUE | IBAN_NUMBER |
| CE_BANK_ACCOUNTS_N7 | NORMAL | NONUNIQUE | EFT_REQUESTER_IDENTIFIER |
| CE_BANK_ACCOUNTS_N8 | NORMAL | NONUNIQUE | BANK_ID |
| CE_BANK_ACCOUNTS_N9 | NORMAL | NONUNIQUE | ACCOUNT_HOLDER_ID |
| CE_BANK_ACCOUNTS_U1 | NORMAL | UNIQUE | BANK_ACCOUNT_ID |
Related Posts
Payment Details
Query to fetch the details of a Payment Process Request in Fusion
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
