Search Results transform_rule_set_id

Overview

The GCS.GCS_ENTITIES_ATTR table is a core data repository within the Oracle E-Business Suite General Ledger Consolidation System (GCS). It functions as a master table for storing configurable processing rules and system attributes that are specific to a consolidation entity and data type. Its primary role is to define the operational parameters for how financial data for a given entity is processed during the consolidation lifecycle, including rules for balance calculations, data transformation, and validation. The table supports versioning and effective dating through its EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, allowing for historical tracking and future-dated rule changes. It is a critical component for ensuring data integrity and applying consistent business logic across the consolidation process in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key on ENTITY_ID and DATA_TYPE_CODE, ensuring unique configuration per entity and data type combination. Key operational columns include BALANCES_RULE_ID, which stores the identifier for the rule governing how account balances are derived or calculated for consolidation. The TRANSFORM_RULE_SET_ID and VALIDATION_RULE_SET_ID columns hold references to sets of rules for data transformation and validation, respectively. The LEDGER_ID and SOURCE_SYSTEM_CODE columns link the entity's configuration to its source ledger and originating system. Standard Application Object Library (AOL) "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and an OBJECT_VERSION_NUMBER provide audit trails and concurrency control.

Common Use Cases and Queries

A primary use case is troubleshooting or reporting on the consolidation rules assigned to entities. For instance, to identify all entities using a specific balances rule (as indicated by the user's search for "balances_rule_id"), the following query is typical:

• SELECT entity_id, data_type_code, balances_rule_id FROM gcs.gcs_entities_attr WHERE balances_rule_id = <rule_id>;

Administrators frequently query this table to audit effective-dated rule assignments or to verify entity configurations before running a consolidation process. A common reporting pattern joins this table with GCS_ENTITIES_B and related rule definition tables to present a comprehensive view of entity setup.

Related Objects

GCS_ENTITIES_ATTR is centrally linked to the consolidation entity master. Its primary key (ENTITY_ID, DATA_TYPE_CODE) defines its core relationship. Based on the provided metadata, the documented relationship is its primary key constraint, GCS_ENTITIES_ATTR_PK. While the dependency information shows it is referenced by the APPS synonym GCS_ENTITIES_ATTR, logical foreign key relationships would typically exist with tables such as GCS_ENTITIES_B (for ENTITY_ID), GCS_LEDGERS_B (for LEDGER_ID), and the various rule definition tables (e.g., for BALANCES_RULE_ID). These relationships are essential for joining attribute data to descriptive entity, ledger, and rule names in operational reports and application screens.