Search Results xtr_reconciliation_passes_v




Overview
Explore in AI Chat

Overview

XTR_RECONCILIATION_PASSES_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Treasury (XTR) module. It exposes the reconciliation pass configuration that governs how treasury reconciliation processes match and validate transaction records. In the EBS 12.1.1 and 12.2.2 releases, this view is a standard, valid database object used to surface the pass definitions that drive the reconciliation engine, which compares treasury deals, cashflows, and related instruments against counterparty, bank, or internal source data.

The view presents reconciliation pass metadata in a stable, read-only format. Rather than requiring reports, concurrent programs, or custom integrations to join directly to the underlying configuration table, the view provides a clean projection of the four attributes that describe each pass: its code, its descriptive name, the column on which reconciliation is performed, and the detail mode applied during matching. This abstraction supports consistent access for OBIEE/BI Publisher reports, custom SQL extracts, and interface programs that need to interpret which reconciliation passes exist and how each is configured.

Underlying Base Objects

The view is defined over a single documented base object, the synonym XTR_RECONCILIATION_PASSES. In practice, that synonym resolves to the APPS-owned base table that stores reconciliation pass setup. The view does not perform aggregation, joins, or transformation; its view text is a straightforward projection of four columns from the base table. Because it depends on one synonym, there are no join dependencies or performance considerations beyond the underlying table itself, and the view inherits the row-level security and grants established on the base object. From an ETRM metadata perspective, XTR_RECONCILIATION_PASSES is the sole referenced object, confirming the view is a thin, configuration-oriented access layer.

Key Columns

  • RECONCILED_PASS_CODE — The unique identifier for the reconciliation pass. This code is the primary reference used by the reconciliation process and by reports to distinguish one pass from another.
  • PASS_DESCRIPTION — The user-facing description of the pass, providing a meaningful name for reporting and for administrators reviewing setup.
  • RECONCILE_ON_COLUMN — Identifies the column or data element on which the reconciliation is performed, specifying the matching key used by the pass.
  • RECONCILE_DETAIL — Indicates the detail level or mode associated with the reconciliation pass, controlling the granularity at which records are compared.

These four columns constitute the entire projection and correspond directly to the underlying table. No derived, calculated, or concatenated columns are exposed.

Common Use Cases and Queries

The view is most commonly used to enumerate and interpret the configured reconciliation passes. A typical query lists all passes available in the instance:

  • SELECT RECONCILED_PASS_CODE, PASS_DESCRIPTION, RECONCILE_ON_COLUMN, RECONCILE_DETAIL FROM APPS.XTR_RECONCILIATION_PASSES_V ORDER BY RECONCILED_PASS_CODE;
  • Filtering to a specific pass for validation or troubleshooting: SELECT * FROM APPS.XTR_RECONCILIATION_PASSES_V WHERE RECONCILED_PASS_CODE = :pass_code;
  • Joining to transaction or reconciliation results data to attribute outcome rows back to their governing pass via RECONCILED_PASS_CODE.

Practical scenarios include building BI Publisher reconciliation reports, validating setup before running reconciliation concurrent programs, and supporting migration or audit activities by comparing pass configuration across environments. Because the view is read-only and reflects the base table directly, it is safe for integration and reporting use, but all maintenance of pass definitions must be performed against the underlying setup, not through the view.