R12 CASHMANAGEMENT CHANGES

R 12 CASHMANAGEMENT CHANGES

R 12 CASHMANAGEMENT CHANGES

Cash Management (CE)

New Tables

Table Name

Feature Area

CE_BANK_ACCOUNTS

Bank Account Model

CE_BANK_ACCT_USES_ALL

Bank Account Model

CE_GL_ACCOUNTS_CCID

Bank Account Model

CE_INTEREST_BALANCE_RANGES

Balances and Interest Calculation

CE_INTEREST_RATES

Balances and Interest Calculation

CE_INTEREST_SCHEDULES

Balances and Interest Calculation

CE_BANK_ACCT_BALANCES

Balances and Interest Calculation

CE_PROJECTED_BALANCES

Balances and Interest Calculation

CE_INT_CALC_DETAILS_TMP

Balances and Interest Calculation

CE_CASHFLOWS

Bank Account Transfers

CE_CASHFLOW_ACCT_H

Bank Account Transfers

CE_PAYMENT_TRANSACTIONS

Bank Account Transfers

CE_PAYMENT_TEMPLATES

Bank Account Transfers

CE_TRXNS_SUBTYPE_CODES

Bank Account Transfers

CE_XLA_EXT_HEADERS

Subledger Accounting

CE_CONTACT_ASSIGNMENTS

Bank Account Model

CE_AP_PM_DOC_CATEGORIES

Bank Account Model

CE_PAYMENT_DOCUMENTS

Bank Account Model

CE_SECURITY_PROFILES_GT

Bank Account Model

CE_CHECKBOOKS

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

Bank Account Model

CE_LE_BG_OU_VS_V

Bank Account Model

CE_BANK_ACCOUNTS_V

Bank Account Model

CE_BANK_BRANCHES_V

Bank Account Model

CE_BANK_ACCT_USES

Bank Account Model

CE_BANK_ACCTS_GT_V

Bank Account Model

CE_BANK_ACCT_USES_BG_V

Bank Account Model

CE_BANK_ACCT_USES_LE_V

Bank Account Model

CE_BANK_ACCT_USES_OU_V

Bank Account Model

CE_BANK_ACCTS_CALC_V

Balances and Interests Calculation

CE_INTEREST_RATES_V

Balances and Interests Calculation

CE_260_CF_RECONCILED_V

Bank Statement Reconciliation

CE_260_CF_TRANSACTIONS_V

Bank Statement Reconciliation

CE_260_CF_REVERSAL_V

Bank Statement Reconciliation

CE_INTERNAL_BANK_ACCTS_GT_V

Cash Positioning

CE_XLA_EXT_HEADERS_V

Subledger Accounting

CE_INTERNAL_BANK_ACCTS_V

Bank Account Model

CE_BANKS_V

Bank Account Model

CE_BANK_ACCTS_SEARCH_GT_V

Bank Account Model

CE_XLA_TRANSACTIONS_V

Subledger Accounting

CEFV_BANK_ACCOUNTS

Business Intelligence Service

CEBV_BANK_ACCOUNTS

Business Intelligence Service

CEFV_BANK_BRANCHES

Business Intelligence Service

CEBV_BANK_BRANCHES

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