Results for “transfer_set_of_books_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• SUBSIDIARY_ID — the surrogate primary key (GL_IEA_SUBSIDIARIES_PK) and the column referenced by all downstream foreign keys.
• NAME — the subsidiary name and the second business-key candidate, uniquely enforced by index GL_IEA_SUBSIDIARIES_U2.
• SET_OF_BOOKS_ID — the set of books to which the subsidiary belongs, referencing GL_SETS_OF_BOOKS_11I.
• CHART_OF_ACCOUNTS_ID — the chart of accounts associated with the subsidiary.
• CURRENCY_CODE — the subsidiary's operating currency, referencing FND_CURRENCIES.
• COMPANY_VALUE — the balancing or company segment value that identifies the subsidiary within the accounting flexfield.
• SUBSIDIARY_TYPE_CODE — the classification of the subsidiary for IEA processing.
• ENABLED_FLAG and AUTO_APPROVE_FLAG — control flags governing whether the subsidiary is active and whether transactions are auto-approved.
• CONVERSION_TYPE_CODE and CONVERSION_TYPE — the currency conversion rules applied to intercompany transfers, referencing GL_DAILY_CONVERSION_TYPES.
• TRANSFER_SET_OF_BOOKS_ID and TRANSFER_CURRENCY_CODE — the optional target set of books and currency for cross-book transfers.
• REMOTE_INSTANCE_FLAG — indicates whether the subsidiary resides on a remote instance.
• NOTIFICATION_THRESHOLD and CONTACT — operational metadata used for intercompany approval notifications.
• Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns.

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:

• GL_IEA_TRANSACTIONS — joins on SENDING_SUBSIDIARY_ID and RECEIVING_SUBSIDIARY_ID.
• GL_IEA_INTERFACE — joins on SENDER_SUBSIDIARY_ID and RECEIVER_SUBSIDIARY_ID.
• GL_IEA_CLEARING_ACCOUNTS — joins on SUBSIDIARY_ID.
• GL_IEA_RECUR_BATCHES — joins on SENDING_SUBSIDIARY_ID.
• GL_IEA_RECUR_TRANSACTIONS — joins on RECEIVING_SUBSIDIARY_ID.
• FUN_SUBSIDIARY_PARTY_MAPPINGS — joins on SUBSIDIARY_ID, linking subsidiaries to trading partners.
• GL_SETS_OF_BOOKS_11I, FND_CURRENCIES, and GL_DAILY_CONVERSION_TYPES — referenced parent tables supplying ledger, currency, and conversion data.