Results for “qual_attr_value_to_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• Qualifier definition: QUALIFIER_GROUPING_NO, QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE, QUALIFIER_ATTR_VALUE_TO, QUALIFIER_DATATYPE, and COMPARISON_OPERATOR_CODE define what is being qualified and how the comparison is evaluated.
• Rule and precedence: QUALIFIER_RULE_ID links qualifying logic to QP_QUALIFIER_RULES; CREATED_FROM_RULE_ID tracks derivation; QUALIFIER_PRECEDENCE orders competing qualifiers.
• Pricing context: LIST_HEADER_ID and LIST_LINE_ID anchor the qualifier to a price list and line; LIST_TYPE_CODE identifies the list category.
• Validity: START_DATE_ACTIVE and END_DATE_ACTIVE bound the active window; ACTIVE_FLAG, EXCLUDER_FLAG, and SEARCH_IND control evaluation behavior.
• Numeric ranges: QUAL_ATTR_VALUE_FROM_NUMBER and QUAL_ATTR_VALUE_TO_NUMBER support numeric range qualification.
• Hierarchy and grouping: QUALIFY_HIER_DESCENDENTS_FLAG, QUALIFIER_GROUP_CNT, HEADER_QUALS_EXIST_FLAG, DISTINCT_ROW_COUNT, and OTHERS_GROUP_CNT support hierarchical and grouped qualification.
• External references: ORIG_SYS_QUALIFIER_REF, ORIG_SYS_HEADER_REF, and ORIG_SYS_LINE_REF carry source-system identifiers for imported qualifiers.
• Who columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY provide standard auditing.

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.