Results for “xtr_pay_rec_reconciliation_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_PAY_REC_RECONCILIATION_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product family. It exposes payment and receipt reconciliation data captured through the Treasury reconciliation process, presenting bank statement lines alongside their reconciliation and confirmation attributes in a single flat structure. In EBS 12.1.1 and 12.2.2 the object carries a status of VALID and is documented through ETRM as a standard, supported dictionary object.

The view is deliberately thin: rather than performing joins or derivations, it projects a fixed column list from a single underlying object. This makes it a convenient, stable access point for reports, extracts, and integration interfaces that need reconciliation records without depending directly on the base table. Because the column set includes the reconciliation pass code and reference — the fields most often searched under terms such as reconciled_pass_code — it is a frequent target for diagnostic queries and reconciliation status reporting.

Underlying Base Objects

The view is defined over XTR_PAY_REC_RECONCILIATION, referenced in the documented metadata as a SYNONYM in the APPS schema. The view text performs no filtering, aggregation, or joining; it is a straight projection of fourteen columns from that object. Consequently, row cardinality and data content of the view are identical to the base object, and no row-level security or business logic is introduced at the view layer. Any restrictions returned to a user derive from the underlying object's grants and any synonym resolution rather than from the view definition itself.

Because the dependency is a synonym rather than a fully qualified table name, resolution is governed by the APPS synonym pointing to the actual XTR base table. Administrators troubleshooting the view should confirm that the synonym resolves to the expected table and that the APPS grants on the base object are intact.

Key Columns

• IMPORT_REFERENCE — Identifier of the import batch or load through which the reconciliation record entered the system; useful for tracing a record back to a bank statement interface run.
• VALUE_DATE — The effective or value date of the transaction line, as distinct from the entry date.
• PARTY_NAME — Name of the counterparty associated with the payment or receipt.
• PARTICULARS — Free-form narrative text carried from the statement or instrument.
• SERIAL_REFERENCE — Instrument or serial reference for the transaction.
• RECORD_TYPE — Classification of the record, typically distinguishing payments from receipts.
• DEBIT_AMOUNT / CREDIT_AMOUNT — The monetary amounts captured on the debit and credit side of the line.
• RECONCILED_PASS_CODE — The reconciliation pass code, indicating the pass or stage at which the record was reconciled. This is the column most commonly targeted when users search for reconciled_pass_code.
• RECONCILED_REFERENCE — The reference of the reconciled counterpart entry, allowing the statement line to be tied to the internal transaction.
• CONFIRMATION_STATUS — Status of the confirmation step for the reconciliation record.
• CONFIRMED_BY / CONFIRMED_ON — The user who confirmed the record and the date/time of confirmation.
• COMMENTS — Free-text comments recorded against the reconciliation line.

Common Use Cases and Queries

Typical usage includes reconciliation status reports, exception listings, audit extracts, and interfaces feeding downstream cash management or reconciliation dashboards. A frequent pattern is filtering on the pass code to isolate records reconciled at a given pass:

• SELECT import_reference, value_date, party_name, reconciled_pass_code, reconciled_reference, confirmation_status FROM xtr_pay_rec_reconciliation_v WHERE reconciled_pass_code = :pass_code;
• SELECT record_type, SUM(debit_amount), SUM(credit_amount) FROM xtr_pay_rec_reconciliation_v GROUP BY record_type;
• SELECT * FROM xtr_pay_rec_reconciliation_v WHERE confirmation_status = 'CONFIRMED' AND confirmed_on >= :from_date;
• SELECT import_reference, COUNT(*) FROM xtr_pay_rec_reconciliation_v GROUP BY import_reference ORDER BY 2 DESC;

Because the view adds no logic, query performance mirrors that of the base object; for large volumes, predicates on IMPORT_REFERENCE, VALUE_DATE, or RECONCILED_PASS_CODE should be applied explicitly to limit the rows returned.