GL Chart of Accounts Mapping Rules – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports

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).

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

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, R12 only

AR Customer Upload, AR Aging, AR Transaction Upload, AP Trial Balance Report Definitions, GL Setup Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

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
SQL Source GL Chart of Accounts Mapping Rules.sql
Full Report on Enginatics www.enginatics.com/reports/gl-chart-of-accounts-mapping-rules(1)/

Case Study & Technical Analysis: GL Chart of Accounts Mapping Rules

Executive Summary

This report lists the mapping rules of a Global Consolidation System (GCS) chart of accounts mapping in Oracle General Ledger. A mapping translates balances from a source chart of accounts into a target chart of accounts, and the report shows both kinds of rule: segment rules, which map segment values or value ranges, and code combination rules, which map a range of source code combinations to a target code combination. It is written for consolidation and group reporting accountants who must confirm that a mapping used for the group consolidation translates every account as intended, and for those who need to explain the mapping during a review. It is converted from the Oracle BI Publisher report Chart of Accounts - Mapping Rules (GLXCOCRRXML).

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. GL_COA_MAPPINGS is joined to the source and target chart of accounts structures on their identifiers.
  2. The segment branch joins the target segments of the target structure to the segment mapping rules of the mapping.
  3. The source segment is joined through the source structure, and the source ranges come from the child values of a hierarchy or value set.
  4. The code combination branch joins the mapping’s code combination rules to the target code combination.
  5. The two branches are combined with UNION ALL and labelled as Segment Rule or Code Combination Rule.
  6. The code combination ranges are built by concatenating the low and high segment values of the mapping row, separated by the delimiter of the source chart of accounts.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How do I review the rules of a consolidation mapping? A: Select the mapping in the COA Mapping parameter. Segment rules appear first, followed by code combination rules.

Q: What does a segment rule with a parent rollup value mean? A: The source value range is taken from the child values of the parent rollup value in the source value set hierarchy, which is shown in the source range columns.

Q: How can I see when a mapping rule was last changed? A: Each row shows the last updated by user and the last update date of the rule.

© Enginatics GmbH