Search Results reinit_qualification_ind




Overview
Explore in AI Chat

Overview

The APPS.QP_QUALIFICATION_IND_UPG_UTIL package is an Advanced Pricing utility in Oracle E-Business Suite that supports the qualification indicator upgrade initiative. Its primary business function is to populate, refresh, and maintain the qualification indicator flag on pricing entities — principally price lists, modifiers, and qualifiers — as part of an upgrade or data migration process. Qualification indicators signal whether a given pricing object participates in qualification processing, and the integrity of this flag is critical to correct pricing evaluation at runtime.

The package is classified as a UTIL (utility) package, meaning it is not a public business API but an internal upgrade helper. It is authored with AUTHID CURRENT_USER, so it executes with the privileges of the invoking user rather than the definer, consistent with Oracle EBS standards for upgrade utilities. The header comment (QPXUQUAS.pls 120.0, dated 2005) identifies it as a non-shipped or upgrade-specific script. The package exposes five documented procedures and is not referenced by any other packages, confirming its role as a standalone upgrade driver. It provides parallel processing support so that large pricing datasets can be processed within acceptable batch windows.

Key Procedures and Functions

The package documents five procedures. Parameter names below reflect the ETRM metadata; parameter semantics are stated only where documented.

  • INITIALIZE_QUALIFICATION_IND — Initializes the qualification indicator for the target pricing records. This is the entry point users most commonly search for (initialize_qualification_ind). It accepts a batch size (default 5000) and a worker identifier, indicating it is designed to be invoked once per parallel worker over a partitioned slice of data.
  • REINIT_QUALIFICATION_IND — Reinitializes the qualification indicator, resetting previously processed records so that the upgrade can be re-run or corrected. It shares the same batch size and worker parameters as initialization.
  • SET_QUALIFICATION_IND — Sets the qualification indicator value on the identified records. It is the actual data-population step, again parameterized by batch size and worker for parallel execution.
  • CREATE_PARALLEL_SLABS — Creates parallel work slabs to divide the upgrade workload across concurrent workers. Accepts a worker count (default 5) and a type identifier (default 'QUA').
  • CREATE_PARALLEL_COUNT_SLABS — Creates parallel count slabs, a variant used to partition record-counting work. Accepts a worker count and a type identifier (default 'QIN').

The consistent p_batchsize and l_worker parameters across the first three procedures confirm that the package is intended to be driven by a multi-worker concurrent program, with slab creation preceding indicator initialization and population.

Tables Accessed

The package operates against the core Advanced Pricing data model through APPS synonyms:

  • QP_LIST_HEADERS_B — Price list and modifier headers; qualification indicators are maintained at this level.
  • QP_LIST_LINES — The line-level pricing definitions whose qualification status is derived and updated.
  • QP_PRICING_ATTRIBUTES — Attribute definitions used to evaluate qualification criteria.
  • QP_QUALIFIERS — The qualifier records that determine whether a price list line applies to a transaction.
  • QP_RLTD_MODIFIERS — Relationships between modifiers, needed to propagate qualification state across dependent objects.
  • QP_UPG_LINES_DISTRIBUTION — The upgrade distribution table that tracks how list lines are split across parallel workers, supporting the slab-based processing model.

Usage Notes

Because it is an upgrade utility rather than a public API, QP_QUALIFICATION_IND_UPG_UTIL is not exposed through standard application forms. It is typically invoked during an Advanced Pricing upgrade or patch cycle — most commonly when applying an EBS maintenance pack or migrating pricing data from an earlier release — and is driven by concurrent program infrastructure. The documented parallel design means invocation normally begins with CREATE_PARALLEL_SLABS or CREATE_PARALLEL_COUNT_SLABS to partition work, followed by INITIALIZE_QUALIFICATION_IND, REINIT_QUALIFICATION_IND, and SET_QUALIFICATION_IND executed per worker. The behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, as the package is unaffected by the Online Patching architecture. Custom code should not depend on this package, since its signature and internal logic are subject to change between releases; it is intended solely for upgrade execution and should be treated as non-public.