Search Results gl_cons_flex_hier_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_CONS_FLEX_HIER_PKG is a PL/SQL package owned by the APPS schema that supports the management of consolidation hierarchies for the Oracle General Ledger Consolidation (GL_CONS) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to administer the structure of consolidation hierarchies — the parent/child relationships that define how a parent ledger aggregates balances from one or more subsidiary ledgers — by providing the low-level row maintenance operations required to create, lock, update, and remove hierarchy entries. The package is classified as OTHER rather than as a public API, indicating that it functions primarily as an internal support-layer object rather than a supported integration interface.

Key Procedures and Functions

The package exposes seven documented procedures. OVERLAP is associated with overlap validation logic, determining whether hierarchy ranges conflict with one another. COUNT_RANGES supports range accounting, typically returning or tracking the number of ranges defined for a hierarchy node. INSERT_ROW and DELETE_ROW perform the fundamental row-level insert and delete maintenance required to persist and remove hierarchy records. LOCK_ROW implements a locking step, providing concurrency control so that hierarchy edits on a parent record are serialized and not lost to concurrent sessions. UPDATE_ROW updates an existing hierarchy record, and UPDATE_PARENT_VALUES propagates or maintains the parent-side values associated with a hierarchy node. Together these routines form the standard create/read-update-delete surface with explicit locking and overlap-checking support characteristic of hierarchy maintenance utilities.

Tables Accessed

Via APPS synonyms, the package references FND_FLEX_VALUE_HIERARCHIES, the key flexfield value hierarchy table used by the Applications flexfield infrastructure; GL_CONS_FLEX_HIERARCHIES, the General Ledger consolidation flexfield hierarchy table that stores the consolidation hierarchy definitions themselves; GL_CONS_SEGMENT_MAP and GL_CONS_SEGMENT_MAP_S, the consolidation segment mapping table and its translation counterpart, which associate source and target segments for consolidation; and DUAL, the standard Oracle single-row pseudo-table used for simple scalar operations. These tables indicate that the package operates directly against the flexfield hierarchy storage layer, writing and reading the consolidation hierarchy definitions that determine how segment values roll up for consolidated reporting.

Usage Notes

The package is invoked programmatically rather than as a standalone entry point. It is most commonly called from the Oracle Forms-based and OA Framework consolidation setup screens that let users define and maintain consolidation hierarchies, where the form triggers perform the insert, update, delete, lock, and overlap-validation calls interactively. It may also be invoked from concurrent processing routines or custom code that programmatically builds or adjusts consolidation hierarchies. Because the package is classified as OTHER and is not a documented public API, customizations should invoke it with caution. Direct DML against the underlying GL_CONS and FND_FLEX_VALUE_HIERARCHIES tables is generally discouraged; where the consolidation hierarchy must be manipulated outside the forms, the safest approach in EBS 12.1.1 and 12.2.2 is to reproduce the package's locking and overlap-checking sequence so that concurrent edits remain consistent with the standard user interface behavior.