Oracle EBS Subledger Accounting Reports

6 ready-to-run SQL reports for Oracle E-Business Suite Subledger Accounting, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Subledger Accounting tables in these reports are fnd_application_vl, gl_ledgers, xla_ae_headers, xla_transaction_entities, xla_ae_lines, xla_distribution_links.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Subledger Accounting SQL Reports

Report Description
XLA Distribution Links Summary Summary of subledger distribution links for developers to understand which sourceids are populated for which subledger table sources. The link to subledger…
XLA Entity ID Mappings Shows the column link between table xlatransactionentities and subledger source tables such as and AP invoiceid or AR customertrxid, used when writing queries…
XLA Entity Types and Event Class Attributes Subledger event types and their attributes, for example reporting view
XLA OPM Event Type Summary  
XLA Subledger Accounting Rules Detail Listing Lists the complete Subledger Accounting rule setup in one flat grid, combining the seven separate queries of the Oracle standard XLASARDLR Subledger Accounting…
XLA Subledger Period Close Exceptions Imported from BI Publisher Description: This report extracts all those events which are either untransferred or are not accounted for. Application: Subledger…

← All Oracle EBS modules

© Enginatics GmbH