Search Results create_freight_record




Overview
Explore in AI Chat

Overview

OE_UPGRADE_MISC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. As its name implies, it is a utility package whose primary purpose is to support data conversion, upgrade, and one-time correction activities associated with the Oracle Order Management (OE) module. Rather than exposing a public application programming interface for day-to-day transactional processing, OE_UPGRADE_MISC consolidates a small set of helper routines that are invoked during release upgrades, patch application, and migration of legacy order and pricing data into the 12.1.1 or 12.2.2 data model.

The package is documented in ETRM with a status of VALID and is classified as an "OTHER" API, confirming that it is not a standard, externally supported interface such as OE_ORDER_PUB. Its dependency footprint is deliberately narrow: it references only SYS.STANDARD and, within APPS, is referenced by OE_PARTY_TOTALS and by itself. This self-referential and limited dependency pattern is characteristic of an internal upgrade utility that manipulates pricing, freight, and currency data during controlled batch operations rather than during interactive user sessions.

Key Procedures and Functions

The ETRM metadata documents four callable units within OE_UPGRADE_MISC. They are described below by purpose only; parameter lists are not published in the metadata and should be derived from the package specification in a given environment.

  • CONVERT_CURRENCY — Converts monetary values between currencies, typically applying the appropriate conversion rate and rounding rules so that legacy amounts are restated in the functional or reporting currency required by the upgraded data model.
  • CREATE_FREIGHT_RECORD — Constructs freight-related records, most likely charge lines or price adjustment entries associated with freight, so that historical shipping charges are preserved and represented correctly after upgrade.
  • ROUND_AMOUNT — Applies currency-specific rounding to a monetary amount. This ensures that converted and recalculated values comply with the precision rules defined for the target currency.
  • GET_SOB_CURRENCY — Returns the currency associated with a given set of books (SOB), allowing upgrade routines to determine the correct functional currency context for conversion and rounding operations.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • FND_CURRENCIES — Provides currency definitions and related attributes used by CONVERT_CURRENCY and ROUND_AMOUNT.
  • AR_SYSTEM_PARAMETERS_ALL — Supplies set of books and functional currency context leveraged by GET_SOB_CURRENCY.
  • OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S — Store the price adjustment (freight and charge) records created or corrected by CREATE_FREIGHT_RECORD.
  • QP_LIST_HEADERS_B, QP_LIST_HEADERS_TL, and QP_LIST_LINES — Advanced Pricing list structures consulted to resolve the modifiers, lists, and lines that back freight and adjustment records.
  • DUAL — Used for single-row evaluations and lookups within the PL/SQL logic.

Usage Notes

OE_UPGRADE_MISC is an internal upgrade utility and is not intended for general application development. It is typically invoked by upgrade scripts, patch drivers, or conversion concurrent programs during the transition to 12.1.1 or 12.2.2, and it may also be called from PL/SQL blocks inside larger migration routines. Because it is referenced by OE_PARTY_TOTALS, any change to its behavior can affect party total calculations performed during the same upgrade window.

Developers and DBAs should treat the package as version-specific: its procedures exist to satisfy particular upgrade tasks, and Oracle does not guarantee their signatures or behavior across releases. Custom code should not call these routines directly unless the dependency has been explicitly validated for the target release, and any direct invocation should be confined to controlled, non-production testing until the upgrade path has been proven.