You are browsing the archive for CM.

Cash Management R12 Enhancements

Oracle Cash Management Module R12 enhancements

 

  • Bank Account Balances/Interest Calculation

    • New Bank Account balance types for internal bank accounts

    • Flexible reporting tools for balance and trend reporting

 

  • Bank Account Transfers

    • Previously only supported through Treasury

    • New Feature allows users to create cash transfers manually or automatically

 

  • Cash Pooling

    • Self-Initiated physical cash pools

    • Bank-Initiated Physical Cash Pools or Zero Balance Accounts

    • Notional Cash Pools

 

  • Bank Statement Accounting

    • Define mapping rules that can automatically create and reconcile

    • Users able to define flexible matching rules

 

  • Bank Account Signing Authorities

    • Users enter, maintain and report on bank account signers

    • Attach electronic copies of documents to signing authority record

 

  • Cash Positioning Intra-day Activities

    • Additional flexibility in viewing intra-day bank statement activity in cash position

Oracle Cash Management Tables

Oracle Cash Management important tables

  • CE_AP_PM_DOC_CATEGORIES
  • CE_ARCH_HEADERS
  • CE_ARCH_HEADERS_ALL
  • CE_ARCH_INTERFACE_HEADERS
  • CE_ARCH_INTERFACE_HEADERS_ALL
  • CE_ARCH_INTERFACE_LINES
  • CE_ARCH_INTRA_HEADERS
  • CE_ARCH_INTRA_HEADERS_ALL
  • CE_ARCH_INTRA_LINES
  • CE_ARCH_LINES
  • CE_ARCH_RECONCILIATIONS_ALL
  • CE_ARCH_RECON_ERRORS
  • CE_AVAILABLE_TRANSACTIONS_TMP
  • CE_BANK_ACCOUNTS
  • CE_BANK_ACCT_BALANCES
  • CE_BANK_ACCT_USES_ALL
  • CE_BANK_STMT_INT_MAP
  • CE_BANK_STMT_MAP_HDR
  • CE_BANK_STMT_MAP_LINE
  • CE_BANK_UPGRADE_ERRORS
  • CE_BANK_UPGRADE_MODES
  • CE_BA_SIGNATORIES
  • CE_BA_SIGNATORY_HIST_H
  • CE_CASHFLOWS
  • CE_CASHFLOW_ACCT_H
  • CE_CASHPOOLS
  • CE_CASHPOOL_SUB_ACCTS
  • CE_CE_ARCH_HEADERS
  • CE_CE_ARCH_INTRA_HEADERS
  • CE_CE_BA_SIGNATORIES
  • CE_CE_CASHPOOLS
  • CE_CE_CASHPOOL_SUB_ACCTS
  • CE_CE_CP_PD_BALANCES
  • CE_CE_CP_WORKSHEET_LINES
  • CE_CE_FC_OPENING_BAL
  • CE_CE_FORECAST_ROWS
  • CE_CE_FORECAST_TRX_CELLS
  • CE_CE_INTRA_STMT_HEADERS
  • CE_CE_JE_MAPPINGS
  • CE_CE_STATEMENT_HEADERS
  • CE_CE_TRANSACTION_CODES
  • CE_CHECKBOOKS
  • CE_CONTACT_ASSIGNMENTS
  • CE_CP_PRIORDAY_BALANCES
  • CE_CP_TRX_EXCLUDED
  • CE_CP_WORKSHEET_HEADERS
  • CE_CP_WORKSHEET_LINES
  • CE_CURRENCY_RATES_TEMP
  • CE_DOC_SEQUENCE_AUDIT
  • CE_FORECASTS
  • CE_FORECAST_CELLS
  • CE_FORECAST_COLUMNS
  • CE_FORECAST_ERRORS
  • CE_FORECAST_EXT_TEMP
  • CE_FORECAST_EXT_VIEWS
  • CE_FORECAST_HEADERS
  • CE_FORECAST_OPENING_BAL
  • CE_FORECAST_PERIODS
  • CE_FORECAST_ROWS
  • CE_FORECAST_TRX_CELLS
  • CE_GL_ACCOUNTS_CCID
  • CE_HEADER_INTERFACE_ERRORS
  • CE_INTEREST_BAL_RANGES
  • CE_INTEREST_RATES
  • CE_INTEREST_SCHEDULES
  • CE_INTRA_STMT_HEADERS
  • CE_INTRA_STMT_HEADERS_ALL
  • CE_INTRA_STMT_LINES
  • CE_JE_MAPPINGS
  • CE_JE_MESSAGES
  • CE_LEVELING_MESSAGES
  • CE_LINE_INTERFACE_ERRORS
  • CE_PAYMENT_DOCUMENTS
  • CE_PAYMENT_TEMPLATES
  • CE_PAYMENT_TRANSACTIONS
  • CE_PROJECTED_BALANCES
  • CE_PROPOSED_TRANSFERS
  • CE_RECONCILIATION_ERRORS
  • CE_SQLLDR_ERRORS
  • CE_STATEMENT_HEADERS
  • CE_STATEMENT_HEADERS_ALL
  • CE_STATEMENT_HEADERS_INT
  • CE_STATEMENT_HEADERS_INT_ALL
  • CE_STATEMENT_LINES
  • CE_STATEMENT_LINES_INTERFACE
  • CE_STATEMENT_RECONCILS_ALL
  • CE_STMT_INT_TMP
  • CE_SYSTEM_PARAMETERS
  • CE_SYSTEM_PARAMETERS_ALL
  • CE_TRANSACTION_CODES
  • CE_TRXNS_SUBTYPE_CODES
  • CE_UPGA_BANK_ACCOUNTS
  • CE_UPGA_BANK_REC
  • CE_UPGA_BA_USES_ALL
  • CE_UPGA_CONT_POINT_REC
  • CE_UPGA_GL_ACCTS_CCID
  • CE_UPGA_LOC_REC
  • CE_UPGA_PERSON_REC
  • CE_UPGA_RELATION_REC
  • CE_UPG_AP_ACCTS_TMP
  • CE_UPG_AP_BANKS_TMP
  • CE_UPG_BANK_ACCOUNTS
  • CE_UPG_BANK_DEPENDS
  • CE_UPG_BANK_REC
  • CE_UPG_BA_USES_ALL
  • CE_UPG_CONT_POINT_REC
  • CE_UPG_GL_ACCOUNTS_CCID
  • CE_UPG_LOC_REC
  • CE_UPG_PAY_ACCTS_TMP
  • CE_UPG_PERSON_REC
  • CE_UPG_PURGE_AP_ACCTS
  • CE_UPG_PURGE_AP_BANKS
  • CE_UPG_PURGE_PAY_ACCTS
  • CE_UPG_RELATIONSHIP_REC
  • CE_XML_STATEMENT_LIST
  • CE_ZBA_DEAL_MESSAGES

