| layout | default |
|---|---|
| title | OPM Detailed Subledger | Oracle EBS SQL Report |
| description | OPM Financials Detailed Subledger Report showing transaction headers, extract lines with debit/credit amounts, and GL account distributions. Based on… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, OPM, Detailed, Subledger, gl_periods, xla_entity_types_vl, xla_event_classes_vl |
| permalink | /OPM%20Detailed%20Subledger/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
OPM Financials Detailed Subledger Report showing transaction headers, extract lines with debit/credit amounts, and GL account distributions. Based on Oracle standard report GMFDSUR (Detailed Subledger Report).
Reference No, Legal Entity, Ledger, Cost Type, Fiscal Year, Period, Organization, Start Date, End Date, Entity Code, Event Class, Event Type, Include Zero Amount Lines
gl_periods, xla_entity_types_vl, xla_event_classes_vl, xla_event_types_vl, gmf_subledger_rep_v, gl_subr_sta, gmf_xla_extract_lines, xla_distribution_links, xla_ae_lines, gl_code_combinations_kfv, xle_entity_profiles, gl_ledgers, mtl_parameters, hr_all_organization_units, mtl_system_items_b_kfv
GL Account Distribution Analysis, GL Account Analysis (Distributions), GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Analysis, CAC OPM WIP Account Value
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.
| Resource | Link |
|---|---|
| Excel Example Output | OPM Detailed Subledger 02-Mar-2026 075158.xlsx |
| Blitz Report™ XML Import | OPM_Detailed_Subledger.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/opm-detailed-subledger/ |
- 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