Search Results gcs_elim_rules_b

Overview

The GCS_ELIM_RULES_B table is a core data object within Oracle E-Business Suite's Financial Consolidation Hub (GCS) module. It serves as the master repository for defining consolidation rules, specifically those used for intercompany eliminations. These rules are fundamental to the consolidation process, governing how journal entries are automatically generated to eliminate transactions between entities within a consolidated group. The table stores the structural definition of each rule, including its source and target treatments, which dictates how financial data is processed to produce accurate, non-duplicative consolidated financial statements.

Key Information Stored

While the provided metadata does not list individual columns, the primary and foreign key relationships reveal its critical structure. The RULE_ID column is the primary key, uniquely identifying each elimination rule. The table also contains foreign key columns, FROM_TREATMENT_ID and TO_TREATMENT_ID, which link to consolidation treatments. These columns define the source data context and the target posting context for the elimination entries. Other stored attributes typically include rule sequencing, status, and control flags that determine the rule's execution logic within a consolidation process.

Common Use Cases and Queries

This table is central to setup, execution, and troubleshooting of the elimination process. A common operational query involves listing all active rules for a specific consolidation entity or hierarchy. For example: SELECT rule_id, name FROM gcs_elim_rules_vl WHERE consolidation_entity_id = :p_entity_id AND status = 'ACTIVE';. During period-end close, the system references rules in this table to generate elimination journals. Support and development queries often join this table with GCS_ENTRY_HEADERS to trace the origin of specific elimination journal entries back to the rule that created them, which is critical for audit trails and reconciling consolidation results.

Related Objects

The GCS_ELIM_RULES_B table has several documented foreign key relationships, forming the backbone of the elimination rule framework.

• GCS_ELIM_RULES_TL: Joins on RULE_ID. This table stores the translated names and descriptions for the rules.
• GCS_ELIM_RULE_RELS: Joins on RULE_ID. Defines relationships between different rules, such as sequencing dependencies.
• GCS_ELIM_RULE_STEPS_B: Joins on RULE_ID. Contains the detailed calculation or mapping steps that constitute the rule's logic.
• GCS_ENTRY_HEADERS: Joins on RULE_ID. Links generated elimination journal entry batches directly to the rule that created them.
• Self-Referential Foreign Keys: The table references itself via FROM_TREATMENT_ID and TO_TREATMENT_ID to the consolidation treatments, which are also stored within the same table structure.