Search Results reconciliation_pass_code

Overview

APPS.XTR_RECONCILIATION_MATRIX_V is a reporting view within the Oracle E-Business Suite Treasury (ETRM) module, available in releases 12.1.1 and 12.2.2. It presents a pivoted, human-readable reconciliation matrix that describes, for each verification method and pass code combination, how individual reconciliation columns — amount, bank account, date, deal number, deal type, party, portfolio, product, serial number, and subtype — are evaluated during the bank statement reconciliation process. Rather than storing data, the view decodes internal reconciliation codes into descriptive meanings using lookup values, effectively translating the underlying reconciliation rule configuration into a form suitable for reporting, troubleshooting, and integration.

Its primary role is to expose the reconciliation logic configured in the Treasury reconciliation setup so that users and downstream processes can understand which fields are matched, which are summed by date or range, and which are ignored for a given pass. This makes the view valuable for audit, configuration review, and support diagnosis of reconciliation discrepancies.

Underlying Base Objects

The view is defined over several documented base objects:

• XTR_RECONCILIATION_PASSES_V — Supplies the reconciliation pass definitions, including Verify_Method, Pass_Code, and Ver_Seq (sequence order).
• XTR_RECONCILIATION_PROCESS_V — Provides the reconciliation column/cross-reference configuration that drives the DECODE logic applied to each detail column.
• FND_LOOKUPS — Joined to resolve lookup codes into their corresponding meanings, which is directly relevant to the lookup_code search that surfaced this object.
• FND_GLOBAL — The standard EBS package providing session context (user, responsibility, organization), typically used for access and security filtering.

The view therefore functions as a consolidated presentation layer over the reconciliation passes and process configuration views, enriched with lookup descriptions.

Key Columns

• VERIFICATION_METHOD — The method used to verify a reconciliation pass.
• RECONCILIATION_PASS_CODE — The code identifying the reconciliation pass.
• SEQUENCE_ORDER — The order in which the pass executes.
• AMOUNT_RECON_DETAIL, BANK_ACCT_RECON_DETAIL, DATE_RECON_DETAIL, DEAL_NUM_RECON_DETAIL, DEAL_TYPE_RECON_DETAIL, PARTY_RECON_DETAIL, PORTFOLIO_RECON_DETAIL, PRODUCT_RECON_DETAIL, SERIAL_NUM_RECON_DETAIL, SUBTYPE_RECON_DETAIL — Each of these columns reports how the corresponding reconciliation attribute is treated for the pass. The DECODE expressions translate internal codes such as match_code, sumdate_code, and sumrange_code into their descriptive meanings (for example, matched-by-value, summed by date, or summed by range).

Because the view relies on lookup_code resolution via FND_LOOKUPS, the descriptive meanings are driven by seeded and user-defined lookup values.

Common Use Cases and Queries

Typical uses include reviewing how reconciliation passes are configured, identifying which attributes are matched versus summed, and troubleshooting why a statement line fails to reconcile. A representative query is:

SELECT verification_method,
       reconciliation_pass_code,
       sequence_order,
       amount_recon_detail,
       date_recon_detail,
       deal_num_recon_detail
FROM   apps.xtr_reconciliation_matrix_v
ORDER  BY verification_method, sequence_order;

Analysts may correlate the detail columns with lookup values in FND_LOOKUPS to confirm the meaning of each code, or join to pass definitions to isolate a specific pass. The view is read-only and intended for inquiry and reporting rather than maintenance.