Search Results qp_util




Overview
Explore in AI Chat

Overview

QP_UTIL is a foundational utility package in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. The package body, owned by the APPS schema and holding VALID status in both release 12.1.1 and 12.2.2, provides a broad set of helper routines that the pricing engine, pricing setup forms, and related pricing APIs rely upon. Its classification as a UTIL package indicates that it does not represent an externally callable business API in its own right; rather, it supplies shared low-level services such as flexfield validation, context resolution, attribute classification, and schema lookup that other pricing components invoke internally.

The breadth of QP_UTIL's dependency graph reflects its central role. It references Oracle Application Object Library components such as FND_API, FND_MESSAGE, FND_PROFILE, FND_GLOBAL, and FND_FLEX_DSC_API, as well as descriptive flexfield dictionary views and value set definitions. It also depends on pricing tables, multi-org and inventory utilities, and other pricing utilities including QP_AM_UTIL, QP_NUMBER, and QP_MASS_MAINTAIN_UTIL. The ETRM metadata records that QP_UTIL is referenced by 111 other database objects, none of which QP_UTIL itself depends upon, confirming its position as a shared leaf-level utility within the pricing stack.

Key Procedures and Functions

The documented package exposes 52 procedures and functions. The principal routines group into several functional areas:

These routines collectively allow pricing setup and runtime code to interpret the descriptive flexfield structures that underpin pricing attributes, contexts, and qualifiers without duplicating dictionary queries.

Tables Accessed

QP_UTIL reads and writes a defined set of pricing and application dictionary tables through APPS synonyms. Context and flexfield metadata are read from FND_DESCR_FLEX_CONTEXTS, FND_DESCR_FLEX_COLUMN_USAGES, FND_FLEX_VALUE_SETS, AK_OBJECT_ATTRIBUTES_TL, and OE_AK_OBJ_ATTR_EXT. Pricing list and structure data are drawn from QP_LIST_HEADERS_B, QP_LIST_LINES, QP_CURRENCY_DETAILS, QP_LIMITS, QP_LIMIT_ATTRIBUTES, QP_PRC_CONTEXTS_B, and QP_PRC_CONTEXTS_TL. Environment and user information are obtained from FND_APPLICATION, FND_USER, and MTL_SYSTEM_ITEMS_B. The package also references FND_DESCR_FLEX_COL_USAGE_VL and FND_FLEX_VALUE_SETS to resolve value set and column usage information.

Usage Notes

QP_UTIL is not intended to be invoked directly by end users or by external integrations as a business API. It is called internally by pricing forms, concurrent programs, the pricing engine, and other pricing APIs across the extensive set of 111 dependent packages. Customers and partners writing custom pricing extensions may invoke its validation and context-resolution routines when building custom pricing attribute logic, but such use should be treated as unsupported and re-verified following any patch or upgrade, since the package body is subject to change between 12.1.1 and 12.2.2. Because the routines rely on FND_GLOBAL and FND_PROFILE, correct application and organization context must be initialized before invocation.