Search Results ont_freight_util




Overview
Explore in AI Chat

Overview

ONT_FREIGHT_UTIL is a utility package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as a UTIL (utility) object. It resides within the Order Management (ONT) module and supports freight and charge-related pricing activity for sales orders. The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking session rather than the package owner, which is consistent with a diagnostic or helper utility embedded within the broader Oracle Order Management pricing and freight infrastructure.

The single documented procedure, FREIGHT_DEBUG, indicates that the package's primary purpose is to surface diagnostic information about freight charges applied to order lines. In Oracle Order Management, freight and other charges are frequently modeled as price adjustments generated through the Oracle Advanced Pricing engine (QP), and reconciling why a particular charge was or was not applied can be complex. ONT_FREIGHT_UTIL provides a debug entry point for this reconciliation.

Key Procedures and Functions

  • FREIGHT_DEBUG — The only documented procedure in the package (1 total). It accepts an optional header name, an optional list line identifier, and a mandatory line identifier, all of which serve to scope the debug output to a particular order, pricing list line, or order line. Its purpose is to emit diagnostic details regarding freight charge determination for the specified context. The procedure does not return a value; its output is diagnostic in nature. Parameter lists are documented as shown in the source header and should not be assumed to extend beyond these arguments.

No other procedures or functions are documented for this package in the ETRM metadata. The package is not referenced by any other documented packages, confirming its role as a standalone diagnostic helper rather than a shared programmatic dependency.

Tables Accessed

The package references a defined set of tables through APPS synonyms, spanning order management, advanced pricing, and shipping:

The table footprint confirms that FREIGHT_DEBUG correlates order line data, applied price adjustments, pricing setup, and delivery details to explain freight outcomes.

Usage Notes

ONT_FREIGHT_UTIL is a utility and debugging aid rather than a functional business API. It is typically invoked from custom PL/SQL during troubleshooting, or from diagnostic code paths, when freight charges on a sales order line behave unexpectedly. Because FREIGHT_DEBUG accepts a mandatory line identifier plus optional header and list line identifiers, callers generally supply at least the order line to be investigated.

Given its UTIL classification and its lack of references from other documented packages, it should not be treated as a supported integration point. Customizations should call it only for diagnostic purposes, and developers should rely on Oracle's documented Order Management and Advanced Pricing APIs for functional freight processing. Behavior may vary between EBS 12.1.1 and 12.2.2, so testing in the target release is advisable.