Search Results coa_map_name_p




Overview
Explore in AI Chat

Overview

GL_GLXCOCRR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Chart of Accounts mapping report and its associated XML Publisher (BI Publisher) concurrent program. It is classified under ETRM as an "OTHER" API, meaning it is not part of the officially supported public API surface but exists to drive an internal report execution. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the invoking user rather than the definer. The naming convention (GLXCOCRR) and the $Header comment dated 2007 confirm the package originated in the General Ledger module and has remained essentially static through the 12.1.1 and 12.2.2 releases.

The core business purpose is to present the relationship between a source chart of accounts and a target chart of accounts as defined by a Chart of Accounts Mapping. The package supplies the report with the mapping definition, the segment-level ranges (low and high) for both the from and to flexfields, and the descriptive attributes that appear on the report output.

Key Procedures and Functions

The package exposes a set of report parameters and supporting routines. The parameter-returning functions correspond directly to the concurrent program's input parameters, including COA_MAP_DESCRIPTION_P (the item the user searched for), which resolves the description of the selected Chart of Accounts Mapping, along with COA_MAP_NAME_P, FROM_CHART_OF_ACCOUNTS_ID_P, TO_CHART_OF_ACCOUNTS_ID_P, B_COA_NAME, and TO_COA_NAME_P, which expose the mapping identifiers and their chart of accounts names. Date-bounded parameters are handled by START_DATE_P and END_DATE_P, and ADB_USED_P indicates whether average daily balance is in use.

Flexfield rendering is driven by a family of formula and string-building routines: FROM_FLEXFIELD_LOWFORMULA, FROM_FLEXFIELD_HIGHFORMULA, SELECT_FROM_FLEX_LOW_P, ORDERBY_FROM_FLEX_LOW_P, SELECT_FROM_FLEX_HIGH_P, ORDERBY_FROM_FLEX_HIGH_P, SELECT_TO_FLEX_P, and ORDERBY_TO_FLEX_P. These assemble concatenated SELECT and ORDER BY expressions across the thirty segment columns of the mapping table, using the ||'\n'|| separator pattern visible in the package source. Runtime lifecycle hooks BEFOREREPORT and AFTERREPORT manage initialization and cleanup, while GL_GET_MAPPING_INFO retrieves the mapping detail used to populate the report body.

Tables Accessed

The package reads from two documented tables accessed through APPS synonyms:

  • GL_COA_MAPPINGS — the primary source of mapping data, providing the segment low/high values (segment1_low through segment30_low and the corresponding high columns referenced by the flexfield formulas) as well as mapping identity and description attributes.
  • GL_SYSTEM_USAGES — referenced to resolve system usage context, supporting the mapping and chart of accounts identification logic.

The ETRM metadata records no additional tables, and the package is documented as referenced by zero other packages, indicating it is a leaf-level report package rather than a shared utility.

Usage Notes

This package is not intended for direct invocation by custom code. It is registered against the Chart of Accounts mapping report concurrent program and is executed through the Oracle Reports / XML Publisher runtime, which calls BEFOREREPORT, evaluates the parameter functions such as COA_MAP_DESCRIPTION_P, retrieves data via GL_GET_MAPPING_INFO, and completes with AFTERREPORT. The output typically lists each mapping range and its destination accounts.

Because the package is classified as OTHER and carries a noship header comment, it should be treated as internal and subject to change without notice; customizations should interface with supported GL APIs rather than calling these routines directly. Any modification risks breaking the concurrent program and is unsupported. The package behaves consistently across 12.1.1 and 12.2.2, as the underlying mapping data model was not materially altered by the 12.2 online patching architecture.