Oracle EBS Order Management Reports

14 ready-to-run SQL reports for Oracle E-Business Suite Order Management, 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 Order Management tables in these reports are hr_all_organization_units_vl, oe_order_lines_all, oe_transaction_types_tl, dual, oe_order_headers_all, mo_glob_org_access_tmp.

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

Order Management SQL Reports

Report Description
ONT Audit History Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and…
ONT Blanket Sales Agreements Blanket sales agreements, one row per agreement line, with the minimum and maximum quantity and amount, and the quantity and amount released, fulfilled and…
ONT Cancelled Orders Imported from BI Publisher Description: Cancelled Orders Report Application: Order Management Source: Cancelled Orders Report (XML) Short Name: OEXOEOCSXML DB…
ONT Defaulting Rules Shows the complete Order Management defaulting rules setup
ONT Order Holds Detail Sales Order report with line item details for all order lines that are on hold and the reason for the hold.
ONT Order to Cash Tracker One row per sales order or quote line with the date of each step from quote to payment, and the accounting and GL posting of its invoice. Invoice columns are…
ONT Orders Detail Sales Order or Quote header report, including status, amount and invoice status information.
ONT Orders and Lines Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information. Show Sales Credits adds one row per…
ONT Orders and Lines 11i Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information. Show Sales Credits adds one row per…
ONT Price Adjustments and Charges Price adjustments applied to sales orders: discounts, surcharges, price breaks, promotional goods and freight and special charges, one row per adjustment of an…
ONT Recurring Billing Plan Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and…
ONT System Parameters  
ONT Transaction Types Listing Imported Oracle standard Order Management transaction types listing, enhanced to show the setup across all operating units Description: Transaction Types…
ONT Transaction Types and Line WF Processes Master data report showing the setup of order management transaction types and associated line types and workflow processes.

← All Oracle EBS modules

© Enginatics GmbH