Search Results gl_flexfields_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_FLEXFIELDS_PKG is a server-side PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that provides utility routines for resolving and describing the structure and content of key flexfields, primarily the Accounting Key Flexfield used throughout the General Ledger and subsidiary ledgers. Its role is to translate the individual segment values of a key flexfield combination into the human-readable descriptions, concatenated account strings, and structural metadata required by reporting, validation, and integration logic. The package encapsulates common flexfield operations — retrieving segment values, resolving value set descriptions, and obtaining chart of accounts information — so that other GL programs, XML Publisher reports, and public APIs do not need to re-implement flexfield navigation logic against the underlying FND foundation tables.

The package is classified as an OTHER API in the ETRM metadata for release 12.2.2, and its status is VALID. It is heavily used within the EBS financials codebase, with six known dependent packages, including GL_ACCESS_DETAILS_PKG, GL_BUDGET_ENTITIES_PKG, FII_GL_BIS_MSC_PKG, and several report integration packages such as GL_GLXACDAL_XMLP_PKG, GL_GLXRLRUR_XMLP_PKG, and GL_GLXRLSEG_XMLP_PKG.

Key Procedures and Functions

The documented package exposes twelve procedures and functions that cover segment retrieval and flexfield description resolution:

  • GET_ACCOUNT_SEGMENT — Returns the value of a specified accounting flexfield segment for a given combination, allowing callers to extract a single segment from a concatenated account.
  • GET_DESCRIPTION — Resolves the description associated with a flexfield segment value, returning the descriptive text rather than the stored value.
  • GET_ANY_SEG_DESCRIPTION — Provides a generalized segment description lookup that can resolve descriptions across any flexfield segment, not restricted to a single designated segment.
  • GET_COA_NAME — Returns the name of the Chart of Accounts associated with a given key flexfield structure or combination.
  • GET_COA_INFO — Retrieves structural information about the Chart of Accounts, such as its identifier and configuration metadata.
  • GET_SD_DESCRIPTION_SQL — Generates or returns the SQL fragment used to resolve segment description (SD) values, typically for dynamic reporting.
  • GET_DESCRIPTION_SQL — Builds the SQL construct used to obtain flexfield value descriptions, enabling report queries to join flexfield values to their descriptions.
  • GET_SUMMARY_FLAG — Determines whether a segment value is a summary (parent) account, which cannot be posted to directly.
  • GET_PARENT_FROM_CHILDREN — Returns the parent segment value associated with a supplied child value through the flexfield hierarchy.
  • GET_CONCAT_DESCRIPTION — Produces a concatenated description string for the full account or segment combination, useful for reporting and interface output.
  • GET_QUALIFIER_SEGNUM — Identifies the segment number associated with a particular flexfield qualifier, such as the Balancing or Cost Center qualifier.
  • GET_VALIDATION_ERROR_MESSAGE — Returns an appropriate error message when a flexfield value fails validation rules, supporting user feedback in validation routines.

Tables Accessed

The package reads from several Foundation (FND) flexfield and application tables through APPS synonyms:

  • FND_FLEX_VALUE_SETS — Defines the value sets assigned to each flexfield segment, providing the source for value and description lookups.
  • FND_ID_FLEX_SEGMENTS — Stores segment definitions and attributes for the key flexfield structure, used to resolve segment numbers and qualifiers.
  • FND_FLEX_VALUE_NORM_HIERARCHY — Provides value hierarchy and roll-up relationships, used by GET_PARENT_FROM_CHILDREN and GET_SUMMARY_FLAG.
  • FND_FLEX_VALIDATION_TABLES — Supports validation rules applied to flexfield values, feeding error-message resolution logic.
  • FND_SEGMENT_ATTRIBUTE_VALUES — Supplies segment attribute information used when interpreting flexfield configuration.
  • DBMS_SQL — The Oracle-supplied dynamic SQL package, used to execute dynamically constructed description and hierarchy queries.

Usage Notes

GL_FLEXFIELDS_PKG is typically invoked from within other PL/SQL packages, concurrent programs, and XML Publisher report logic rather than directly by end users. It is referenced by General Ledger access, budget, and reporting packages, and by XML Report Publisher integration packages that need to display descriptive account information. Custom code should call the documented functions for read-only description resolution; the package is not intended as a general-purpose data maintenance API, and direct dependence on its internal SQL construction may be affected by flexfield configuration changes.