Search Results gl_iea_transactions_pk

Overview

The GL.GL_IEA_TRANSACTIONS table is the header-level repository for intercompany transactions within Oracle E-Business Suite General Ledger (GL). Intercompany accounting is the practice of recording, balancing, and reconciling transactions between distinct legal entities or subsidiaries defined within a single ledger or across a shared chart of accounts. Each row in this table represents a single intercompany transaction initiated by a sending subsidiary and directed toward a receiving subsidiary, carrying the clearing account assignments, transfer status flags, currency and conversion information, and control totals required to move balances between the two parties. The table is available and VALID in both Oracle EBS 12.1.1 and 12.2.2, owned by the GL schema, and contains 116 documented columns in the 12.2.2 physical schema.

From a dimensional modeling perspective, the FK structure suggests a satellite-leaning classification. The table is dominated by descriptive and status attributes attached to a central intercompany transaction entity, while its foreign keys point outward to reference and master data — subsidiaries, transaction types, currencies, and code combinations. It behaves less as a standalone hub of shared business concepts and more as a descriptive extension keyed by its own surrogate TRANSACTION_ID.

Key Information Stored

The primary key is TRANSACTION_ID, a system-generated surrogate identifier enforced by the unique index GL_IEA_TRANSACTIONS_PK. A second unique index, GL_IEA_TRANSACTIONS_U1, sits on TRANSACTION_NUMBER, making it a business-key candidate and the natural reference users cite when discussing a specific transaction.

• TRANSACTION_ID — surrogate primary key and the join column referenced by transaction lines and reversals.
• TRANSACTION_NUMBER — user-facing business key for the transaction.
• TRANSACTION_TYPE_ID — foreign key to GL_IEA_TRANSACTION_TYPES, defining the nature of the intercompany activity.
• SENDING_SUBSIDIARY_ID / RECEIVING_SUBSIDIARY_ID — foreign keys to GL_IEA_SUBSIDIARIES identifying the two parties.
• SENDER_CLEARING_CCID / RECEIVER_CLEARING_CCID — foreign keys to GL_CODE_COMBINATIONS, assigning the clearing accounts used to balance each side.
• CURRENCY_CODE — foreign key to FND_CURRENCIES.
• SENDER_CONVERSION_RATE / RECEIVER_CONVERSION_RATE — rates applied to each side of the transaction.
• STATUS, SENDER_TRANSFER_STATUS, RECEIVER_TRANSFER_STATUS — lifecycle and transfer state for reconciliation monitoring.
• GL_DATE / ENTERED_DATE — accounting date and entry date.
• SENDER_PERIOD_NAME / RECEIVER_PERIOD_NAME — periods targeted on each side.
• CONTROL_TOTAL — balancing and validation amount.
• FROM_RECURRING_TRANSACTION_ID — links back to GL_IEA_RECUR_TRANSACTIONS when generated from a recurring template.
• REVERSE_TRANSACTION_ID — self-referencing FK identifying the reversing entry.

Common Use Cases and Queries

Typical reporting scenarios include intercompany reconciliation between subsidiaries, transfer status monitoring, and audit of clearing account balances. A representative query joins the transaction header to its lines and subsidiary names:

• List pending transfers: SELECT TRANSACTION_NUMBER, SENDING_SUBSIDIARY_ID, RECEIVING_SUBSIDIARY_ID, STATUS FROM GL_IEA_TRANSACTIONS WHERE SENDER_TRANSFER_STATUS = 'N';
• Join to clearing accounts: SELECT t.TRANSACTION_NUMBER, gcc.CONCATENATED_SEGMENTS FROM GL_IEA_TRANSACTIONS t, GL_CODE_COMBINATIONS gcc WHERE t.SENDER_CLEARING_CCID = gcc.CODE_COMBINATION_ID;
• Trace reversals: SELECT TRANSACTION_ID, REVERSE_TRANSACTION_ID FROM GL_IEA_TRANSACTIONS WHERE REVERSE_TRANSACTION_ID IS NOT NULL;
• Aggregate control totals by currency and period for reconciliation reports.

Related Objects

• GL_IEA_TRANSACTION_LINES — detail lines referencing GL_IEA_TRANSACTIONS.TRANSACTION_ID.
• GL_IEA_SUBSIDIARIES — sending and receiving subsidiary definitions.
• GL_IEA_TRANSACTION_TYPES — transaction type definitions.
• GL_CODE_COMBINATIONS — clearing account code combinations.
• GL_IEA_RECUR_TRANSACTIONS — recurring transaction templates.
• FND_CURRENCIES — currency definitions.
• GL_IEA_TRANSACTIONS (self-referencing) — reversal relationships.