Search Results qp_price_formula_lines




Overview
Explore in AI Chat

Overview

QP_PRICE_FORMULA_LINES is a table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores each individual component—or line—that makes up a price formula. In Oracle Advanced Pricing, a formula defines a multi-step calculation that determines a final price or modifier by combining list prices, other price lists, numeric constants, and pricing attributes. QP_PRICE_FORMULA_LINES holds the ordered building blocks of that calculation, one row per step.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite attached to parent entities such as QP_PRICE_FORMULAS_B, carrying the detail attributes that define each formula step rather than acting as an independent hub or a pure linking table.

Key Information Stored

The table contains 35 documented columns. The most significant are:

Common Use Cases and Queries

The table is typically queried to reconstruct or audit a formula's calculation steps, joining to its parent formula header and to price list sources. A representative query, ordered by step, is:

  • SELECT l.step_number, l.price_formula_line_type_code, l.numeric_constant, l.price_list_line_id FROM qp_price_formula_lines l WHERE l.price_formula_id = :formula_id ORDER BY l.step_number — retrieves all steps for a given formula.
  • Join QP_PRICE_FORMULA_LINES to QP_PRICE_FORMULAS_B on PRICE_FORMULA_ID to report which formulas contain a given step type.
  • Join to SO_PRICE_LIST_LINES_115 on PRICE_LIST_LINE_ID to trace which price list lines feed a formula.
  • Filter by START_DATE_ACTIVE and END_DATE_ACTIVE to identify currently effective steps.
  • Filter by SEEDED_FLAG to separate Oracle-supplied steps from custom steps.

These patterns support pricing configuration reporting, upgrade impact analysis, and troubleshooting of pricing calculation discrepancies.

Related Objects

  • QP_PRICE_FORMULAS_B — parent formula header; joined on PRICE_FORMULA_ID.
  • QP_LIST_HEADERS_B — referenced via PRICE_MODIFIER_LIST_ID for modifier lists.
  • SO_PRICE_LIST_LINES_115 — referenced via PRICE_LIST_LINE_ID for price list lines.
  • QP_PRICE_FORMULA_LINES_PK — primary key constraint on PRICE_FORMULA_LINE_ID.
  • QP_PRICE_FORMULA_LINES_U1 — unique index on (PRICE_FORMULA_ID, STEP_NUMBER, ZD_EDITION_NAME).

Applications and APIs within Oracle Advanced Pricing consume these rows through the parent formula definitions rather than directly, so most integration occurs at the formula-header level.