Search Results qp_qualification_ind_upg_util




Overview
Explore in AI Chat

Overview

QP_QUALIFICATION_IND_UPG_UTIL is a utility package body in the APPS schema of Oracle E-Business Suite Advanced Pricing (QP). Its name identifies its threefold purpose: it operates on qualification records, manages an indicator flag (the qualification or incompatibility indicator on pricing list lines), and provides upgrade utility logic used to migrate or normalize pre-existing pricing data into the form required by the current Advanced Pricing data model. The package is classified as a UTIL API, meaning it is not an end-user interface but an internal helper invoked by upgrade scripts, concurrent programs, and other pricing packages during release upgrades and data conversions.

Its principal business role is to seed, reset, or recompute the qualification indicator across pricing list lines and their associated qualifiers so that the pricing engine can correctly determine whether a modifier applies to an order line. The "parallel slab" routines support bulk processing of large pricing hierarchies by breaking the work into parallel slabs, which reduces the elapsed time of the upgrade on high-volume QP_LIST_LINES and QP_QUALIFIERS tables.

Key Procedures and Functions

  • INITIALIZE_QUALIFICATION_IND — Establishes the initial state of the qualification indicator for the records being processed, typically resetting or populating the indicator prior to a bulk recalculation pass.
  • REINIT_QUALIFICATION_IND — Re-initializes the indicator, allowing a subsequent run to reprocess records after a failed or partially completed cycle without leaving stale values in place.
  • SET_QUALIFICATION_IND — Applies the computed qualification or incompatibility indicator to the affected pricing list lines and qualifier rows, writing the persistent result of the utility's evaluation.
  • CREATE_PARALLEL_SLABS — Divides the population of pricing records into parallel work units so that upgrade or recalculation processing can be distributed across concurrent workers.
  • CREATE_PARALLEL_COUNT_SLABS — Performs the equivalent slab division using a count-based partitioning strategy, providing an alternative distribution scheme suited to uneven or sparse data volumes.

Parameter lists are not documented in the reference metadata and should be confirmed against the deployed package specification before direct invocation.

Tables Accessed

The package reads and writes the core Advanced Pricing entity tables through APPS synonyms:

  • QP_LIST_HEADERS_B — the pricing list (price list, modifier list) header, used to scope processing to the correct list.
  • QP_LIST_LINES — the pricing list lines whose qualification indicators are the primary target of the update.
  • QP_QUALIFIERS — the qualifier rows attached to list lines, evaluated to determine qualification.
  • QP_PRICING_ATTRIBUTES — the pricing attribute definitions that qualify how a modifier is applied.
  • QP_RLTD_MODIFIERS — relationships between modifiers, needed when qualification propagates across related modifiers.
  • QP_UPG_LINES_DISTRIBUTION — the upgrade distribution table that tracks the parallel slab assignment of list lines during conversion.

In addition to these base tables, the body depends on the packages QP_UTIL, QP_MODIFIER_UPGRADE_UTIL_PVT, and STANDARD, which supply common pricing lookups, upgrade orchestration, and error-handling/date utilities respectively.

Usage Notes

QP_QUALIFICATION_IND_UPG_UTIL is an internal upgrade and maintenance utility. It is invoked during Advanced Pricing upgrade and data-migration processing, typically from concurrent programs or upgrade driver scripts that iterate over pricing lists in parallel slabs, rather than interactively from an Oracle Forms screen. No other database object in the EBS schema references the package directly, which confirms that it is a top-level utility called only by external drivers and not by the runtime pricing engine.

Because it mutates qualification indicator data across pricing list lines and qualifiers, it should be executed only in the context of the documented upgrade procedure or under explicit direction from Oracle Support. Custom code should not call these procedures directly without first reviewing the package specification for argument signatures, as parameter details are not part of the published reference metadata and may vary between 12.1.1 and 12.2.2.