Search Results qp_interface_qualifiers

Overview

QP_INTERFACE_QUALIFIERS is a staging interface table in the Oracle Advanced Pricing (QP) module. It functions as the inbound conduit through which external sources load qualifier attribute information for pricing entities before that data is validated and merged into the base pricing qualifier tables. Qualifier attributes define the conditions under which a price list line, modifier, or promotion applies; for example, customer class, order type, or item category. Because the interface table carries a full set of process-control and status columns, it is designed to be consumed by the Advanced Pricing interface concurrent programs (such as the pricing interface loader and the qualifier validation/import processes) rather than queried directly by end users.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as standalone. This reflects a staging or transient structure rather than a persistent enterprise hub, link, or satellite. A practitioner designing a reporting conformed model should treat QP_INTERFACE_QUALIFIERS as a source-mapped staging entity; its durable business facts should ultimately resolve into the base QP qualifier and qualifier rule tables wherever those are populated after processing.

Key Information Stored

The table contains 67 columns. The most operationally significant are those that identify the qualifier, its target pricing entity, and its processing state.

• QUALIFIER_ID — surrogate identifier for the qualifier record; the primary key of the staging row.
• QUALIFIER_CONTEXT / QUALIFIER_ATTRIBUTE / QUALIFIER_ATTR_VALUE / QUALIFIER_ATTR_VALUE_TO — the core qualifying condition: the context (for example, a customer or item level), the attribute being tested, and its value or value range.
• QUALIFIER_DATATYPE / COMPARISON_OPERATOR_CODE / QUALIFIER_PRECEDENCE — data type, operator (=, BETWEEN, and so on), and precedence for evaluation.
• LIST_HEADER_ID, LIST_LINE_ID, LIST_LINE_NO — the price list header and line to which the qualifier attaches; LIST_LINE_ID carries a foreign key to QP_LIST_LINES.
• QUALIFIER_RULE_ID, CREATED_FROM_RULE_ID, QUALIFIER_RULE — the qualifier rule context; QUALIFIER_RULE_ID references QP_QUALIFIER_RULES.
• START_DATE_ACTIVE / END_DATE_ACTIVE / ACTIVE_FLAG — effective dating and enablement.
• PROCESS_ID / PROCESS_TYPE / PROCESS_STATUS_FLAG / PROCESS_FLAG / LOCK_FLAG / INTERFACE_ACTION_CODE / DELETE_FLAG — the interface orchestration columns that drive loading, locking, and insert/update/delete semantics.
• ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_QUALIFIER_REF — source-system cross references used for reconciliation.
• ATTRIBUTE1–ATTRIBUTE15 — the standard EBS DFF/descriptive flexfield segment set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — the mandatory WHO/concurrent audit columns.

The documented foreign keys point from LIST_LINE_ID to QP_LIST_LINES and from QUALIFIER_RULE_ID to QP_QUALIFIER_RULES. QUALIFIER_ID is the natural surrogate primary key candidate for staging logic; business-key uniqueness should be confirmed against the interface program's expectations rather than assumed.

Common Use Cases and Queries

Typical uses include verifying that a batch of inbound qualifiers loaded successfully before the import program runs, and diagnosing rows that remain unprocessed.

• Pending rows by process: SELECT QUALIFIER_ID, LIST_HEADER_ID, LIST_LINE_ID, QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE FROM QP_INTERFACE_QUALIFIERS WHERE PROCESS_STATUS_FLAG <> 'Y' ORDER BY QUALIFIER_ID;
• Qualifiers for a given list line: filter by LIST_LINE_ID and QUALIFIER_CONTEXT to review conditions applied to a specific price list line.
• Source reconciliation: group by ORIG_SYS_HEADER_REF and ORIG_SYS_LINE_REF to confirm the external system's expected counts match the staged rows.
• Stuck/locked rows: query LOCK_FLAG, PROCESS_FLAG, and PROCESS_ID to identify rows held by a failed concurrent request.
• Data quality review: compare QUALIFIER_DATATYPE, QUALIFIER_ATTR_VALUE, and QUALIFIER_ATTR_VALUE_TO to detect invalid ranges or mismatched operators.

Related Objects

• QP_LIST_LINES — the parent price list line; join on QP_INTERFACE_QUALIFIERS.LIST_LINE_ID = QP_LIST_LINES.LIST_LINE_ID (documented FK).
• QP_QUALIFIER_RULES — the qualifier rule definition; join on QUALIFIER_RULE_ID (documented FK).
• QP_QUALIFIERS — the base (non-interface) qualifier table that receives validated rows.
• QP_LIST_HEADERS_TL / QP_LIST_HEADERS_B — price list header context, reached via LIST_HEADER_ID.
• QP_QUALIFIER_ATTRIBUTES — defines valid qualifier context/attribute combinations.
• QP_INTERFACE_LIST_HEADERS and QP_INTERFACE_LIST_LINES — sibling interface tables loaded in the same batch.
• Advanced Pricing interface concurrent programs — consume and clear rows based on the PROCESS_* and INTERFACE_ACTION_CODE columns.