Search Results xtr_ig_journal_structures_pk

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:

• XTR_IG_JOURNAL_STRUCTURE_ID — the surrogate primary key, defined by the XTR_IG_JOURNAL_STRUCTURES_PK constraint. It uniquely identifies each stored journal structure.
• COMPANY_CODE, CPARTY_CODE, CP_CURRENCY, and CP_ACCT_NO — the four business-key columns that form the unique index XTR_IG_JOURNAL_STRUCTURES_U1. Together they define the intercompany pairing and the counterparty bank account context for which GL defaults are configured.
• PRINCIPAL_GL and INTEREST_GL — the general ledger account combinations used to post principal and interest amounts arising from the intercompany arrangement.
• CPARTY_ACCT_USE_ID — a foreign key to CE_BANK_ACCT_USES_ALL, linking the structure to the counterparty's bank account usage record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns providing audit and concurrency information.

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.