Search Results from_chart_of_accounts_id




Overview
Explore in AI Chat

Overview

APPS.GL_GLXCOCRR_XMLP_PKG is the server-side PL/SQL package that backs the Oracle General Ledger "Chart of Accounts Mapping Report" concurrent program (short name GLXCOCRR). It is an XML Publisher (BI Publisher) report package, as indicated by the _XMLP_PKG suffix, generated from an Oracle Reports source and executed through the Concurrent Manager. Its business purpose is to produce a printable listing of the mapping between a "from" chart of accounts and a "to" chart of accounts as defined in the GL Chart of Accounts Mapping feature. The report presents both the low and high ranges of the from/to flexfield segments together with the descriptive information that identifies the mapping. The package is classified as OTHER in ETRM, meaning it is not an exposed public API but an internal report implementation artifact. All logic is contained in the package body; the corresponding specification declares the entry points the report framework calls. The package header carries an internal revision marker (120.0, dated 2007), reflecting the EBS 11i/12.x lineage of the report.

Key Procedures and Functions

Documented procedures and functions (21 total) fall into four groups.

Tables Accessed

Two tables are referenced through APPS synonyms. GL_COA_MAPPINGS supplies the chart-of-accounts mapping header information read by GL_GET_MAPPING_INFO: the from and to chart_of_accounts_id, mapping name, description, and effective date range. GL_SYSTEM_USAGES is read to obtain AVERAGE_BALANCES_FLAG into ADB_USED, which tells the report whether Average Daily Balance functionality is enabled and therefore whether ADB-specific columns should be shown. No insert, update, or delete operations are documented; the package is read-only.

Usage Notes

Invoke this package only through the GLXCOCRR concurrent program. Because it is not a public API and is referenced by zero other packages, no supported custom code path calls it directly. The report is normally submitted from the Standard Request Submission window or the GL responsibility menu, with the chart-of-accounts mapping identifier as a parameter. The program reads the mapping definition at BEFOREREPORT time, so any change to GL_COA_MAPPINGS requires a fresh submission to be reflected. When the mapping identifier cannot be resolved, GL_GET_MAPPING_INFO returns an error buffer and the package raises application error -20101, aborting the report and surfacing the underlying mapping error to the user. Because this is a report-owned package, customizations should be limited to cloned XML Publisher data definitions rather than modification of the seeded package body.