Oracle Fusion · Data dictionary
CE_BANK_ACCOUNTS
Cash ManagementUsed in 12 subject areas9 reporting columns
Cash Management (CE), bank account master.
Primary key: BANK_ACCOUNT_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AP_USE_ALLOWED_FLAG | ● | Indicator (Y/N) for the payables use allowed. | |
| AR_USE_ALLOWED_FLAG | ● | Indicator (Y/N) for the receivables use allowed. | |
| BANK_ACCOUNT_ID | PK | ○ | Identifier for the bank account. |
| BANK_ACCOUNT_NAME | ● | Name of the bank account. | |
| BANK_ACCOUNT_NAME_ALT | ● | Bank account name alt. | |
| BANK_ACCOUNT_TYPE | ● | Type of bank account. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DESCRIPTION | ● | Description. | |
| MASKED_ACCOUNT_NUM | ● | Masked account number. | |
| PAY_USE_ALLOWED_FLAG | ● | Indicator (Y/N) for the pay use allowed. |
10 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to CE_BANK_ACCOUNTS.
- Auto Reconciliation Execution Report
- Treasury-Loaded Bank Account Information Report
- Transactions Available for Reconciliation Report
- Payables Cash Requirement Report
- Receipts Awaiting Bank Clearance Report
- Receipts Awaiting Remittance Report
- Bank Risk Report
- Clear Receipts Automatically Execution Report
- Cash Management Bank Statement Report
- Cash in Transit Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Cash Management - Bank Statement Balances Real Time
- Cash Management - Bank Statement Line Charges Real Time
- Cash Management - Bank Statements Real Time
- Cash Management - External Cash Transactions Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Receipt Conversion Rate Adjustments Real Time
- Receivables - Receipts Details Real Time
- Receivables - Standard Receipts Application Details Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for CE_BANK_ACCOUNTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table