Search Results oe_sets_s




Overview
Explore in AI Chat

Overview

OE_UPG_SO is an Oracle Applications upgrade utility package body owned by the APPS schema and marked VALID. Its business purpose is to migrate legacy order data structures into the Oracle Order Management (OM) transactional model that was introduced with the multi-org, multi-source order capture architecture. In the EBS 12.1.1 and 12.2.2 release streams, this package supports the one-time conversion of pre-existing sales order records — originating from legacy tables such as SO_HEADERS_ALL, SO_LINES_ALL, SO_LINE_DETAILS, SO_ORDER_SOURCES, and SO_ORDER_TYPES_115_ALL — into the standardized OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL tables.

The package is classified as OTHER in the ETRM API registry and is not referenced by any other database object, confirming its role as a standalone upgrade program rather than a runtime service used by online forms. It coordinates the transformation of order headers, lines, price adjustments, sales credits, cancellations, return processing, and distribution records, writing progress and error outcomes into the OE_UPGRADE_LOG, OE_UPGRADE_ERRORS, and OE_UPGRADE_DISTRIBUTION work tables.

Key Procedures and Functions

The ETRM metadata documents sixteen callable units within the package body. Principal conversion drivers include UPGRADE_CREATE_ORDER_HEADERS and UPGRADE_CREATE_ORDER_LINES, which move legacy header and line records into the OE order tables. Supporting these are UPGRADE_INSERT_LINES_HISTORY, which populates OE_ORDER_LINES_HISTORY for audit continuity, and UPGRADE_CREATE_LINE_SETS, which rebuilds OE_SETS groupings associated with configured or included items.

Financial and commercial detail is handled by UPGRADE_PRICE_ADJUSTMENTS and UPGRADE_SALES_CREDITS, migrating legacy pricing and credit allocations into OE_PRICE_ADJUSTMENTS and OE_SALES_CREDITS. UPGRADE_CANCELLATIONS transfers cancelled order records into OE_ORDER_CANCELLATIONS. Distribution and fulfillment data flows through UPGRADE_PROCESS_DISTBNS and UPGRADE_INSERT_DISTBN_RECORD.

Return-specific logic is contained in INSERT_RETURN_INCLUDED_ITEMS, PROCESS_UPGRADED_RETURNS, FIX_RETURNS_SPLITS, and UPGRADE_UPD_SERV_REF_LINE_ID, while INSERT_MULTIPLE_MODELS handles model/configuration hierarchies. Diagnostic and logging routines include UPGRADE_INSERT_UPGRADE_LOG and UPGRADE_INSERT_ERRORS. The package relies extensively on OE_ORDER_PUB, FND_API, FND_PROFILE, and OE_DEBUG_PUB for its internal processing.

Tables Accessed

Source data is read from legacy tables including SO_HEADERS_ALL, SO_LINES_ALL, SO_HEADER_ATTRIBUTES, SO_LINE_ATTRIBUTES, SO_LINE_DETAILS, SO_LINE_SERVICE_DETAILS, SO_ORDER_SOURCES, SO_ORDER_CANCELLATIONS, SO_PRICE_ADJUSTMENTS, SO_SALES_CREDITS, and SO_ORDER_TYPES_115_ALL. Target writes occur against OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_ORDER_LINES_S, OE_PRICE_ADJUSTMENTS, OE_PRICE_ADJUSTMENTS_S, OE_SALES_CREDITS, OE_SALES_CREDITS_S, OE_SETS, OE_SETS_S, and OE_TRANSACTION_TYPES_ALL. Control and audit tables OE_UPGRADE_LOG, OE_UPGRADE_ERRORS, OE_UPGRADE_DISTRIBUTION, and OE_UPGRADE_WSH_IFACE track progress and interface fulfillment data. Additional integration tables include MTL_SALES_ORDERS, MTL_SO_RMA_INTERFACE, RCV_SHIPMENT_LINES, RCV_SUPPLY, RCV_TRANSACTIONS, RA_CUSTOMER_TRX_LINES, and RLM_SCHEDULE_HEADERS_ALL/LINES_ALL.

Usage Notes

OE_UPG_SO is invoked during upgrade and implementation conversion windows, typically from SQL*Plus or a dedicated concurrent program that drives the ordered sequence of header, line, adjustment, credit, and return routines. It is not called from standard Order Management forms. Because it is not referenced by any other object, sites running custom migrations must call it explicitly. During migrations referencing SO_ORDER_SOURCES, administrators should verify that all legacy source codes have been seeded into OE_TRANSACTION_TYPES_ALL before execution, and monitor OE_UPGRADE_ERRORS afterwards to reconcile rejected records.