Search Results gcs_cons_data_statuses

Overview

The GCS_CONS_DATA_STATUSES table is a core data object within Oracle E-Business Suite's Financial Consolidation Hub (GCS) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to track the processing state of financial data for consolidation entities across different reporting periods and balance types. This table acts as a control mechanism, enabling the consolidation engine to monitor which entities have data ready for consolidation, which are in progress, and which have been finalized. By storing this status information, it ensures data integrity, prevents duplicate processing, and provides auditability for the entire financial consolidation lifecycle.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies the status record for a specific consolidation scenario. The key columns, as documented, are HIERARCHY_ID, CONSOLIDATION_ENTITY_ID, CAL_PERIOD_ID, and BALANCE_TYPE_CODE. While the specific status column is not listed in the provided metadata, tables of this nature typically include a STATUS_CODE column (e.g., 'NEW', 'IMPORTED', 'CONSOLIDATED', 'FINAL') and potentially a LAST_UPDATE_DATE and LAST_UPDATED_BY for auditing. The CONSOLIDATION_ENTITY_ID is a critical foreign key linking to the consolidation entity master data, while CAL_PERIOD_ID and BALANCE_TYPE_CODE define the accounting period and the type of balances (e.g., actual, budget) being tracked.

Common Use Cases and Queries

A primary use case is generating consolidation readiness reports. System administrators and consolidation managers query this table to identify entities with data pending processing for a given hierarchy and period. Another critical scenario is within consolidation batch programs, which check this table to determine the next set of entities to process. A common SQL pattern involves filtering by the primary key components to check a specific entity's status or to list all entities in a particular state for a reporting cycle.

• Sample Query (Status Check): SELECT status_code FROM gcs_cons_data_statuses WHERE hierarchy_id = 100 AND consolidation_entity_id = 5000 AND cal_period_id = 202301 AND balance_type_code = 'ACTUAL';
• Sample Query (Reporting): SELECT consolidation_entity_id, status_code FROM gcs_cons_data_statuses WHERE hierarchy_id = :p_hier_id AND cal_period_id = :p_period AND balance_type_code = :p_bal_type ORDER BY consolidation_entity_id;

Related Objects

The table's relationships are defined by its primary key. The CONSOLIDATION_ENTITY_ID column is almost certainly a foreign key referencing a consolidation entity master table, such as GCS_CONS_ENTITIES or a similar entity definition table within the GCS schema. The HIERARCHY_ID likely references a hierarchy definition table (e.g., GCS_HIERARCHIES), and CAL_PERIOD_ID references a calendar period table (e.g., GCS_CAL_PERIODS). The BALANCE_TYPE_CODE would reference a lookup table for balance types. The table is central to the consolidation workflow and is referenced by various GCS consolidation engine packages and programs that load, validate, and consolidate financial data.