Results for “qp_pricing_phases”

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

Overview

QP_PRICING_PHASES is a foundational reference table in the Oracle Advanced Pricing (QP) module, owned by the QP schema. It stores the master definition of every pricing phase recognized by the pricing engine, such as List, Line, Volume, and Total phases. Each phase represents a discrete stage at which the pricing engine evaluates modifiers, qualifiers, and list lines during pricing and order capture. Because the table acts as the authoritative catalog of phase definitions, almost every pricing-related transaction, interface, and archive table references it through the PRICING_PHASE_ID column.

The table is present and valid in both Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 the documented physical schema exposes 39 columns, with edition-aware unique constraints. From a Data Vault modeling perspective, the mined relationship structure is heuristic and hub-leaning: QP_PRICING_PHASES functions as a central hub of pricing phase identities, with numerous dependent and transactional tables acting as links and satellites that reference it. This classification is a modeling suggestion rather than an enforced EBS construct.

Key Information Stored

The table centers on a surrogate primary key and a small set of descriptive and control attributes. The most significant columns are:

• PRICING_PHASE_ID — the surrogate primary key (QP_PRICING_PHASES_PK) and the value propagated into virtually all referencing tables.
• NAME — the user-facing phase name; combined with ZD_EDITION_NAME it forms unique index QP_PRICING_PHASES_U2, making it a business-key candidate.
• PHASE_SEQUENCE — governs the order in which phases are evaluated by the pricing engine.
• MODIFIER_LEVEL_CODE — indicates the level at which modifiers apply within the phase.
• LIST_TYPE_CODE and LIST_LINE_TYPE_CODE — constrain the phase to applicable list and list-line types.
• INCOMPAT_RESOLVE_CODE and USER_INCOMPAT_RESOLVE_CODE — define how incompatible modifiers are resolved.
• FREEZE_OVERRIDE_FLAG and USER_FREEZE_OVERRIDE_FLAG — control whether users may override frozen pricing outcomes.
• SEEDED_FLAG and MANUAL_MODIFIER_FLAG — indicate Oracle-seeded phases versus manually maintained modifiers.
• LINE_GROUP_EXISTS, OID_EXISTS, RLTD_EXISTS, and FREIGHT_EXISTS — existence flags for line groups, OID, related, and freight constructs.
• PATTERN_SEARCH_PATH — supports pattern-based search behavior within the phase.
• ZD_EDITION_NAME — the editioning column used in both unique indexes for 12.2.2 edition support.
• Standard audit and descriptive columns including CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, CONTEXT, and ATTRIBUTE1 through ATTRIBUTE15.

The unique indexes QP_PRICING_PHASES_U1 (PRICING_PHASE_ID, ZD_EDITION_NAME) and QP_PRICING_PHASES_U2 (NAME, ZD_EDITION_NAME) establish the surrogate and business-key candidates respectively.

Common Use Cases and Queries

Typical uses include resolving the phase sequence for pricing engine execution, reporting on which phases are active, and joining phase names to transactional pricing records. A common query retrieves ordered phases:

• SELECT PRICING_PHASE_ID, NAME, PHASE_SEQUENCE, MODIFIER_LEVEL_CODE FROM QP.QP_PRICING_PHASES ORDER BY PHASE_SEQUENCE;
• Joining to pricing attributes: SELECT p.NAME, a.* FROM QP.QP_PRICING_PHASES p, QP.QP_PRICING_ATTRIBUTES a WHERE a.PRICING_PHASE_ID = p.PRICING_PHASE_ID;
• Reporting price adjustments by phase: SELECT p.NAME, COUNT(*) FROM OE.OE_PRICE_ADJUSTMENTS e, QP.QP_PRICING_PHASES p WHERE e.PRICING_PHASE_ID = p.PRICING_PHASE_ID GROUP BY p.NAME;

These patterns support troubleshooting pricing behavior, auditing modifier application, and building phase-level analytics.

Related Objects

Numerous tables reference this hub via PRICING_PHASE_ID. The most significant include:

• QP_LIST_LINES — associates list lines with a pricing phase.
• QP_EVENT_PHASES — links pricing events to phases.
• QP_PRICING_ATTRIBUTES — pricing attributes scoped to a phase.
• QP_LIST_HEADER_PHASES and QP_PATTERN_PHASES — header and pattern phase assignments.
• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJS_HISTORY — order capture adjustments by phase.
• ASO_PRICE_ADJUSTMENTS — quoting adjustments.
• OKC_PRICE_ADJUSTMENTS and OKC_PRICE_ADJUSTMENTS_H — contract pricing adjustments.
• FTE_LOAD_CHARGES — freight and load charges tied to phases.
• QP_INTERFACE_LIST_LINES and OE_PRICE_ADJS_IFACE_ALL — interface staging tables.
• QP_ARCH_LIST_LINES and QP_ARCH_PRICING_ATTRIBUTES — archive counterparts.

All of these join to QP_PRICING_PHASES on the PRICING_PHASE_ID column, reinforcing its hub role in the Advanced Pricing data model.