Search Results flex_field_all_highformula




Overview
Explore in AI Chat

Overview

APPS.GL_GLXRLFBL_XMLP_PKG is a report-support package that encapsulates the PL/SQL logic for a General Ledger XML Publisher (BI Publisher) concurrent program, internally identified by the short name GLXRLFBL. The package follows the standard Oracle E-Business Suite pattern in which an XMLP_PKG is generated alongside an XML Publisher data template and report definition; the package supplies the SQL and PL/SQL constructs that the publishing engine merges into the final report output. Its identifier, GL_GLXRLFBL_XMLP_PKG, and its header (GLXRLFBLS.pls) confirm it belongs to the GL family of report packages.

The reported business purpose centers on the Flexfield Balance Listing report. The package resolves a ledger, its associated accounting flexfield structure, and the access set that governs data security, then constructs dynamic SQL to retrieve balance information for the flexfield segments. A substantial portion of the package is devoted to the FLEX_SELECT_ALL_LOW and FLEX_SELECT_ALL_HIGH variables, which build concatenated SELECT expressions across SEGMENT1 through SEGMENT30, producing a multi-line listing of the low and high ranges of each accounting flexfield segment. This is the area the user's search term "flex_field_all_highformula" refers to.

Key Procedures and Functions

The package exposes nine documented program units:

  • BEFOREREPORT — Initialization routine invoked before the data model executes; it performs setup work that must complete prior to report data retrieval.
  • AFTERREPORT — Post-processing routine executed after the report data has been fetched, typically used to finalize package-level state or output values.
  • FLEX_FIELD_ALL_LOWFORMULA — Returns the dynamic SQL or expression that produces the concatenated low-range values for all accounting flexfield segments.
  • FLEX_FIELD_ALL_HIGHFORMULA — The counterpart function for the high-range segment values. This is directly related to the search term "flex_field_all_highformula"; it exposes the FLEX_SELECT_ALL_HIGH expression, which concatenates SEGMENT1_HIGH through SEGMENT30_HIGH with newline separators for use in the report query.
  • STRUCT_NUM_P — Supplies or returns the flexfield structure number (STRUCT_NUM) used to drive segment resolution.
  • LEDGER_NAME_P — Returns the ledger name associated with the reporting ledger context.
  • FLEX_SELECT_ALL_LOW_P — Provides the low-range selected segment string.
  • FLEX_SELECT_ALL_HIGH_P — Provides the high-range selected segment string.
  • ACCESS_SET_NAME_P — Returns the name of the access set controlling row-level security for the report.

Tables Accessed

The package references two tables through APPS synonyms:

  • GL_LEDGERS — Used to validate and resolve the ledger identified by P_LEDGER_ID and to obtain the ledger name reported by LEDGER_NAME_P.
  • GL_ACCESS_SETS — Used to resolve the access set identified by P_ACCESS_SET_ID and to return its name via ACCESS_SET_NAME_P. Access sets provide the data-access security context that limits which balances are visible to the requesting user.

Usage Notes

GL_GLXRLFBL_XMLP_PKG is not a general-purpose API. It is invoked exclusively by the XML Publisher concurrent program that generates the GL Flexfield Balance Listing, with the Oracle Reports/BI Publisher runtime calling BEFOREREPORT, then the formula functions, then AFTERREPORT as the data model executes. The package declares AUTHID CURRENT_USER and is compiled as an APPS-owned object under the 12.1.1 and 12.2.2 directory structures.

It is referenced by zero other packages according to ETRM metadata, confirming it is a leaf report package rather than a reusable library. Customization efforts should not modify the package signature; changes should be applied through the underlying XML Publisher data template or report definition. When diagnosing discrepancies in the flexfield segment listing—particularly the high-range values returned by FLEX_FIELD_ALL_HIGHFORMULA—the FLEX_SELECT_ALL_HIGH variable, which concatenates SEGMENT1_HIGH through SEGMENT30_HIGH, is the first artifact to inspect.