Search Results g_proj_flg

Overview

GCS_ENTITIES_PKG is the consolidation hierarchy engine within the Oracle E-Business Suite Financial Consolidation Hub (FCH) module. The package body, owned by APPS and shipped under the header gcsenttb.pls, provides the core procedural logic for building, maintaining, and loading consolidation entities and their organizational relationships. In the context of Oracle EBS 12.1.1 and 12.2.2, this package operates against the GCS and FEM schema objects that underpin the consolidation dimension model.

The package carries a private global variable block that mirrors the full set of consolidation dimension attributes — channel (G_CHAN_FLG), cost center (G_CCTR_FLG), customer (G_CUST_FLG), geography (G_GEOG_FLG), line item (G_LN_ITEM_FLG), natural account (G_NAT_ACCT_FLG), product (G_PROD_FLG), project (G_PROJ_FLG), and ten user-defined dimensions (G_USER1_FLG through G_USER10_FLG). These flags determine which dimensional attributes are active for a given entity, driving conditional logic during entity load and attribute resolution. The package also embeds a standard logging framework (Module_Log_Write) that records module entry and exit points to the FND_LOG repository when the runtime log level permits, supporting diagnostic tracing of consolidation hierarchy operations.

The package is significant to the user search for "fem_entities_attr" because it is one of the principal consumers of the FEM_ENTITIES_ATTR table, which stores the attribute-level details of consolidation entities defined in the FEM (Financials Foundation) dimension model.

Key Procedures and Functions

Three procedures are documented for this package body:

• ADD_TO_SUMMARY_TABLE — Populates a summary or aggregation structure with entity-level data. This procedure supports the consolidation hierarchy by staging entity records into a summary table that downstream summarization and reporting processes consume.
• LOAD_ENTITIES — The primary entity-loading routine. It reads entity definitions and their associated attributes from the FEM and GCS base tables, applies the active dimension flags held in the private global variables, and inserts or updates the corresponding entity records. This procedure is the main entry point for refreshing the consolidation entity hierarchy from source definitions.
• UPDATE_ENTITY_ORGS — Maintains the organizational assignments attached to consolidation entities. It reconciles the relationship between entities and their organizations, writing to the GCS entity-organization mapping tables.

The package additionally contains private helper procedures, including Module_Log_Write, which are not part of the public API but support internal execution tracing.

Tables Accessed

The package reads and writes a broad set of consolidation and financials foundation tables via APPS synonyms:

• FEM_ENTITIES_ATTR — Stores the attribute-level detail of consolidation entities; central to the attribute flag logic.
• FEM_ENTITIES_B — The base entity definition table holding the master entity records.
• FEM_DIM_ATTRIBUTES_B and FEM_DIM_ATTR_VERSIONS_B — Define the dimension attributes and their versioned definitions used to resolve entity attributes.
• FEM_CCTR_ORGS_ATTR — Cost center to organization attribute mappings.
• GCS_ENTITIES_ATTR — GCS-side entity attribute storage.
• GCS_ENTITY_CCTR_ORGS and GCS_ENTITY_ORGANIZATIONS — Entity-to-organization and cost center relationship tables updated by UPDATE_ENTITY_ORGS.
• GCS_LEX_MAP_RULE_SETS and GCS_ROLE_ENTITY_RELNS — Mapping rule sets and role-entity relationships that govern consolidation processing.
• GCS_XML_FILES — Storage for XML payloads associated with consolidation definitions.
• FND_FLEX_VALUES_S and WF_LOCAL_ROLES — Key flexfield value and role resolution lookups.
• GL_SETS_OF_BOOKS_S — Set of books context for entity scoping.
• DBMS_LOB — Used for large object manipulation, consistent with XML file handling.

Usage Notes

GCS_ENTITIES_PKG is an internal consolidation engine package rather than a directly invoked user API. It is referenced by zero other packages in the documented metadata, indicating it is called from the Financial Consolidation Hub user interface and its supporting concurrent programs — typically the entity load and hierarchy synchronization processes — rather than from external integrations. The procedures are invoked when consolidation administrators define or refresh entities and their organizational assignments. Custom code interfacing with consolidation hierarchies should treat this package as internal and interact instead with the documented GCS/FEM tables or supported FCH APIs. Note that the versioning header dates the body to 2007, and it remains compatible across 12.1.1 and 12.2.2.