Search Results check_overlap

Overview

APPS.GL_CONS_FLEX_MAP_PKG is a PL/SQL package in Oracle General Ledger that supports the Consolidation Setup form, specifically the Flexfield Mapping Rules block. Its business purpose is to manage and validate the mapping rules that translate a subsidiary ledger's chart of accounts (and other key flexfields) into the balancing segment and account structure of a parent or consolidation ledger. During consolidation, balances must be aggregated from one or more subsidiary ledgers into a single parent ledger, and each subsidiary's flexfield combinations must be mapped to the corresponding parent account. This package provides the server-side logic that lets users define, validate, and store those mapping rules, most notably by detecting overlapping subsidiary flexfield ranges before a rule is saved.

The package was created in 1994 (E. Wilson) and carries a header revision of 120.4. It is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking user, which in the EBS forms context is the APPS schema.

Key Procedures and Functions

Two documented program units exist in the package:

• CHECK_OVERLAP — The procedure central to the user's search. Its stated purpose is to "check for overlapping subsidiary flexfield ranges." It accepts a COA mapping identifier, a row identifier, and low/high segment value pairs for each of the thirty possible key flexfield segments. It is designed to be called from the Flexfield Mapping Rules block of the Consolidation Setup form, as illustrated in the source comments, where each :FLEXFIELD_MAP.segmentN_low and :FLEXFIELD_MAP.segmentN_high is passed for segments 1 through 30. The routine verifies that a newly entered or edited subsidiary range does not overlap an existing range already defined for the same COA mapping, thereby preventing ambiguous or duplicate consolidation mappings.
• GET_NEW_ID — A utility that returns a new unique identifier, typically used to populate the primary key (for example, the COA mapping or row identifier) when a new flexfield mapping rule record is created through the form.

Tables Accessed

The package references the following tables through APPS synonyms:

• GL_CONS_FLEXFIELD_MAP — The base table holding consolidation flexfield mapping rules, including the subsidiary low/high segment ranges and the associated COA mapping identifier. CHECK_OVERLAP queries this table to detect existing ranges that overlap a candidate range, while GET_NEW_ID and the form's DML operations work against the same data.
• GL_CONS_FLEXFIELD_MAP_S — The corresponding "S" (shadow) table that stores the translated/parent-side mapping values associated with each rule, used when deriving the parent account from a subsidiary flexfield combination.
• DUAL — Used for scalar evaluations, such as generating or selecting a sequence value in GET_NEW_ID.

Usage Notes

GL_CONS_FLEX_MAP_PKG is invoked primarily from the Consolidation Setup form when a user maintains Flexfield Mapping Rules. The WHEN-VALIDATE-RECORD or equivalent trigger calls CHECK_OVERLAP to validate the entered ranges against stored rules, raising an error if an overlap is found so the user must correct the mapping. GET_NEW_ID is used to assign identifiers for new rules. The package is not referenced by any other documented package, so its exposure is essentially form-driven, though custom consolidation or interface code may call the same procedures directly. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is accessed by the forms runtime under APPS privileges.