Search Results qp_qualifiers_fwk_dummy




Overview
Explore in AI Chat

Overview

QP_QUALIFIERS_FWK_DUMMY is a table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, documented with 56 columns in ETRM 12.2.2. The object's name and structure indicate that it serves as a staging or temporary holding structure for qualifier records produced by the pricing engine's qualifier framework. Qualifiers in Advanced Pricing determine whether a price list line, modifier, or promotion applies to a given transaction context, evaluating attributes such as customer, order type, item, and date. Because the table is populated by framework processing rather than maintained as a permanent transactional store, it is generally treated as a work table whose rows are consumed and replaced during pricing or qualification runs.

Data Vault classification is a modeling suggestion only. The mined FK structure shows references to QP_QUALIFIER_RULES, QP_LIST_LINES, and CSF_TDS_SEGMENTS, with a unique index on (TRANSACTION_ID, QUALIFIER_ID). This pattern is consistent with a link-style or transaction-scoped satellite structure rather than a standalone hub, since the surrogate key is framed by a transaction identifier and the business-key candidate combines transaction and qualifier.

Key Information Stored

The primary key is a composite surrogate formed by TRANSACTION_ID and QUALIFIER_ID, enforced by unique index QP_QUALIFIERS_FWK_DUMMY_U1. The most significant columns fall into several groups:

Common Use Cases and Queries

Typical diagnostic queries inspect qualifier rows for a specific transaction to understand why a price or modifier was or was not applied. Counting qualifiers per transaction verifies that the framework completed evaluation:

  • SELECT TRANSACTION_ID, COUNT(*) FROM QP.QP_QUALIFIERS_FWK_DUMMY GROUP BY TRANSACTION_ID;
  • SELECT QUALIFIER_ID, QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE, COMPARISON_OPERATOR_CODE, EXCLUDER_FLAG FROM QP.QP_QUALIFIERS_FWK_DUMMY WHERE TRANSACTION_ID = :txn_id;
  • SELECT d.TRANSACTION_ID, d.QUALIFIER_RULE_ID, r.RULE_NAME FROM QP.QP_QUALIFIERS_FWK_DUMMY d, QP.QP_QUALIFIER_RULES r WHERE d.QUALIFIER_RULE_ID = r.QUALIFIER_RULE_ID;
  • SELECT LIST_LINE_ID, QUALIFIER_PRECEDENCE FROM QP.QP_QUALIFIERS_FWK_DUMMY WHERE LIST_HEADER_ID = :list_id ORDER BY QUALIFIER_PRECEDENCE;

Reporting use cases include auditing qualifier precedence conflicts, validating range operator assignments, and reconciling imported qualifier references through the ORIG_SYS columns.

Related Objects

  • QP_QUALIFIER_RULES — joined via QP_QUALIFIERS_FWK_DUMMY.QUALIFIER_RULE_ID; governs qualification logic.
  • QP_LIST_LINES — joined via QP_QUALIFIERS_FWK_DUMMY.LIST_LINE_ID; identifies the price list line being qualified.
  • CSF_TDS_SEGMENTS — joined via QP_QUALIFIERS_FWK_DUMMY.SEGMENT_ID; supplies segment metadata for qualifier attributes.
  • QP_LIST_HEADERS — related through LIST_HEADER_ID for list-level context.
  • QP_PRICING_ATTRIBUTES — provides the attribute definitions referenced by QUALIFIER_ATTRIBUTE and QUALIFIER_CONTEXT.
  • QP_QUALIFIERS — the permanent qualifier definition table, the logical counterpart to this framework dummy.