Search Results gl_rgxcond_xmlp_pkg




Overview
Explore in AI Chat

Overview

GL_RGXCOND_XMLP_PKG is the PL/SQL package body that drives a General Ledger XML Publisher concurrent report associated with account-balance or condition-style reporting. Its primary responsibility is to prepare report parameters and profile-driven configuration before the XML Publisher engine retrieves data. The package reads the chart of accounts identifier from GL_ACCESS_SETS, resolves the appropriate key flexfield structure, and determines whether the ledger uses the standard accounting flexfield (GLLE) or the attribute-based accounting flexfield (GLAT). The decision to switch to GLAT is controlled by the system profile option ATTRIBUTE_REPORTING, which must equal 'Y' and is only evaluated when the INDUSTRY profile is 'G' (the general/commercial industry type). In this way the package enables attribute reporting configurations — where additional ledger segments beyond the core accounting flexfield are tracked — to be reported consistently.

Key Procedures and Functions

  • BEFOREREPORT — Executes prior to report execution. It queries GL_ACCESS_SETS for the chart of accounts id corresponding to P_ACCESS_SET_ID, assigns C_STRUCT_NUM, sets C_ID_FLEX_CODE to 'GLLE', evaluates the INDUSTRY profile, and when attribute reporting is enabled (INDUSTRY = 'G' and ATTRIBUTE_REPORTING = 'Y') switches C_ID_FLEX_CODE to 'GLAT' and concatenates the multiple flexfield low/high/type/prompt parameters. It also replaces literal segment tokens with the GLLED.short_name substitution and derives the segment delimiter via FND_FLEX_APIS.gbl_get_segment_delimiter, defaulting to '-' when none is returned.
  • AFTERREPORT — Performs post-report cleanup; the SRW exit call is retained as a no-op in this release, and the function returns TRUE.
  • C_FLEX_LOWFORMULA / C_FLEX_HIGHFORMULA / C_FLEX_TYPEFORMULA — Formula columns used by the XML Publisher/Report Builder layout to resolve low, high, and type flexfield value expressions dynamically based on the resolved flexfield code and structure.
  • C_STRUCT_NUM_P, C_ID_FLEX_CODE_P, C_INDUSTRY_TYPE_P, C_ATTRIBUTE_FLAG_P — Accessor functions that expose the package-level variables C_STRUCT_NUM, C_ID_FLEX_CODE, C_INDUSTRY_TYPE, and C_ATTRIBUTE_FLAG to the report definition for use in lexical and formula references.

Tables Accessed

The package reads GL_ACCESS_SETS to obtain the chart_of_accounts_id for the requested access set, which establishes the accounting flexfield structure. It selects from DUAL to invoke FND_FLEX_APIS.gbl_get_segment_delimiter. It does not write to any application tables, reinforcing its role as a read-only report configuration helper. The GLLED.short_name reference resolved in the lexical replacement corresponds to the GL ledger table alias used elsewhere in the report's query.

Usage Notes

This package body is not invoked by other PL/SQL packages (referenced by zero documented packages) and is instead executed by the Oracle Reports/XML Publisher runtime when the associated RGXCOND concurrent program is submitted. Because the behavior depends on the INDUSTRY and ATTRIBUTE_REPORTING profile options, administrators enabling attribute reporting must set ATTRIBUTE_REPORTING to 'Y' at the appropriate site, application, or responsibility level for the report to use the GLAT flexfield. The package is relevant in both EBS 12.1.1 and 12.2.2, where the underlying GL access set and flexfield APIs remain consistent. Customizations should avoid modifying the delivered package body directly; instead, profile settings or report parameter values should be adjusted to alter runtime behavior.