Cash Management Descriptive Flex Fields

Oracle Cash Management DFF list

DFF View DFF CODE NAME DFF name
CE_FORECASTS_DFV CE_FORECASTS Forecasts
CE_FORECAST_COLUMNS_DFV CE_FORECAST_COLUMNS Forecast Template Columns
CE_FORECAST_HEADERS_DFV CE_FORECAST_HEADERS Forecast Template Headers
CE_FORECAST_ROWS_DFV CE_FORECAST_ROWS Forecast Template Rows
CE_FORECAST_ROWS1_DFV CE_FORECAST_SELECTION_CRITERIA Forecast Selection Criteria
CE_STATEMENT_HEADERS_ALL_DFV CE_STATEMENT_HEADERS Statement Headers
CE_STATEMENT_HEADERS_INT_A_DFV CE_STATEMENT_HEADERS_INTERFACE Statement Headers Interface
CE_STATEMENT_LINES_DFV CE_STATEMENT_LINES Statement Lines
CE_STATEMENT_LINES_INTERFA_DFV CE_STATEMENT_LINES_INTERFACE Statement Lines Interface
CE_SYSTEM_PARAMETERS_ALL_DFV CE_SYSTEM_PARAMETERS System Parameters
CE_TRANSACTION_CODES_DFV CE_TRANSACTION_CODES Transaction Codes
CE_CP_WORKSHEET_LINES_DFV CE_POSITION_SELECTION_CRITERIA Forecast Selection Criteria for Cash Position
CE_BANK_STMT_INT_MAP_DFV CE_BANK_STMT_INT_MAP Bank Statement Mapping
CE_BANK_STMT_MAP_HDR_DFV CE_BANK_STMT_MAP_HDR Bank Statement Mapping Header
CE_BANK_STMT_MAP_LINE_DFV CE_BANK_STMT_MAP_LINE Bank Statement Mapping Line
CE_BANK_ACCOUNTS_DFV CE_BANK_ACCOUNTS Bank Accounts
CE_PAYMENT_DOCUMENTS_DFV CE_PAYMENT_DOCUMENTS Payment Documents
CE_PAYMENT_TRANSACTIONS_DFV CE_BANK_ACCOUNT_TRANSFERS Bank Account Transfers
CE_BA_SIGNATORIES_DFV CE_BA_SIGNATORY Bank Account Signatory