Search Results gcs_lex_map_rule_sets




Overview
Explore in AI Chat

Overview

The GCS_LEX_MAP_RULE_SETS table is a core repository for transformation rule set definitions within the Financial Consolidation Hub (GCS) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master table for defining logical groups of data transformation and validation rules. These rule sets are essential for the consolidation process, enabling the mapping, translation, and validation of financial data from diverse source systems into a standardized format suitable for corporate-level reporting and compliance. The table's primary role is to act as a central control point, linking rule definitions to specific consolidation structures and downstream processing stages.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the critical data points stored. The central identifier is the RULE_SET_ID, a unique key for each rule set definition. The STRUCTURE_ID column is a foreign key linking the rule set to a specific consolidation structure defined in the GCS_LEX_MAP_STRUCTS table, establishing the structural context for the rules. The ASSOCIATED_OBJECT_ID column indicates a relationship to another object, though its specific target is not fully defined in the excerpt. Additional columns, not detailed in the snippet, would typically store attributes such as the rule set name, description, type (e.g., transformation vs. validation), effective dates, and status to control its application within the consolidation lifecycle.

Common Use Cases and Queries

This table is primarily accessed for setup, administration, and troubleshooting of the consolidation mapping rules. A common operational query involves listing all rule sets associated with a specific consolidation structure for review or maintenance. For example: SELECT rule_set_id, name FROM gcs_lex_map_rule_sets WHERE structure_id = :p_struct_id ORDER BY name;. During data submission processing, the system references this table to determine the applicable transformation and validation rules for incoming data. Support and development personnel may query the table to diagnose data submission issues by joining it to the GCS_DATA_SUB_DTLS table to verify the rule set assignments for a problematic submission batch.

Related Objects

The GCS_LEX_MAP_RULE_SETS table maintains integral relationships with several other key GCS objects, as documented by its foreign key constraints.

  • GCS_LEX_MAP_STRUCTS: A rule set is defined for a specific consolidation structure. Joined via GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID = GCS_LEX_MAP_STRUCTS.STRUCTURE_ID.
  • GCS_DATA_SUB_DTLS: This table references a rule set twice, indicating its dual role. A submission detail record is linked to a primary transformation rule set (GCS_DATA_SUB_DTLS.RULE_SET_ID) and potentially a separate validation rule set (GCS_DATA_SUB_DTLS.VALIDATION_RULE_SET_ID).
  • GCS_LEX_MAP_RULE_STAGES: This child table holds the individual rules that comprise a rule set. Joined via GCS_LEX_MAP_RULE_SETS.RULE_SET_ID = GCS_LEX_MAP_RULE_STAGES.RULE_SET_ID.