Search Results gcs_elim_rule_rels




Overview
Explore in AI Chat

Overview

The GCS_ELIM_RULE_RELS table is a core data object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the Financial Consolidation Hub (GCS) module. It functions as a relationship table, establishing and maintaining the critical link between consolidation treatments and the specific elimination rules assigned to them. This table is essential for the configuration and execution of intercompany eliminations, a fundamental process in financial consolidation that removes the effects of transactions between entities within the same corporate group to present consolidated financial statements accurately.

Key Information Stored

The table's structure is designed to manage a many-to-many relationship between treatments and rules, enforced by its composite primary key. The key columns are TREATMENT_ID and RULE_ID. TREATMENT_ID identifies a specific consolidation treatment scenario, which defines how data is processed for a particular consolidation purpose. RULE_ID references a specific elimination rule defined in the GCS_ELIM_RULES_B table, which contains the logic and criteria for identifying and eliminating intercompany transactions. The table does not store transactional data itself but the configuration metadata that dictates which rules apply to which treatments during a consolidation run.

Common Use Cases and Queries

This table is primarily accessed for setup, audit, and troubleshooting purposes within the Consolidation Hub. A common operational query is to list all elimination rules associated with a specific treatment to verify setup before running a consolidation. For example: SELECT rule_id FROM gcs_elim_rule_rels WHERE treatment_id = :p_treatment_id ORDER BY rule_id;. Conversely, administrators may need to identify all treatments that utilize a particular rule to assess the impact of a rule change: SELECT treatment_id FROM gcs_elim_rule_rels WHERE rule_id = :p_rule_id;. This table is also central to any custom reporting that documents the complete end-to-end configuration of the elimination process, joining to GCS_ELIM_RULES_B for rule details and to the relevant treatment table for treatment context.

Related Objects

The table maintains defined foreign key relationships that anchor it within the GCS data model. Its primary key (TREATMENT_ID, RULE_ID) uniquely identifies each relationship. For referential integrity, it holds foreign keys to parent tables:

  • GCS_ELIM_RULES_B: The RULE_ID column references GCS_ELIM_RULES_B.RULE_ID. This links the relationship record to the master definition of the elimination rule, which contains its name, type, and other control attributes.
  • Treatment Table: The TREATMENT_ID column references a primary key in a parent treatment table (the specific table name is denoted as '%' in the provided metadata, indicating it may vary or is part of a flexible structure). This links the relationship to the specific consolidation treatment entity.
These relationships ensure that a rule or treatment cannot be deleted if active associations exist in GCS_ELIM_RULE_RELS, preserving configuration integrity.