Search Results gl_iea_transaction_types




Overview
Explore in AI Chat

Overview

GL_IEA_TRANSACTION_TYPES is a General Ledger (GL) reference table that holds the definitions of intercompany transaction types used by the Oracle E-Business Suite Intercompany and Intercompany Accounting (IEA) functionality. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the master repository that classifies and governs how intercompany transactions are created, approved, taxed, and settled across legal entities within a ledger set or balancing segment structure. Each row defines a distinct transaction type that can be assigned to intercompany transactions, recurring transactions, imports, and interface records, thereby driving the accounting, approval, and invoicing behavior applied downstream.

From a Data Vault modeling perspective, the mined foreign-key structure classifies GL_IEA_TRANSACTION_TYPES as a hub. This heuristic suggests the table functions as a durable business-key repository keyed by a stable surrogate identifier, with the surrounding IEA tables acting as satellites or links that reference it. The classification is a modeling suggestion derived from the FK topology rather than an Oracle-imposed constraint.

Key Information Stored

The table contains 29 documented columns. The most significant attributes are:

  • TRANSACTION_TYPE_ID — The surrogate primary key (GL_IEA_TRANSACTION_TYPES_PK) and the foreign-key anchor referenced by dependent IEA tables. It is also a business-key candidate via unique index GL_IEA_TRANSACTION_TYPES_U1.
  • NAME — The user-facing transaction type name. It is a business-key candidate via unique index GL_IEA_TRANSACTION_TYPES_U2, ensuring type names remain distinct.
  • DESCRIPTION — Free-text description clarifying the purpose of the transaction type.
  • ENABLED_FLAG — Controls whether the transaction type is active and selectable for new intercompany activity.
  • AUTO_APPROVE_FLAG — Determines whether transactions of this type bypass manual approval and are approved automatically.
  • ALLOW_INVOICING_FLAG — Indicates whether intercompany transactions of this type may generate invoices.
  • ALLOW_INTEREST_ACCRUAL_FLAG — Governs whether interest accrual is permitted for outstanding balances associated with the type.
  • VAT_TAXABLE_FLAG — Specifies whether the transaction type is subject to VAT taxation.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who created and last modified each row and when.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — The DESCRIPTIVE flexfield (DFF) support columns that allow customers to capture additional configurable information without modifying the base schema.

Common Use Cases and Queries

Typical usage centers on validating which transaction types are active, auditing approval and invoicing configuration, and joining transactional data back to its type definition for reporting.

Listing enabled transaction types with their flags:

  • SELECT transaction_type_id, name, auto_approve_flag, allow_invoicing_flag FROM gl.gl_iea_transaction_types WHERE enabled_flag = 'Y';

Resolving transaction detail against its type for a reconciliation report:

  • SELECT t.transaction_id, tt.name, t.transaction_date FROM gl.gl_iea_transactions t, gl.gl_iea_transaction_types tt WHERE t.transaction_type_id = tt.transaction_type_id;

Identifying recurring transactions grouped by type, or checking which types permit interest accrual for treasury analysis, are other frequent reporting patterns. The CONTEXT/ATTRIBUTE columns are commonly queried where customers have enabled the DFF for compliance tracking.

Related Objects

The following depend on GL_IEA_TRANSACTION_TYPES through TRANSACTION_TYPE_ID and are its principal related objects:

  • GL_IEA_TRANSACTIONS — The core intercompany transaction fact table; each transaction references its governing type.
  • GL_IEA_IMPORT_REGISTRY — Tracks imported intercompany batches, tied to a transaction type.
  • GL_IEA_INTERFACE — Staging table for inbound intercompany interface data, keyed by transaction type.
  • GL_IEA_RECUR_TRANSACTIONS — Defines recurring intercompany transactions configured per type.

These relationships make GL_IEA_TRANSACTION_TYPES a central reference point for intercompany configuration, reporting, and interface processing across the GL IEA subsystem.