Search Results ce_arch_reconciliations




Overview
Explore in AI Chat

Overview

CE_ARCH_RECONCILIATIONS is a single-organization (SINGLE-ORG) security view owned by the APPS schema within the Cash Management (CE) product of Oracle E-Business Suite, documented as VALID in ETRM 12.2.2. It presents archived bank statement reconciliation data that has been migrated from the transactional reconciliation tables into the archive schema, allowing historical statement lines, their reconciliation references, and associated accounting journal entries to remain queryable long after the original reconciliation activity has been purged from the operational tables.

The view exposes the reconciliation facts required for cash management reporting, audit trails, and integration with financial and treasury subsystems. In releases 12.1.1 and 12.2.2, the view is the sanctioned access path for archived reconciliation records, ensuring row-level security is applied consistently through the Cash Management security profile model rather than through direct access to the underlying all-organization table.

Underlying Base Objects

The view is defined over CE_ARCH_RECONCILIATIONS_ALL (exposed in APPS as a synonym), which holds the entire set of archived reconciliation rows across all operating units and legal entities. The WHERE clause restricts visibility by subquerying CE_SECURITY_PROFILES_V, granting access when the organization identifier falls within the user's defined BUSINESS_GROUP or OPERATING_UNIT security profile, or when the legal entity identifier matches an assigned LEGAL_ENTITY security profile. A third predicate unconditionally permits rows whose REFERENCE_TYPE is JE_LINE, ROI_LINE, or STATEMENT.

Referenced dependencies also include the FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, and MO_GLOBAL packages, along with XTR_USER_ACCESS, which collectively supply session context, profile option values, and security enforcement used by the security profile view. This design is consistent with other multi-organization views in EBS 12.1.1 and 12.2.2 and is unaffected by the transition to the Online Patching architecture common to 12.2.x.

Key Columns

Common Use Cases and Queries

Typical usage includes auditing historical reconciliations, reconciling archived statement activity to journal entries, and feeding downstream cash-position or treasury reporting. Because the view enforces security, it is safe to expose to operational users; the all-organization table should not be queried directly.

Sample query for archived JE-linked reconciliations:

  • SELECT statement_line_id, reference_id, je_header_id, amount, current_record_flag FROM ce_arch_reconciliations WHERE reference_type = 'JE_LINE' AND org_id = :p_org_id ORDER BY creation_date DESC;

To trace the archival run that produced a record, join on REQUEST_ID to FND_CONCURRENT_REQUESTS. For legal-entity-scoped analysis, filter on LEGAL_ENTITY_ID. Always restrict results by ORG_ID or a date range to avoid scanning the full archive.