Skip to the content.

ONT Defaulting Rules – Oracle EBS SQL Report

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

Overview

Shows the complete Order Management defaulting rules setup

Report Parameters

Application, Entity, Attribute, Condition, Enabled, Enabled Only, Seeded, Source Type

Oracle EBS Tables Used

oe_def_condn_elems_v, oe_def_ak_attr_ext_v, oe_def_ak_obj_ext_v, oe_def_attr_condns_v, oe_def_attr_def_rules

Report Categories

Enginatics

CST COGS Revenue Matching, AP Invoices and Lines, ONT System Parameters

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 ONT Defaulting Rules 04-Jan-2026 193839.xlsx
Blitz Report™ XML Import ONT_Defaulting_Rules.xml
Full SQL on Enginatics www.enginatics.com/reports/ont-defaulting-rules/

© 2026 Enginatics