Search Results gcs_entity_cctr_orgs_u1

Overview

GCS.GCS_ENTITY_CCTR_ORGS is a summary table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the GCS schema and registered under the FND Design Data as GCS.GCS_ENTITY_CCTR_ORGS. It stores all organizations associated with local entities within each consolidation hierarchy, consolidating the relationship between a legal entity and the company cost center organizations it spans. The table resides in the APPS_TS_SEED tablespace, indicating that its contents are typically treated as seed or reference data established during implementation and consumed by consolidation and financial reporting processes.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. Because the structure is purely an association between two defining columns — ENTITY_ID and COMPANY_COST_CENTER_ORG_ID — without descriptive or attribute-rich payload, a modeler would reasonably treat it as a link (association) or a simple mapping table rather than a hub or satellite. Its standalone classification reflects that no foreign-key relationships are documented, so the table is self-contained from a DDL dependency standpoint.

Key Information Stored

The table contains eight documented columns. The most important are:

• ENTITY_ID (NUMBER, mandatory): the entity defining column; identifies the legal entity within the consolidation hierarchy.
• COMPANY_COST_CENTER_ORG_ID (NUMBER, mandatory): the organization dimension defining column; identifies the company cost center organization linked to the entity.
• OBJECT_VERSION_NUMBER (NUMBER, length 15): the object version number used for optimistic locking and change tracking.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN: the standard Who columns that capture audit metadata for insert and update activity.

The surrogate primary key is GCS_ENTITY_CCTR_ORGS_PK, defined on the composite of ENTITY_ID and COMPANY_COST_CENTER_ORG_ID. A unique index, GCS_ENTITY_CCTR_ORGS_U1, is defined on the same two columns (ENTITY_ID, COMPANY_COST_CENTER_ORG_ID) in the APPS_TS_SEED tablespace. Because the unique index columns match the primary key, these two columns are also the business-key candidates: the entity-to-organization pairing must be unique within the summary.

Common Use Cases and Queries

Typical usage centers on consolidation and organization-dimension reporting. For example, retrieving all cost center organizations for a given entity:

• SELECT COMPANY_COST_CENTER_ORG_ID FROM GCS.GCS_ENTITY_CCTR_ORGS WHERE ENTITY_ID = :entity_id;
• SELECT ENTITY_ID, COMPANY_COST_CENTER_ORG_ID FROM GCS.GCS_ENTITY_CCTR_ORGS ORDER BY ENTITY_ID, COMPANY_COST_CENTER_ORG_ID;

A completeness query such as SELECT * FROM GCS.GCS_ENTITY_CCTR_ORGS; returns the full column set documented in the ETRM. Because the table is a summary of organizations per entity within a consolidation hierarchy, it supports validation that every local entity has the expected cost center organizations mapped before running consolidation or financial statement generation. Reporting layers frequently join this table to organization and entity dimension tables externally, since no foreign keys are declared in the schema itself.

Related Objects

The ETRM dependency data states that GCS.GCS_ENTITY_CCTR_ORGS does not reference any database object, and that it is referenced only by the APPS synonym GCS_ENTITY_CCTR_ORGS. Consequently, the FK/PK-based relationship set is minimal. The most significant related objects are:

• APPS.GCS_ENTITY_CCTR_ORGS: the APPS-level synonym exposing the GCS table to concurrent programs and PL/SQL within the APPS schema.
• GCS_ENTITY_CCTR_ORGS_PK: the primary key constraint enabling unique retrieval by entity and organization.
• GCS_ENTITY_CCTR_ORGS_U1: the unique index guaranteeing the business-key uniqueness of the (ENTITY_ID, COMPANY_COST_CENTER_ORG_ID) pair.
• Entity and organization dimension tables in the GCS schema, joined upon ENTITY_ID and COMPANY_COST_CENTER_ORG_ID respectively, to resolve descriptive names for reporting.