Search Results flex_select_all_low




Overview
Explore in AI Chat

Overview

APPS.GL_GLXRLFBL_XMLP_PKG is an Oracle E-Business Suite (EBS) XML Publisher (BI Publisher) report package, automatically generated by the XML Publisher concurrent program framework and stored in the APPS schema. The package encapsulates the PL/SQL logic that supports the General Ledger "Flexible Ranges / Ledger, Balance, and Line" style XML report defined in the GLXRLFBL report definition file. Its principal role is to expose the SQL fragments, bind values, and report-level parameter values that the XML Publisher data model requires in order to execute the underlying query against General Ledger source tables, and to populate the values the report template expects during the Before Report and After Report triggers.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the invoker's rights owner, and it is versioned with the RCS header comment typical of seeded EBS PL/SQL artifacts (GLXRLFBLS.pls). In the ETRM 12.2.2 classification it is registered as an OTHER API owned by APPS, which confirms it is an internal report-support package rather than a publicly callable business API.

Key Procedures and Functions

  • BEFOREREPORT — Runs as the Before Report trigger; it initialises the report-level globals and resolves any derived values (such as the ledger and access set identifiers) needed before the XML output query executes.
  • AFTERREPORT — Runs as the After Report trigger; it performs any post-query processing or cleanup once the report data set has been produced.
  • FLEX_FIELD_ALL_LOWFORMULA — Corresponds to the user search term flex_field_all_lowformula. It returns the FLEX_FIELD_ALL_LOW formula expression, concatenating the low-bound values of the key flexfield segments (SEGMENT1_LOW through SEGMENT30_LOW) of the accounting flexfield structure into a single newline-delimited string.
  • FLEX_FIELD_ALL_HIGHFORMULA — The complementary formula returning the high-bound segment values (SEGMENT1_HIGH through SEGMENT30_HIGH) aggregated in the same manner.
  • STRUCT_NUM_P — Returns the flexfield structure number in use for the report run.
  • LEDGER_NAME_P — Returns the ledger name associated with the selected ledger identifier.
  • FLEX_SELECT_ALL_LOW_P — Returns the SQL string FLEX_SELECT_ALL_LOW, which selects all low-bound accounting flexfield segment values.
  • FLEX_SELECT_ALL_HIGH_P — Returns the SQL string FLEX_SELECT_ALL_HIGH, selecting all high-bound accounting flexfield segment values.
  • ACCESS_SET_NAME_P — Returns a package-level character value representing the access set name.

Tables Accessed

  • GL_LEDGERS — Read to resolve the ledger name and the associated chart of accounts / structure information for the ledger selected on the report parameters.
  • GL_ACCESS_SETS — Read to resolve the access set that governs the flexfield range or security context applicable to the report run.

Both tables are referenced through APPS synonyms, consistent with standard EBS concurrency and security conventions.

Usage Notes

This package is not intended for direct invocation by end users or custom extensions. It is invoked automatically by the XML Publisher concurrent program that executes the GLXRLFBL report template. The formula functions such as FLEX_FIELD_ALL_LOWFORMULA are called reflectively by the XML Publisher data model engine to substitute formula fields into the generated SQL. The _P suffixed functions correspond to data model parameters that supply report-level values to the template.

Because the object is generated and seeded, it must not be modified directly; any customisation should be performed on a copy of the underlying XML Publisher report definition and its associated data template. Developers diagnosing range-flexfield display issues in this report should inspect the LOW/HIGH segment concatenation strings returned by the formula functions, since a mismatch between the flexfield structure and the segment column population is the most common root cause of unexpected report output.