Search Results account_action_codeformula




Overview
Explore in AI Chat

Overview

GL_GLXRLMAB_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite General Ledger concurrent program GLXRLMAB (Mass Allocation Journal Report). In the Oracle EBS 12.1.1 and 12.2.2 release train, Oracle Reports-based concurrent programs rely on an automatically generated package that performs all the "before report," "after report," and formula-column processing required to prepare the XML data that the report writer then renders. This package is the program unit created for the GLXRLMAB report and is owned by the APPS schema.

The package exposes a set of global and public variables for the report, a large expression that concatenates the key flexfield segments (SEGMENT1 through SEGMENT30, joined with periods) into SEL_FLEXDATA, and a DELIMITER variable. These variables, combined with the report-level formatting and account action formulas, determine how allocation journals are displayed to the user, including how the accounting flexfield is presented and how each segment is parsed.

Key Procedures and Functions

The documented program units are as follows:

  • BEFOREREPORT — Standard Oracle Reports anchor function invoked before the report's main data query executes. It performs package initialization and any setup needed prior to report execution.
  • AFTERREPORT — Standard Oracle Reports anchor function invoked after the report finishes. It provides a hook for cleanup or finalization logic.
  • C_STANDARD_FORMULAFORMULA — a formula-column function typically used by Oracle Reports to compute a derived value for the report layout.
  • ACCOUNT_ACTION_CODEFORMULA — a formula function that derives the account-action character from the amount, ledger action code, and segment types key supplied by the report query.
  • SEL_FLEXDATA_P — accessor that returns the populated SEL_FLEXDATA key-flexfield string for use by the report.
  • DELIMITER_P — accessor that returns the DELIMITER value, the character used to separate elements when parsing or formatting flexfield output. This is directly relevant to the searched term "delimiter_p".

Tables Accessed

The package references the FND_ID_FLEX_STRUCTURES synonym. This table is read to retrieve the key flexfield structure configuration associated with the accounting flexfield, which in turn informs the segment ordering and delimiter handling used to build SEL_FLEXDATA. No other tables are documented as directly accessed by this package.

Usage Notes

GL_GLXRLMAB_XMLP_PKG is not intended to be called directly by end users. It is invoked implicitly by the Oracle Reports runtime when the GLXRLMAB concurrent program runs from the GL request submission form or through the concurrent manager. It is also referenced whenever the underlying report layout (.RDF) is executed, since Report Builder calls the before/after report and formula functions named in the package. Customization or extension is generally performed by copying the standard program or by wrapping the package, since the file header identifies it as a standard, non-supported (NOSHIP) object. The DELIMITER_P function is of particular interest to developers who need to control how the concatenated flexfield string is displayed or split during report output, especially when segment values or accounting structures differ between 12.1.1 and 12.2.2. The package is referenced by zero other packages, confirming its role as a self-contained report-side unit.