Search Results create_parallel_lines




Overview
Explore in AI Chat

Overview

The APPS.QP_LIST_UPGRADE_UTIL_PVT package is an internal (PVT) Oracle Advanced Pricing utility used during the Oracle E-Business Suite upgrade and data migration lifecycle. Its principal business function is to transform legacy Oracle Pricing or Order Management price list structures—specifically the pre-11.5.10 SO_PRICE_LISTS_B, SO_PRICE_LISTS_TL, and SO_PRICE_LIST_LINES_115 tables—into the modern Advanced Pricing model stored in QP_LIST_HEADERS_B, QP_LIST_HEADERS_TL, and QP_LIST_LINES. The package carries an AUTHID CURRENT_USER declaration, meaning it executes with the privileges of the calling schema rather than a fixed definer, which is consistent with its role as a controlled upgrade-only utility. It is also responsible for converting legacy flex structure definitions and qualifiers into the formats expected by the current pricing engine, and for distributing upgrade work across parallel workers to reduce elapsed run time on large data volumes. Because it is a private package, it is not part of the public pricing API surface and is not referenced by any other documented package within the environment.

Key Procedures and Functions

The package exposes five documented procedures, several of which accept worker and batch-size parameters to support parallel execution:

  • UPGRADE_FLEX_STRUCTURES — Migrates legacy pricing flex structure and attribute definitions into the current Advanced Pricing attribute model, establishing the context and attribute mappings required by downstream list conversion.
  • CREATE_PARALLEL_LINES — Coordinates parallel insertion of upgraded price list lines, partitioning the workload across multiple worker processes to improve throughput for high-volume data.
  • CREATE_PARALLEL_SLABS — Drives parallel creation of price list slabs (price breaks), distributing slab processing across workers in the same manner as line creation.
  • CREATE_PRICE_LIST — Creates the new Advanced Pricing list headers from legacy price list sources, accepting a batch size and worker identifier to control incremental processing.
  • CREATE_LIST_LINES — Creates and populates the child price list line records for the upgraded headers, accepting a batch size and worker number so the operation can be run in parallel chunks. This is the procedure most commonly associated with the create_list_lines search term, as it is the core routine that writes upgraded line data into QP_LIST_LINES.

Tables Accessed

The package reads legacy sources and writes to the current pricing schema. Documented legacy source tables include SO_PRICE_LISTS_B, SO_PRICE_LISTS_TL, and SO_PRICE_LIST_LINES_115. Target and working tables include QP_LIST_HEADERS_B, QP_LIST_HEADERS_TL, QP_LIST_LINES, QP_PRICING_ATTRIBUTES, QP_PRICING_ATTRIBUTES_S, QP_QUALIFIERS, QP_QUALIFIERS_S, and QP_DISCOUNT_MAPPING. The table QP_UPG_LINES_DISTRIBUTION is used to track and distribute upgrade work across parallel workers, while FND_LANGUAGES supplies language rows for translated (TL) table population. References to DUAL and PLITBLM support PL/SQL-level control and array processing.

Usage Notes

This package is invoked programmatically during the Advanced Pricing upgrade and is not intended for ad-hoc or ongoing use. It is typically executed by Oracle-provided upgrade drivers and concurrent programs rather than from a standard application form. The CREATE_LIST_LINES and CREATE_PRICE_LIST procedures accept batch size and worker parameters, allowing the upgrade to be split into independent, restartable chunks; the CREATE_PARALLEL_* procedures default to a small number of workers. Because the package is classified as PVT and is referenced by no other documented package, customers should not build custom code against it, and its signature and behavior are subject to change across release levels. Custom extensions should instead use the supported public Advanced Pricing APIs.