Search Results insert_return_included_items

Overview

OE_UPG_SO is a legacy upgrade utility package in the Oracle E-Business Suite Order Management (OE) module, owned by the APPS schema and classified as an "OTHER" API. Its name — Order Entry Upgrade Sales Orders — indicates its role: converting pre-11i or transitional sales order data into the normalized Order Management schema introduced in the 11i/12.x data model, particularly around blanketed sales agreements, pricing, sales credits, cancellations, and line-level sets.

The package was frozen under the header OEXIUSOS.pls 120.0 (June 2005) and remains present in 12.1.1 and 12.2.2 for backward compatibility with older upgrade paths, but it is not part of the supported public API surface. It is not referenced by any other package, meaning it is called directly by concurrent upgrade programs and one-off scripts rather than through the normal application stack.

Key Procedures and Functions

The package exposes 16 documented procedures that divide into several functional families:

• Header and line creation: UPGRADE_CREATE_ORDER_HEADERS and UPGRADE_CREATE_ORDER_LINES seed OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL from legacy staging data. UPGRADE_CREATE_LINE_SETS (the object matching the search term upgrade_create_line_sets) populates OE_SETS and OE_SETS_S, linking lines into model/option and included-item set structures.
• Pricing and credits: UPGRADE_PRICE_ADJUSTMENTS migrates modifier/qualifier rows into OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S; UPGRADE_SALES_CREDITS migrates sales rep splits into OE_SALES_CREDITS and OE_SALES_CREDITS_S.
• Cancellations and returns: UPGRADE_CANCELLATIONS writes cancellation records using the Canc_Rec_Type record; PROCESS_UPGRADED_RETURNS, INSERT_RETURN_INCLUDED_ITEMS, and FIX_RETURNS_SPLITS rebuild return-authorization relationships and correct split line references.
• Models and service references: INSERT_MULTIPLE_MODELS creates model/option hierarchies; UPGRADE_UPD_SERV_REF_LINE_ID reconciles service reference line IDs against the new line identifier scheme.
• Audit and diagnostics: UPGRADE_INSERT_LINES_HISTORY writes to OE_ORDER_LINES_HISTORY; UPGRADE_INSERT_UPGRADE_LOG records progress; UPGRADE_INSERT_ERRORS and UPGRADE_INSERT_DISTBN_RECORD capture failures and distribution rows; UPGRADE_PROCESS_DISTBNS finalizes distribution records in OE_UPGRADE_DISTRIBUTION.

The package maintains numerous package-level globals (G_ORD_CANC_FLAG, G_HDR_CANC_FLAG, G_COPIED_FLAG, G_AUTO_FLAG, G_LINE_ID_CHANGE_FLAG, and others) that flag state transitions across sequential upgrade calls, plus record types such as Canc_Rec_Type for cancellation payloads.

Tables Accessed

The package reads and writes the core Order Management tables through APPS synonyms:

• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_ORDER_LINES_S — the target sales order schema.
• OE_ORDER_LINES_HISTORY — audit trail of upgraded line changes.
• OE_SETS and OE_SETS_S — model/option set definitions populated by UPGRADE_CREATE_LINE_SETS.
• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S — migrated modifier records.
• OE_SALES_CREDITS and OE_SALES_CREDITS_S — migrated revenue splits.
• OE_TRANSACTION_TYPES_ALL — transaction type validation for converted orders.
• MTL_SALES_ORDERS and MTL_SO_RMA_INTERFACE — inventory-side order and RMA linkage.
• OE_UPGRADE_DISTRIBUTION and OE_UPGRADE_ERRORS — the package's own staging and error tables.

Usage Notes

OE_UPG_SO is not invoked from Oracle Forms or standard concurrent programs in the current release. It is called by legacy upgrade concurrent programs and one-off migration scripts executed during the transition from pre-11i or 11i order data into the 11i10/12.x model. Because it is classified as OTHER and carries a 2005 header, it should be treated as an internal implementation object: custom code should not call it, and any new development should use the supported OE_ORDER_PUB and related public APIs instead. Its presence in 12.1.1 and 12.2.2 exists solely to support historical upgrade routines that are retained but no longer actively executed in fresh installations.