Search Results gl_cons_flexfield_map_s

Overview

GL_CONS_FLEX_MAP_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the consolidation functionality of Oracle General Ledger, specifically the maintenance of the flexfield mapping definitions used when consolidating balances from one ledger to another. Consolidation requires that the chart of accounts segments of a parent (target) ledger be mapped to the corresponding segments of a subsidiary (source) ledger; these mapping rule sets are persisted in the GL_CONS_FLEXFIELD_MAP table and its audit/shadow table GL_CONS_FLEXFIELD_MAP_S. The package encapsulates the validation and key-generation logic applied to those mapping records, ensuring that overlapping or duplicate segment mappings are not accepted and that unique identifiers are produced consistently. No other database object is documented as referencing this package, indicating that it is invoked internally by the consolidation setup components rather than exposed as a public API.

Key Procedures and Functions

ETRM documents two program units within the package body:

• CHECK_OVERLAP — Performs overlap validation on consolidation flexfield mapping definitions. Its purpose is to verify that a proposed or existing mapping does not conflict with another mapping already defined for the same consolidation context, returning an indication of whether an overlap exists so that the caller can reject or flag the entry. This protects the integrity of the mapping rule set by preventing ambiguous or duplicated segment translations.
• GET_NEW_ID — Supplies a new unique identifier for a consolidation flexfield mapping record. It is used when inserting rows into GL_CONS_FLEXFIELD_MAP so that each mapping line receives a system-generated primary key value rather than relying on a caller-supplied sequence value.

The package also references APP_EXCEPTION and FND_MESSAGE, which are used for raising application errors and returning user-facing messages when validation fails. Parameter lists are not documented in the available metadata and are therefore not enumerated here.

Tables Accessed

• GL_CONS_FLEXFIELD_MAP — The primary consolidation flexfield mapping table. The package reads and writes this table to validate and store mapping rules between source and target chart of accounts segments.
• GL_CONS_FLEXFIELD_MAP_S — The companion shadow (audit) table associated with the mapping table. It is referenced for the same consolidation mapping data and is maintained in parallel with the base table for audit and correction purposes. The user search term "gl_cons_flexfield_map_s" corresponds directly to this object.
• DUAL — The standard Oracle single-row utility table, referenced through the PUBLIC synonym for scalar evaluation and sequence-style identifier retrieval.

Usage Notes

GL_CONS_FLEX_MAP_PKG is an internal, non-public package. ETRM records no database object that references it, and the documented dependency list contains only its own package specification, the two mapping tables, DUAL, APP_EXCEPTION, and FND_MESSAGE. It is therefore not intended as an integration API for external or custom callers. In practice it is invoked from within the consolidation setup and execution flow — for example, from the consolidation mapping maintenance forms and related concurrent programs that create or validate mapping definitions prior to running consolidation. Because the package body is VALID and compiled against the APPS synonym layer, any custom development should treat it as a private implementation detail: custom code should manipulate GL_CONS_FLEXFIELD_MAP through supported APIs or the standard consolidation user interface rather than calling CHECK_OVERLAP or GET_NEW_ID directly, since their signatures and behaviour are not published and may change without notice across releases.