Search Results qp_formula_step_values




Overview
Explore in AI Chat

Overview

The QP_DEBUG_FORMULA_STEP_VALUES table is a diagnostic data repository within the Oracle E-Business Suite Advanced Pricing (QP) module. Its primary role is to capture granular, step-by-step calculation data during the runtime evaluation of pricing formulas. These formulas are attached to price lists and list lines to determine final prices, surcharges, or discounts. The table serves as a critical debugging and auditing tool, allowing technical consultants and pricing administrators to trace the exact sequence of operations and intermediate values generated when a complex pricing formula is executed. This visibility is essential for validating pricing logic, troubleshooting incorrect calculations, and ensuring the integrity of the pricing engine in both release 12.1.1 and 12.2.2.

Key Information Stored

The table stores a transient record of each computational step performed during formula evaluation. While the specific column list is not detailed in the provided metadata, its core function is to mirror the insertion of values into the QP_FORMULA_STEP_VALUES table. Based on its described purpose and foreign key relationships, it is inferred to contain columns such as a unique identifier for the debug session (likely a request ID), the PRICE_FORMULA_ID, LIST_HEADER_ID, and LIST_LINE_ID to pinpoint the pricing context. It would also store the step sequence number, the operation performed, the input operands, and the resulting output value for that step. This creates a chronological audit trail of the formula's execution path.

Common Use Cases and Queries

The primary use case is isolating the root cause of unexpected pricing outcomes. For instance, if a final price on a sales order appears incorrect, a developer can query this table for the specific pricing request and list line to review each calculation step. A typical diagnostic query would join to the main pricing tables to provide context. Data in this table is typically inserted by the pricing engine's debugging routines and may be purged periodically. Sample query patterns include tracing a specific price list line's formula evaluation or aggregating step data to analyze performance or logic flow across multiple pricing requests.

Related Objects

The table maintains direct foreign key relationships with several core Advanced Pricing entities, as documented. These relationships are fundamental for contextualizing the debug data within the broader pricing setup:

  • QP_PRICE_FORMULAS_B: Joined via QP_DEBUG_FORMULA_STEP_VALUES.PRICE_FORMULA_ID. This links the debug steps to the master definition of the formula itself.
  • QP_LIST_HEADERS_B: Joined via QP_DEBUG_FORMULA_STEP_VALUES.LIST_HEADER_ID. This associates the debug data with the specific price list.
  • QP_LIST_LINES: Joined via QP_DEBUG_FORMULA_STEP_VALUES.LIST_LINE_ID. This connects the step values to the individual line within a price list where the formula was applied.

As indicated by its description, the table is intrinsically linked to QP_FORMULA_STEP_VALUES, as it contains the information inserted into that table during the debugging process.

  • 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 , 

  • 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 , 

  • 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 ,