Oracle Fusion · Data dictionary
CE_INTERNAL_BANK_ACCTS_V
Cash ManagementUsed in 11 subject areas10 reporting columns
Cash Management (CE), denormalized view.
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. | |
| MASKED_IBAN | ● | Masked iban. | |
| PAY_USE_ALLOWED_FLAG | ● | Indicator (Y/N) for the pay use allowed. |
1 report 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_INTERNAL_BANK_ACCTS_V.
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 - 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_INTERNAL_BANK_ACCTS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table