Search Results gl_intercompany_acc_sets




Overview
Explore in AI Chat

Overview

The GL_INTERCOMPANY_ACC_SETS table is a core repository for intercompany transaction processing rules within the Oracle E-Business Suite General Ledger module. It defines the accounting rules and relationships that govern how financial transactions between different legal entities (balancing segments) within the same ledger are automatically accounted for and cleared. This table is fundamental for ensuring accurate and automated elimination entries during the consolidation process, maintaining proper accounting integrity across complex corporate structures. Its configuration is a prerequisite for utilizing the Intercompany and Intracompany Accounting features in Oracle GL.

Key Information Stored

The table stores rule definitions keyed by a specific combination of ledger, journal source, and journal category. According to the provided metadata, its primary key is a composite of LEDGER_ID, JE_SOURCE_NAME, and JE_CATEGORY_NAME. This structure allows for distinct intercompany accounting rules to be established for different types of transactions (e.g., Payables invoices vs. Receivables transactions) within a given ledger. The foreign key relationship from LEDGER_ID to GL_LEDGERS.LEDGER_ID enforces referential integrity. While the specific rule columns are not detailed in the excerpt, typical data stored includes the accounts used for the intercompany receivable, payable, and clearing, as well as rules for balancing segment value derivation and transaction reversal.

Common Use Cases and Queries

The primary use case is the setup and maintenance of automated intercompany accounting. Administrators query this table to review or audit existing rules. Common reporting needs include listing all configured rules for a ledger or verifying rules for a specific source and category. Sample SQL patterns include:

  • Listing all intercompany account sets for a specific ledger:
    SELECT je_source_name, je_category_name FROM gl_intercompany_acc_sets WHERE ledger_id = 1001;
  • Validating the existence of a rule for a specific transaction type:
    SELECT COUNT(*) FROM gl_intercompany_acc_sets WHERE ledger_id = 1001 AND je_source_name = 'Payables' AND je_category_name = 'Standard Invoice';
  • Joining with GL_LEDGERS for a more descriptive report:
    SELECT gs.name, icas.je_source_name, icas.je_category_name FROM gl_intercompany_acc_sets icas, gl_ledgers gs WHERE icas.ledger_id = gs.ledger_id;

Related Objects

As indicated by the foreign key, GL_INTERCOMPANY_ACC_SETS has a direct dependency on the GL_LEDGERS table. It is intrinsically linked to the journal posting process; the GL_JE_LINES table likely references the rules defined here when generating intercompany balancing lines. The setup and maintenance of these rules are typically performed via the Oracle GL application's "Intercompany Accounts" form, which interfaces with this underlying table. The table is also critical for the Intercompany Reconciliation and Elimination reporting functions within the General Ledger.