R12- CE Tables and Changes

Cash Management (CE)

New Tables

Table Name

Feature Area

CE_BANK_ACCOUNTS                                     CE_BANK_ACCT_USES_ALL
Bank Account Model                                      Bank Account Model

CE_GL_ACCOUNTS_CCID                                CE_INTEREST_BALANCE_RANGES
Bank Account Model                                      Balances and Interest Calculation

CE_INTEREST_RATES                                    CE_INTEREST_SCHEDULES
Balances and Interest Calculation                    Balances and Interest Calculation

CE_BANK_ACCT_BALANCES                            CE_PROJECTED_BALANCES
Balances and Interest Calculation                    Balances and Interest Calculation

CE_INT_CALC_DETAILS_TMP                          CE_CASHFLOWS
Balances and Interest Calculation                    Bank Account Transfers

CE_CASHFLOW_ACCT_H                                CE_PAYMENT_TRANSACTIONS 

Bank Account Transfers                                Bank Account Transfers

CE_PAYMENT_TEMPLATES                             CE_TRXNS_SUBTYPE_CODES
Bank Account Transfers                                Bank Account Transfers

CE_XLA_EXT_HEADERS                                 CE_CONTACT_ASSIGNMENTS
Subledger Accounting                                   Bank Account Model

CE_AP_PM_DOC_CATEGORIES                        CE_PAYMENT_DOCUMENTS
Bank Account Model                                     Bank Account Model

CE_SECURITY_PROFILES_GT                          CE_CHECKBOOKS
Bank Account Model                                     Bank Account Model

Changed Tables

Table Name

Feature Area

Brief Description of Change

CE_AVAILABLE_TRANSACTIONS_TMP
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID and ORG_ID

CE_STATEMENT_RECONCILS_ALL
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID

CE_ARCH_RECONCILIATIONS_ALL
Bank Statement Reconciliation
Add LEGAL_ENTITY_ID

CE_SYSTEM_PARAMETERS_ALL
System Parameters
Add LEGAL_ENTITY_ID; Add Columns for BAT project

CE_ARCH_HEADERS
Bank Statement
drop ORG_ID

CE_ARCH_INTERFACE_HEADERS
Bank Statement
drop ORG_ID; Add more balance columns

CE_ARCH_INTRA_HEADERS
Bank Statement
drop ORG_ID

CE_INTRA_STMT_HEADERS
Bank Statement
drop ORG_ID

CE_STATEMENT_HEADERS
Bank Statement
drop ORG_ID

CE_STATEMENT_HEADERS_INTERFACE
Bank Statement
drop ORG_ID; Add more balance columns

CE_CASHPOOLS
Cash Leveling
Add LEGAL_ENTITY_ID

CE_PROPOSED_TRANSFERS
Cash Leveling
Add columns for Balance project

CE_LEVELING_MESSAGE
Cash Leveling
Add columns for Balance project

CE_TRANSACTIONS_CODES
Bank Statement
Add Columns for Multi-pass reconciliation feature

CE_STATEMENT_LINES
Bank Statement
Add CASHFLOW_ID

Obsolete Tables

Table Name

Feature Area

Replaced By

CE_ARCH_HEADERS_ALL
Bank Statement
CE_ARCH_HEADERS

CE_ARCH_INTERFACE_HEADERS_ALL
Bank Statement
CE_ARCH_INTERFACE_HEADERS

CE_ARCH_INTRA_HEADERS_ALL
Bank Statement
CE_ARCH_INTRA_HEADERS

CE_INTRA_STMT_HEADERS_ALL
Bank Statement
CE_INTRA_STMT_HEADERS

CE_STATEMENT_HEADERS_ALL
Bank Statement
CE_STATEMENT_HEADERS

CE_STATEMENT_HEADERS_INT_ALL
Bank Statement
CE_STATEMENT_HEADERS_INTERFACE

New Views

View Name

Feature Area

CE_SECURITY_PROFILES_V                            CE_LE_BG_OU_VS_V

Bank Account Model                                     Bank Account Model 

CE_BANK_ACCOUNTS_V                                CE_BANK_BRANCHES_V
Bank Account Model                                     Bank Account Model

CE_BANK_ACCT_USES                                  CE_BANK_ACCTS_GT_V
Bank Account Model                                     Bank Account Model

CE_BANK_ACCT_USES_BG_V                          CE_BANK_ACCT_USES_LE_V
Bank Account Model                                     Bank Account Model

CE_BANK_ACCT_USES_OU_V                          CE_BANK_ACCTS_CALC_V
Bank Account Model                                     Balances and Interests Calculation

