Search Results gcs_entities_attr_pk

Overview

The GCS_ENTITIES_ATTR table is a core data object within Oracle E-Business Suite's Financial Consolidation Hub (GCS) module. It functions as a reference and control table that stores supplemental attribute information for consolidation entities. An entity in GCS typically represents a legal or business unit, such as a subsidiary or division, that is part of the financial consolidation hierarchy. This table defines the specific types of additional data, or attributes, that are tracked and required for each entity during the consolidation process. Its role is to provide a flexible framework for managing entity-specific metadata, ensuring that the correct data types and structures are available for consolidation calculations, reporting, and compliance activities.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental data it holds. The key columns are ENTITY_ID and DATA_TYPE_CODE. The ENTITY_ID column uniquely identifies the consolidation entity, linking it to the master entity definition. The DATA_TYPE_CODE column stores a code that categorizes the type of additional attribute data associated with that entity. While the provided metadata does not list non-key columns, tables of this nature in GCS commonly include control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and potentially columns for enabling/disabling the attribute or storing a sequence number. The table essentially maintains a many-to-many relationship between entities and the types of extended data they possess.

Common Use Cases and Queries

This table is primarily used for setup validation and dynamic reporting within consolidation processes. A common use case is to verify which data types are enabled for a specific entity before running a consolidation program, ensuring all prerequisite data is present. For reporting, it can be used to filter or label data based on entity attributes. A typical query would join this table to the main entity table (GCS_ENTITIES_B) to list all configured data types per entity.

• Sample Query: SELECT ge.ENTITY_NAME, gea.DATA_TYPE_CODE FROM GCS_ENTITIES_B ge, GCS_ENTITIES_ATTR gea WHERE ge.ENTITY_ID = gea.ENTITY_ID ORDER BY ge.ENTITY_NAME;
• Setup Validation: Administrators query this table via front-end setup forms or directly in SQL to audit entity configurations and troubleshoot missing data errors during consolidation.

Related Objects

The GCS_ENTITIES_ATTR table has defined relationships with other key consolidation tables, primarily through its primary key. The relationship data indicates the primary key is GCS_ENTITIES_ATTR_PK on columns (ENTITY_ID, DATA_TYPE_CODE).

• GCS_ENTITIES_B: This is the master table for consolidation entities. The ENTITY_ID column in GCS_ENTITIES_ATTR is almost certainly a foreign key referencing GCS_ENTITIES_B.ENTITY_ID, establishing that an attribute record must belong to a valid entity.
• Data Type Lookup Table: While not specified in the metadata, a lookup table (such as GCS_DATA_TYPES_B) typically exists to define valid DATA_TYPE_CODE values. The DATA_TYPE_CODE in GCS_ENTITIES_ATTR would be a foreign key to this lookup table.
• Transaction/Entry Tables: Tables storing actual consolidation journal entries or adjustment data may reference the combination of ENTITY_ID and DATA_TYPE_CODE to tag transactional data with the correct attribute.