Search Results oks_qp_pkg




Overview
Explore in AI Chat

Overview

OKS_QP_PKG is an Oracle EBS service contracts package residing in the APPS schema. It bridges Oracle Service (OKS) contract and subscription data with Oracle Advanced Pricing (QP) structures. Its central responsibility is pricing calculation for service contract lines, coverage subscriptions, and billing schedules. The package evaluates qualifiers and price lists against the sales order, customer, and item context established in the service contract, then derives the applicable unit price for a service or subscription line. Because pricing in EBS is validated through the QP pricing engine rather than recomputed by each application, OKS_QP_PKG acts as the service-side adapter that assembles pricing attributes from contract and installed base data, calls the QP pre-request group, and persists the resulting price adjustments back onto contract lines.

The package is classified as OTHER rather than a public API; it is an internal engine invoked by service contract public and private APIs rather than documented for direct customer call. Its dependency on QP_PREQ_GRP and OKC_API confirms the architectural role: it builds qualifier and attribute structures and delegates the actual price derivation to the pricing engine.

Key Procedures and Functions

  • CALC_PRICE — The primary entry point. Drives price calculation for a service contract or subscription line by assembling pricing attributes, invoking the QP pricing engine, and returning the computed price for the line or set of lines under evaluation.
  • CALC_PRICE_PRE — Pre-processing step executed before the main pricing call. Typically prepares or validates the data context—attribute defaults, qualifier inputs, and accumulated setup—required before QP evaluation begins.
  • CALC_PRICE_POST — Post-processing step executed after pricing. Persists or propagates the calculated prices and any resulting price adjustments onto the contract line and related records.
  • DELETE_LOCKED_PRICEBREAKS — Removes locked price break records associated with a line or pricing entity, supporting repricing and renegotiation scenarios where existing price break rows must be cleared before recalculation.

Tables Accessed

Usage Notes

OKS_QP_PKG is not intended for direct invocation by end users or custom code. It is called internally by sixteen or more service modules, including OKS_BILLING_PUB, OKS_BILL_REC_PUB, OKS_QP_INT_PVT, OKS_REPRICE_PVT, OKS_SUBSCRIPTION_PVT, OKS_MASS_UPD_PVT, OKS_ATTR_DEFAULTS_PVT, OKS_AUTH_UTIL_PUB, OKS_AUTH_UTIL_PVT, OKS_AVG_SET_PUB, OKS_EXTWARPRGM_PVT, OKS_OCINT_PUB, OKS_SETUP_UTIL_PUB, OKS_USAGE_SETTLE_PUB, and OKC_COPY_CONTRACT_PVT. Pricing is therefore triggered indirectly—when a service contract line is created or updated, when a subscription is repriced, when billing records are generated, or when a contract is copied. The package itself depends on OKC_API, QP_PREQ_GRP, and the SYS.STANDARD library. The version-dependent behavior should be validated on the target release, as the internal engine is not part of the supported public API surface and can change between 12.1.1 and 12.2.2.