Search Results xtr_a_journals




Overview
Explore in AI Chat

Overview

XTR_A_JOURNALS is a Treasury (XTR) module table in the Oracle E-Business Suite, owner schema XTR, and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The ETRM metadata records that the object was "Created from Entity XTR JOURNALS by ORACLE on 11-MAY-94," indicating that it is one of the earliest core Treasury entities and has remained structurally stable across releases. It stores the accounting journal lines generated by the Treasury subsystem — foreign exchange deals, cash management transactions, and investment instruments — and serves as the staging and audit bridge between Treasury transaction activity and the Oracle General Ledger. The table is physically documented with 30 columns in the 12.2.2 schema.

Under a heuristic Data Vault classification mined from the foreign-key structure, XTR_A_JOURNALS is best modeled as a link. It resolves relationships between a General Ledger accounting flexfield (GL_CODE_COMBINATIONS) and a ledger definition (GL_SETS_OF_BOOKS_11I), while carrying descriptive attributes such as deal, portfolio, and currency context. The classification is a modeling suggestion, not an Oracle-imposed constraint.

Key Information Stored

The table does not expose a single documented surrogate primary key in the supplied metadata; it is a line-level detail table whose rows are naturally identified by the combination of DEAL_NUMBER, TRANSACTION_NUMBER, SETTLEMENT_NUMBER, and SET_OF_BOOKS_ID — these composite business-key candidates are the practical unique identifier in most customer implementations.

Common Use Cases and Queries

The principal use is reconciliation between Treasury journals and posted GL entries. Analysts query by deal or settlement to trace how a transaction was accounted.

SELECT j.DEAL_NUMBER, j.TRANSACTION_NUMBER, j.JOURNAL_DATE,
       j.DEBIT_AMOUNT, j.CREDIT_AMOUNT, j.ACCOUNTED_DR, j.ACCOUNTED_CR,
       j.CURRENCY, gcc.CONCATENATED_SEGMENTS
  FROM XTR.XTR_A_JOURNALS j,
       GL.GL_CODE_COMBINATIONS_KFV gcc
 WHERE j.CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID
   AND j.DEAL_NUMBER = :deal_number;

Auditors identify lines pending transfer to the ledger using TRANSFER_TO_EXTERNAL_GL and GL_TRANSFER_DATE. Reversal and cancellation analysis uses JNL_REVERSAL_IND and CANCELLED_IN_GL. Portfolio and product-level reporting aggregates ACCOUNTED_DR and ACCOUNTED_CR by PORTFOLIO_CODE, PRODUCT_TYPE, and COMPANY_CODE within a selected SET_OF_BOOKS_ID.

Related Objects

  • GL_CODE_COMBINATIONS — joined on XTR_A_JOURNALS.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
  • GL_SETS_OF_BOOKS_11I — joined on XTR_A_JOURNALS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS_11I.SET_OF_BOOKS_ID.
  • GL_JE_HEADERS / GL_JE_LINES — the General Ledger journal tables receiving transferred Treasury entries.
  • XTR_DEALS / XTR_DEAL_* entities — the deal-level Treasury parents supplying DEAL_NUMBER context.
  • XTR_SETTLEMENTS — the settlement source referenced by SETTLEMENT_NUMBER.

Together these objects support the Treasury-to-GL accounting flow that XTR_A_JOURNALS records.