XLA Subledger Accounting Rules Detail Listing – Oracle EBS SQL Report

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

Overview

Lists the complete Subledger Accounting rule setup in one flat grid, combining the seven separate queries of the Oracle standard XLASARDLR Subledger Accounting Rules Detail Listing BI Publisher report.

There is one row per journal line type and account derivation rule priority, so the accounting method, application accounting definition, event class and type, journal line definition, journal line type, segment, derivation rule, its priority, condition and derived value all sit on the same row and can be filtered and pivoted directly.

Journal line type and account derivation rule conditions are rendered as readable text up to 8000 characters. Header and line descriptions are shown by name, with their priorities, conditions and detail aggregated into a single cell.

The Oracle report requires one application and one accounting method per run. Here every parameter is optional and accepts multiple values, so leaving them blank lists the whole instance.

Report Parameters

Application, Accounting Method Owner, Accounting Method, Event Class, Event Type, AMB Context

Oracle EBS Tables Used

Report Categories

Enginatics

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 XLA Subledger Accounting Rules Detail Listing 24-Aug-2026 235725.xlsx
Blitz Report™ XML Import XLA_Subledger_Accounting_Rules_Detail_Listing.xml
Full SQL on Enginatics www.enginatics.com/reports/xla-subledger-accounting-rules-detail-listing/

© 2026 Enginatics