Search Results ce_bank_stmt_int_map_v




Overview
Explore in AI Chat

Overview

CE_BANK_STMT_INT_MAP_V is an Oracle EBS view owned by the APPS schema within the Cash Management (CE) product family. It exposes configuration metadata that governs how external bank statement files are parsed and mapped during bank statement integration and reconciliation. The view presents one row per bank statement integration format definition, derived from the CE_BANK_STMT_INT_MAP base object, and is typically consumed by Oracle's bank statement loader, reconciliation setup screens, and custom reporting or troubleshooting queries written by technical consultants.

Because the view is a simple projection over a synonym, it does not add filters, joins, or business logic; it returns all rows present in the underlying object. The distinction from the base object is limited to column naming and ordering, giving consumers a stable interface for querying format mapping definitions without querying the table directly. The view carries VALID status in the documented environment, confirming it compiles successfully against the base synonym.

Underlying Base Objects

The documented referenced base object is CE_BANK_STMT_INT_MAP, exposed as a SYNONYM in the APPS schema. The view is defined as a direct SELECT over that synonym, projecting all columns and additionally returning ROWID. No other tables, views, or packages are referenced in the view text, so its behavior depends entirely on the availability and contents of the bank statement integration map base object. Any DML against the base table is immediately reflected in the view because no materialization or caching occurs.

Key Columns

  • MAP_ID — Primary identifier for the bank statement integration format definition.
  • FORMAT_NAME and DESCRIPTION — User-facing name and description of the mapping format.
  • FORMAT_TYPE — Classifies the parser or format family applied to the statement file.
  • CONTROL_FILE_NAME — Name of the associated control file used during the load.
  • PRECISION — Numeric precision applied when interpreting amounts.
  • DATE_FORMAT — Critical to the "date_format" search; defines the date mask used to interpret statement dates.
  • TIMESTAMP_FORMAT — Defines the mask used for timestamp values in the statement file.
  • ENABLED — Flag indicating whether the mapping format is active.
  • ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — Descriptive flexfield segments.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.
  • ROWID — Physical row identifier from the base table.

Common Use Cases and Queries

Consultants routinely query this view when diagnosing date parsing failures during bank statement import. The following sample isolates enabled formats and their date masks:

  • SELECT map_id, format_name, date_format, timestamp_format FROM ce_bank_stmt_int_map_v WHERE enabled = 'Y';
  • SELECT map_id, format_name, format_type, control_file_name FROM ce_bank_stmt_int_map_v WHERE format_name LIKE '&name';
  • SELECT date_format, COUNT(*) FROM ce_bank_stmt_int_map_v GROUP BY date_format;

These queries support setup validation, integration troubleshooting, and audit of format configuration before loading statement files.