Search Results xtr_ig_journal_structures




Overview
Explore in AI Chat

Overview

XTR_IG_JOURNAL_STRUCTURES is a Treasury (XTR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores intercompany (IG) journal structures between a company and its subsidiaries and other intercompany counterparties. In the Treasury architecture, this table provides the accounting template layer that governs how intercompany cash, interest, and principal flows are posted to the General Ledger. Each row ties a specific intercompany relationship — identified by company code, counterparty code, counterparty currency, and counterparty account number — to the general ledger accounts used for principal and interest movements. Because Treasury intercompany processing must reconcile settlement activity against GL balances, this table is a foundational configuration object rather than a transactional one.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table is anchored by a single surrogate primary key and carries a foreign key to CE_BANK_ACCT_USES_ALL, indicating that most of its payload describes descriptive attributes of the intercompany arrangement rather than serving as a pure relationship link. This classification is heuristic and should be treated as a modeling suggestion, not a definitive architectural mandate.

Key Information Stored

The table contains 13 documented columns. The most significant include:

Common Use Cases and Queries

Typical use cases center on Treasury intercompany configuration review, GL account validation, and reconciliation reporting. A common query retrieves the accounting structure for a given company and counterparty:

  • SELECT xtr_ig_journal_structure_id, principal_gl, interest_gl FROM xtr_ig_journal_structures WHERE company_code = :company AND cparty_code = :counterparty AND cp_currency = :currency;
  • Joining to CE_BANK_ACCT_USES_ALL on CPARTY_ACCT_USE_ID to confirm the counterparty bank account usage, external account number, and currency alignment.
  • Audit queries filtering on LAST_UPDATE_DATE to identify recently modified intercompany structures.
  • Completeness checks identifying company-counterparty combinations that lack a configured PRINCIPAL_GL or INTEREST_GL entry.

Related Objects

The most significant related objects include:

  • CE_BANK_ACCT_USES_ALL — referenced via CPARTY_ACCT_USE_ID; provides the counterparty bank account usage details.
  • XTR_IG_JOURNAL_STRUCTURES_PK — the primary key constraint on XTR_IG_JOURNAL_STRUCTURE_ID.
  • XTR_IG_JOURNAL_STRUCTURES_U1 — the unique business-key index on COMPANY_CODE, CPARTY_CODE, CP_CURRENCY, and CP_ACCT_NO.
  • GL_CODE_COMBINATIONS — the general ledger chart of accounts referenced by the PRINCIPAL_GL and INTEREST_GL values.
  • Related XTR intercompany transaction and settlement tables that consume these structures when generating GL postings.