ONT Audit History – Oracle EBS SQL Report

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

Overview

Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and the user who made the change. Based on Oracle standard report OEXAUDHR_XML (Audit History Report).

Report Parameters

Operating Unit, History Date From, History Date To, Entity, Attribute, Order Number From, Order Number To, User Name, Responsibility

Oracle EBS Tables Used

oe_order_lines_all, oe_sales_credits, oe_price_adjustments, hr_all_organization_units_vl, oe_audit_attr_desc_v, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

QP Customer Pricing Engine Request, AR Customers and Sites, ONT Orders and Lines, CAC AP Accrual IR ISO Match Analysis, INV Intercompany Invoice Reconciliation, AR Customer Credit Limits

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 None
Blitz Report™ XML Import ONT_Audit_History.xml
Full SQL on Enginatics www.enginatics.com/reports/ont-audit-history/

© 2026 Enginatics