GL Chart of Accounts Mapping Rules – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Lists the segment mapping rules and code combination mappings defined for a Global Consolidation System (GCS) chart of accounts mapping. Converted from the Oracle BI Publisher report ‘Chart of Accounts - Mapping Rules (XML)’ (GLXCOCRR_XML).

Report Parameters

COA Mapping

Oracle EBS Tables Used

gl_coa_mappings, fnd_id_flex_structures_vl, fnd_id_flex_segments, gl_cons_segment_map, gl_cons_flex_hierarchies, fnd_flex_value_hierarchies, gl_cons_flexfield_map, gl_code_combinations_kfv

Report Categories

Enginatics

Related Reports

AR Customer Upload, AR Aging, AR Transaction Upload, GL Setup Upload

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource	Link
Excel Example Output	GL Chart of Accounts Mapping Rules 19-May-2026 145746.xlsx
Blitz Report™ XML Import	GL_Chart_of_Accounts_Mapping_Rules.xml
Full SQL on Enginatics	www.enginatics.com/reports/gl-chart-of-accounts-mapping-rules(1)/

---

Useful Links

• Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
• Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
• Oracle EBS Reporting Toolkits by Blitz Report™
• Blitz Report™ FAQ & Community Q&A
• Supply Chain Hub by Blitz Report™
• Blitz Report™ Customer Case Studies
• Oracle EBS Reporting Blog
• Oracle EBS Reporting Resource Centre

© 2026 Enginatics