Search Results gl_iea_subsidiaries




Overview
Explore in AI Chat

Overview

The GL_IEA_SUBSIDIARIES table, owned by the GL (General Ledger) schema within Oracle E-Business Suite 12.1.1 and 12.2.2, stores subsidiary definitions used by the Intercompany and Intracompany Balancing / Enterprise Accounting (IEA) framework. Each row represents a distinct subsidiary entity that can participate in intercompany transactions, recurring intercompany batches, clearing account assignments, and interface processing. Because intercompany accounting requires precise identification of both the sending and receiving entities, this table serves as a central reference point for the entire IEA transaction lifecycle.

Based on the foreign key structure, this object is classified heuristically as a hub in Data Vault modeling terms. It is referenced by numerous transactional and configuration tables and does not function as a pure junction (link) or as a descriptive satellite; it holds the authoritative definition of a subsidiary business entity, while dependent tables carry the transactional context.

Key Information Stored

The table contains 39 documented columns in release 12.2.2. The most significant include:

Common Use Cases and Queries

Typical use cases involve resolving subsidiary identity, validating intercompany setups, and reporting on IEA transaction flows. A frequent query lists enabled subsidiaries with their operating currency:

  • SELECT s.subsidiary_id, s.name, s.company_value, s.currency_code, s.enabled_flag FROM gl.gl_iea_subsidiaries s WHERE s.enabled_flag = 'Y';
  • Joining to sets of books to validate subsidiary-to-ledger assignment: SELECT s.name, b.name FROM gl.gl_iea_subsidiaries s, gl.gl_sets_of_books_11i b WHERE s.set_of_books_id = b.set_of_books_id;
  • Reconciling intercompany activity by linking subsidiaries to transactions (see related objects below).

Related Objects

The following dependent tables reference this hub and are central to IEA operations: