Search Results xtr_a_journals_v

Overview

XTR_A_JOURNALS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a pass-through definition over XTR_A_JOURNALS that flattens the accounting journal entries generated by Treasury dealing and settlement activity into a GL-ready column set. The view exposes debit and credit amounts, accounted debit and credit amounts, the code combination identifier, the set of books identifier, currency, and the general ledger link identifier, GL_SL_LINK_ID, which is the column most commonly searched when reconciling Treasury subledger entries to their GL counterparts. In practice, XTR_A_JOURNALS_V functions as the reporting and integration surface for Treasury accounting: it supports reconciliation between Treasury and General Ledger, feeds downstream extract and reporting programs, and provides the queryable interface used by support and functional teams investigating transfer, cancellation, and suspense conditions.

Underlying Base Objects

The only documented referenced base object is XTR_A_JOURNALS, referenced through a synonym of the same name, which in turn resolves to the APPS-owned journal table. XTR_A_JOURNALS_V adds no filtering, join, or aggregation logic; it is a projection view that selects a curated list of columns from its base object. Consequently, row cardinality and data quality characteristics of the view are identical to those of the base table, and any DML is governed by the base table regardless of privileges granted on the view. Because the object is a simple passthrough, no view-level WHERE clause restricts rows by set of books, date, or status, so consumers must apply their own predicates explicitly.

Key Columns

• COMPANY_CODE, DEAL_NUMBER, TRANSACTION_NUMBER, SETTLEMENT_NUMBER — identifying context linking each journal line to a Treasury deal, transaction, or settlement.
• DEAL_TYPE, DEAL_SUBTYPE, AMOUNT_TYPE, PRODUCT_TYPE, PORTFOLIO_CODE — classification attributes used to group and analyze Treasury activity.
• DEBIT_AMOUNT, CREDIT_AMOUNT — entered amounts in the transaction currency.
• ACCOUNTED_DR, ACCOUNTED_CR — accounted amounts translated into the functional currency of the set of books.
• CODE_COMBINATION_ID, SET_OF_BOOKS_ID, CURRENCY — accounting flexfield reference, ledger context, and transaction currency for each line.
• GL_SL_LINK_ID — the subledger link identifier that ties a Treasury journal line to its corresponding GL_JE_LINES record; this is the primary join key for Treasury-to-GL reconciliation and the column most often searched against this view.
• GL_TRANSFER_DATE, TRANSFER_TO_EXTERNAL_GL, CANCELLED_IN_GL, SUSPENSE_GL, JNL_REVERSAL_IND — transfer status, cancellation, suspense, and reversal indicators that drive exception reporting.
• COMMENTS, AUDIT_INDICATOR, AUDIT_DATE_STORED, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON — descriptive, audit, and row-level change attributes.

Common Use Cases and Queries

Typical uses include: reconciling Treasury journals to GL using GL_SL_LINK_ID; extracting journals for a specific ledger or period; reporting unposted or suspended lines; and auditing reversals and GL cancellations. Sample queries follow.

• Reconcile a Treasury journal line to GL:
  SELECT h.je_header_id, l.je_line_id, l.accounted_dr, l.accounted_cr FROM gl_je_lines l, gl_je_headers h WHERE l.je_header_id = h.je_header_id AND l.gl_sl_link_id = &link_id;
• List Treasury journals by ledger and date:
  SELECT deal_number, transaction_number, code_combination_id, accounted_dr, accounted_cr FROM xtr_a_journals_v WHERE set_of_books_id = :ledger AND journal_date BETWEEN :from_date AND :to_date;
• Identify suspense or cancelled entries:
  SELECT deal_number, gl_sl_link_id, suspense_gl, cancelled_in_gl FROM xtr_a_journals_v WHERE suspense_gl = 'Y' OR cancelled_in_gl = 'Y';