Search Results xtr_gl_references_u1

Overview

XTR.XTR_GL_REFERENCES is a Treasury (ETRM) schema table that maps a company to a General Ledger code combination and an associated treasury account alias. It functions as the bridge between the ETRM company/party model and the Oracle General Ledger chart of accounts, allowing treasury transactions and accounting events to resolve the correct GL accounting flexfield. Based on the foreign key to GL_CODE_COMBINATIONS and the unique business key over CODE_COMBINATION_ID and COMPANY_CODE, the heuristic Data Vault classification for this object is satellite-leaning. In Data Vault terms it is best modeled as a descriptive satellite hanging off the company and GL account hubs/links, since it stores descriptive attributes (account alias, audit flags) keyed by a composite business key rather than acting as an independent hub.

The object resides in the APPS_TS_TX_DATA tablespace and carries the standard Oracle EBS "Internal Use Only" warning in the ETRM documentation, meaning it should be accessed only through supported Oracle Applications programs and concurrent processes, not by direct DML.

Key Information Stored

Of the eight documented columns, the most significant are:

• CODE_COMBINATION_ID (NUMBER, 15) — The surrogate foreign key to GL_CODE_COMBINATIONS, identifying the accounting flexfield combination used for the treasury reference mapping.
• COMPANY_CODE (VARCHAR2) — Company identifier; documented as a foreign key to XTR_PARTIES_V, establishing the owning legal entity or party.
• TREASURY_REFERENCE (VARCHAR2, 2000) — Stores the treasury account alias used by ETRM to reference the account in user-facing and processing contexts.
• AUDIT_INDICATOR (VARCHAR2) — Flag governing audit behavior for the reference record.
• CREATED_BY / CREATED_ON — Standard WHO columns capturing the creating user and creation timestamp.
• UPDATED_BY / UPDATED_ON — Standard WHO columns capturing the last modifying user and timestamp.

The unique index XTR_GL_REFERENCES_U1 (CODE_COMBINATION_ID, COMPANY_CODE) defines the business key and enforces one reference row per company/GL combination pair; it resides in APPS_TS_TX_IDX. The non-unique index XTR_GL_REFERENCES_N1 (COMPANY_CODE) supports lookups by company alone. No surrogate single-column primary key is documented; the composite unique index serves as the de facto business key.

Common Use Cases and Queries

Typical usage involves resolving the GL account and alias for a given company during treasury accounting or reporting. A common pattern joins the table to GL_CODE_COMBINATIONS to expand the flexfield segments:

• Reporting the alias and GL account for each company: SELECT g.COMPANY_CODE, g.TREASURY_REFERENCE, c.CONCATENATED_SEGMENTS FROM XTR.XTR_GL_REFERENCES g JOIN GL_CODE_COMBINATIONS c ON c.CODE_COMBINATION_ID = g.CODE_COMBINATION_ID;
• Validating that every active company has a mapped GL reference before a period close.
• Reconciliation between treasury balances and GL balances by company code.
• Auditing changes via CREATED_BY/UPDATED_BY and the audit indicator for SOX or internal control reviews.

Because of the "Internal Use Only" designation, queries should generally be read-only and routed through supported reporting or extraction layers rather than applied directly to production data.

Related Objects

• GL_CODE_COMBINATIONS — Parent of the CODE_COMBINATION_ID foreign key; supplies the accounting flexfield.
• XTR_PARTIES_V — Source of COMPANY_CODE per the documented foreign key comment.
• XTR_AU_GL_REFERENCES_T — Audit trail table referencing XTR_GL_REFERENCES, capturing row-level audit history.
• XTR_GL_REFERENCES sequences/triggers implied by the audit table for WHO column maintenance.
• ETRM accounting and reconciliation programs that consume the alias mapping for GL posting.

Together these objects position XTR_GL_REFERENCES as a compact but critical mapping table linking ETRM company identifiers to GL accounting combinations and treasury aliases.