Tuesday, October 24, 2017

Cash Management New/Changed/Obsolete Tables/Views in Oracle Apps R12

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
ACE_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

Changes 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

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)