Search Results qp_price_formulas_b




Overview
Explore in AI Chat

Overview

The QP_PRICE_FORMULAS_B table is a core data object within the Oracle E-Business Suite Advanced Pricing (QP) module. It functions as the primary repository for pricing formula header information. A pricing formula is a configurable rule used to algorithmically calculate a price, markup, or discount based on various factors such as cost, list price, or other attributes. This table stores the fundamental definition and control attributes of each formula, enabling complex, dynamic pricing strategies beyond simple fixed-price lists. Its integrity is critical for the accurate execution of pricing logic across order management, procurement, and other transactional flows.

Key Information Stored

While the provided metadata does not list specific columns, the table's role as a header table and its primary key structure indicate its critical data elements. The primary key, PRICE_FORMULA_ID, uniquely identifies each formula record. Other columns typically found in such a header table include fields for the formula's name, a description, the formula type (e.g., price, markup, discount), the actual formula text or a reference to it, status (active/inactive), and effective date ranges. The table also contains standard Oracle EBS columns for auditing (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and for Multi-Org configuration (ORG_ID).

Common Use Cases and Queries

This table is central to pricing analysis, formula auditing, and troubleshooting. Common operational queries involve identifying formulas used by specific price list lines or diagnosing pricing calculation errors. For instance, to find all active price formulas and the price list lines that reference them, a join with QP_LIST_LINES is essential. A typical diagnostic query might be: SELECT pf.PRICE_FORMULA_ID, pf.NAME, ll.LIST_LINE_ID, ll.LIST_HEADER_ID FROM QP_PRICE_FORMULAS_B pf, QP_LIST_LINES ll WHERE pf.PRICE_FORMULA_ID = ll.PRICE_BY_FORMULA_ID AND pf.STATUS = 'ACTIVE';. Reporting use cases include generating a catalog of all pricing formulas, their types, and usage counts to support formula lifecycle management and cleanup initiatives.

Related Objects

The QP_PRICE_FORMULAS_B table has defined relationships with several key objects in the Advanced Pricing schema, as documented by its foreign key constraints:

  • QP_PRICE_FORMULAS_TL: The Translation table, joined on PRICE_FORMULA_ID, stores multilingual names and descriptions for the formulas.
  • QP_LIST_LINES: A critical relationship where QP_LIST_LINES.PRICE_BY_FORMULA_ID and QP_LIST_LINES.GENERATE_USING_FORMULA_ID reference this table, linking formulas directly to pricing rules.
  • QP_CURRENCY_DETAILS: References the table twice, via PRICE_FORMULA_ID and MARKUP_FORMULA_ID, for currency-specific pricing adjustments.
  • QP_DEBUG_FORMULA_STEP_VALUES: Joined on PRICE_FORMULA_ID, this table stores detailed runtime data for formula debugging purposes.