Search Results ce_statement_reconciliations




Overview
Explore in AI Chat

Overview

The CE_STATEMENT_RECONCILIATIONS view is a secured reporting object in the Oracle E-Business Suite Cash Management (CE) module, owned by the APPS schema. It is a synonym-backed interface to the base table CE_STATEMENT_RECONCILS_ALL, exposing the reconciliation records that link bank statement lines to the corresponding accounting, cashflow, and statement entries matched against them during the bank reconciliation process. In Oracle EBS 12.1.1 and 12.2.2 the view is registered as VALID within the ETRM repository.

The object's primary role is to provide data security enforcement at query time. Rather than exposing all reconciliation rows to every user, the view filters records by the active operating unit, legal entity, and security profile assigned to the session. It queries CE_STATEMENT_RECONCILS_ALL and restricts the result set using CE_SECURITY_PROFILES_V, ensuring that users only see reconciliation activity belonging to organizations they are authorized to access. This makes the view suitable for custom reports, embedded analytics, and integrations that must respect Multi-Org Access Control (MOAC) and legal entity security without re-implementing that logic.

Underlying Base Objects

Per the documented ETRM metadata, CE_STATEMENT_RECONCILIATIONS is defined over the following referenced objects:

  • CE_STATEMENT_RECONCILS_ALL (SYNONYM) — the base reconciliation table containing statement line matches.
  • CE_SECURITY_PROFILES_V (VIEW) — provides the operating unit and legal entity IDs available to the current user session, driving the WHERE-clause filter.
  • FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE (PACKAGES) — EBS foundation utilities supplying session context such as operating unit, user ID, and responsibility.
  • MO_GLOBAL (PACKAGE) — the Multi-Org initialization package used to establish the current org context.
  • XTR_USER_ACCESS (PACKAGE) — used for user-level access restrictions, typically involving treasury or cash management role-based security.

The view therefore inherits the column set of the base statement reconciliations table while layering on the security predicate. Any insert, update, or delete against reconciliation data must target the underlying base table, not this view.

Key Columns

The view exposes the full reconciliation structure. Important columns include:

Common Use Cases and Queries

Typical scenarios include reporting on outstanding versus reconciled statement lines, auditing automatic reconciliations, and building custom cash position dashboards. Because security is enforced inside the view, simple selections require no additional org predicates.

SELECT statement_line_id,
       reference_type,
       reference_id,
       je_header_id,
       amount,
       status_flag,
       auto_reconciled_flag
FROM   ce_statement_reconciliations
WHERE  statement_line_id = :p_statement_line_id;

To review automatic reconciliation activity within a period:

SELECT csr.statement_line_id,
       csr.reference_type,
       csr.amount,
       csr.creation_date
FROM   ce_statement_reconciliations csr
WHERE  csr.auto_reconciled_flag = 'Y'
AND    csr.creation_date BETWEEN :p_from AND :p_to
ORDER  BY csr.creation_date;

Note that the status, action, and current-record flags should be interpreted together with Cash Management reconciliation documentation, as their meaning depends on the reconciliation stage. The view is read-only by design and should be used consistently in custom code to preserve security and multi-org compliance.