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.
  • Table: QP_PRICE_FORMULAS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • Table: QP_PRICE_FORMULAS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • Table: QP_CURRENCY_DETAILS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_DETAILS,  object_name:QP_CURRENCY_DETAILS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.At any point of time there can be only one active record for a given to_currency_code. Thistable has atleast one record of to_currency_code = base_ ,  implementation_dba_data: QP.QP_CURRENCY_DETAILS , 

  • Table: QP_CURRENCY_DETAILS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_DETAILS,  object_name:QP_CURRENCY_DETAILS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.At any point of time there can be only one active record for a given to_currency_code. Thistable has atleast one record of to_currency_code = base_ ,  implementation_dba_data: QP.QP_CURRENCY_DETAILS , 

  • View: QP_DEBUG_FORMULA_STEP_VALUES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES_V,  object_name:QP_DEBUG_FORMULA_STEP_VALUES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_DEBUG_FORMULA_STEP_VALUES and QP_PRICE_FORMULAS_B. It contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the eva ,  implementation_dba_data: APPS.QP_DEBUG_FORMULA_STEP_VALUES_V , 

  • View: QP_DEBUG_FORMULA_STEP_VALUES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES_V,  object_name:QP_DEBUG_FORMULA_STEP_VALUES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View that joins QP_DEBUG_FORMULA_STEP_VALUES and QP_PRICE_FORMULAS_B. It contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the eva ,  implementation_dba_data: APPS.QP_DEBUG_FORMULA_STEP_VALUES_V , 

  • View: QP_PRICE_FORMULAS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FORMULAS_VL,  object_name:QP_PRICE_FORMULAS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_PRICE_FORMULAS_B and QP_PRICE_FORMULAS_TL. Displays the translated columns on pricing formulas in the local language. ,  implementation_dba_data: APPS.QP_PRICE_FORMULAS_VL , 

  • View: QP_PRICE_FORMULAS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FORMULAS_VL,  object_name:QP_PRICE_FORMULAS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_PRICE_FORMULAS_B and QP_PRICE_FORMULAS_TL. Displays the translated columns on pricing formulas in the local language. ,  implementation_dba_data: APPS.QP_PRICE_FORMULAS_VL , 

  • Table: QP_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_FORMULAS_EBS_LOG 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_FORMULAS_EBS_LOG,  object_name:QP_FORMULAS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_PRICE_FORMULAS_B table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_FORMULAS_EBS_LOG , 

  • Table: QP_FORMULAS_EBS_LOG 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_FORMULAS_EBS_LOG,  object_name:QP_FORMULAS_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_PRICE_FORMULAS_B table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_FORMULAS_EBS_LOG , 

  • Table: QP_DEBUG_FORMULA_STEP_VALUES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES,  object_name:QP_DEBUG_FORMULA_STEP_VALUES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists. ,  implementation_dba_data: QP.QP_DEBUG_FORMULA_STEP_VALUES , 

  • Table: QP_DEBUG_FORMULA_STEP_VALUES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES,  object_name:QP_DEBUG_FORMULA_STEP_VALUES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists. ,  implementation_dba_data: QP.QP_DEBUG_FORMULA_STEP_VALUES , 

  • View: QPBV_FORMULA_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_FORMULA_HEADERS,  object_name:QPBV_FORMULA_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This gives information about formula headers ,  implementation_dba_data: APPS.QPBV_FORMULA_HEADERS , 

  • View: QPBV_FORMULA_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_FORMULA_HEADERS,  object_name:QPBV_FORMULA_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This gives information about formula headers ,  implementation_dba_data: APPS.QPBV_FORMULA_HEADERS , 

  • Table: QP_PRICE_FORMULAS_TL 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_TL,  object_name:QP_PRICE_FORMULAS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_TL , 

  • Table: QP_PRICE_FORMULAS_TL 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_TL,  object_name:QP_PRICE_FORMULAS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_TL , 

  • View: QP_PRICE_FACTORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V , 

  • View: QP_PRICE_FACTORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V ,