CE_INTEREST_RATES_V                                CE_260_CF_RECONCILED_V
Balances and Interests Calculation                  Bank Statement Reconciliation

CE_260_CF_TRANSACTIONS_V                       CE_260_CF_REVERSAL_V
Bank Statement Reconciliation                       Bank Statement Reconciliation

CE_INTERNAL_BANK_ACCTS_GT_V                  CE_XLA_EXT_HEADERS_V
Cash Positioning                                          Subledger Accounting

CE_INTERNAL_BANK_ACCTS_V                       CE_BANKS_V
Bank Account Model                                    Bank Account Model

CE_BANK_ACCTS_SEARCH_GT_V                    CE_XLA_TRANSACTIONS_V
Bank Account Model                                    Subledger Accounting

CEFV_BANK_ACCOUNTS                               CEBV_BANK_ACCOUNTS
Business Intelligence Service                        Business Intelligence Service

CEFV_BANK_BRANCHES                               CEBV_BANK_BRANCHES
Business Intelligence Service                        Business Intelligence Service

Changed Views

View Name

Feature Area

Brief Description of Change

CE_101_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_101_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_185_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_185_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Subledger Accounting and Bank Account Model features
CE_200_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_200_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_222_TXN_FOR_BATCH_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_260_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_260_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_EFT_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_801_EFT_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_RECONCILED_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_999_REVERSAL_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_ALL_STATEMENTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_ARCH_RECONCILIATIONS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAIL_STATEMENTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAILAVLE_BATCHES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_AVAILAVLE_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_BANK_TRX_CODES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_INTERNAL_BANK_ACCOUNTS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_MISC_TAX_CODE_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_MISC_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_RECEIVABLE_ACTIVITIES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_RECONCILED_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_REVERSAL_TRANSACTIONS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_STAT_HDRS_INF_V
Bank Statement Reconciliation
Enhancement related to MOAC, Balances and Interests Calculation and Bank Account Model feature
CE_STATEMENT_HEADERS_V
Bank Statement Reconciliation
Enhancement related to MOAC, Balances and Interests Calculation and Bank Account Model features
CE_STATEMENT_LINES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_STATEMENT_RECONCILIATIONS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_SYSTEM_PARAMETERS
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_SYSTEM_PARAMETERS_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CE_TRANSACTION_CODES_V
Bank Statement Reconciliation
Enhancement related to MOAC and Bank Account Model features
CEBV_CASH_FORECAST_CELLS
BIS Views
Enhancement related to Bank Account Model features
CEBV_ECT
BIS Views
Enhancement related to Bank Account Model features
CEFV_BANK_STATEMENTS
BIS Views
Enhancement related to Bank Account Model features
CEFV_CASH_FORECAST_CELLS
BIS Views
Enhancement related to Bank Account Model features
CEFV_ECT
BIS Views
Enhancement related to Bank Account Model features
CE_TRANSACTION_CODES_V
Bank Statement Reconciliation
Enhancement related to Bank Statement Reconciliation features
CE_CP_XTR_BANK_ACCOUNTS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_XTR_CASHFLOWS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_AP_FC_PAYMENTS_V
Cash Forecasting
Enhancement related to Bank Account Model features
CE_AR_FC_RECEIPTS_V
Cash Forecasting
Enhancement related to Bank Account Model features
CE_AR_FC_INVOICES_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_NO_TERMS_V
Cash Forecasting
Invalid object fix
CE_SO_FC_ORDERS_TERMS_V
Cash Forecasting
Invalid object fix
CE_FORECAST_ROWS_V
Cash Forecasting
Invalid object fix
CE_CP_BANK_ACCOUNTS_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_BA_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_DISC_OPEN_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_LE_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_XTO_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_SUB_OPEN_BAL_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_CP_WS_BA_DISC_V
Cash Positioning
Enhancement related to Bank Account Model features
CE_P_BA_SIGNATORY_HIST_V
BIS View
Enhancement related to Bank Account Model features
CE_FC_ARI_DISC_V
Cash Forecasting
Enhancement related to Subledger Accounting features

Obsoleted Views

View Name

Feature Area

Replaced By

CE_ARCH_HEADERS
Bank Statement
Table with the same name

CE_ARCH_INTERFACE_HEADERS
Bank Statement
Table with the same name

CE_ARCH_INTRA_HEADERS
Bank Statement
Table with the same name

CE_INTRA_STMT_HEADERS
Bank Statement
Table with the same name

CE_STATEMENT_HEADERS
Bank Statement
Table with the same name

CE_STATEMENT_HEADERS_INTERFACE
Bank Statement
Table with the same name