Search Results fte_load_charges




Overview
Explore in AI Chat

Overview

The QP_PRICING_PHASES table is a core repository within the Oracle E-Business Suite Advanced Pricing (QP) module for releases 12.1.1 and 12.2.2. It serves as the master definition table for all pricing phases configured in the system. A pricing phase represents a distinct, sequential step in the price calculation engine's processing logic. The table's primary role is to define and control the order in which different types of price adjustments, such as discounts, surcharges, or freight, are applied to a transaction line. By maintaining this structured sequence, the table ensures deterministic and consistent pricing outcomes across all sales orders, quotes, and other priced transactions.

Key Information Stored

The central column in the QP_PRICING_PHASES table is the PRICING_PHASE_ID, which serves as the unique identifier (primary key) for each phase. While the provided ETRM metadata does not list all columns, based on its function, the table typically stores descriptive and control attributes for each phase. Common columns include the phase name, a sequence number dictating the order of execution, and flags controlling the phase's active status and behavior within the pricing workflow. The PRICING_PHASE_ID is the critical foreign key referenced by numerous other pricing entities to associate specific pricing rules with a particular calculation phase.

Common Use Cases and Queries

The primary use case is to analyze or troubleshoot the sequence of price calculations. Administrators and developers query this table to understand the pricing engine's workflow or to diagnose issues where adjustments are applied in an unexpected order. A common reporting need is to list all active phases in their execution sequence. A typical query would join this table with related entities like QP_LIST_LINES to see which modifiers (e.g., discounts) are assigned to which phase.

  • Sample Query: List all pricing phases in sequence order:
    SELECT pricing_phase_id, name, sequence_num FROM qp_pricing_phases WHERE active_flag = 'Y' ORDER BY sequence_num;
  • Sample Query: Find modifiers assigned to a specific phase:
    SELECT ll.list_line_id, ll.operand FROM qp_list_lines ll WHERE ll.pricing_phase_id = <desired_phase_id>;

Related Objects

As indicated by the foreign key relationships in the ETRM, the QP_PRICING_PHASES table is a foundational parent table. Its PRICING_PHASE_ID column is referenced by key pricing sub-objects to tie their logic to a specific calculation step. The documented foreign keys are:

  • QP_LIST_LINES: Links individual price modifiers (list lines) to a pricing phase.
  • QP_EVENT_PHASES: Associates pricing phases with specific pricing events that trigger the calculation.
  • FTE_LOAD_CHARGES: References the phase for freight-related charges within the Transportation Execution module, illustrating integration with other EBS functionalities.

This structure ensures that all pricing rules are executed within the controlled, phased framework defined in the QP_PRICING_PHASES table.

  • Table: QP_PRICING_PHASES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_PHASES,  object_name:QP_PRICING_PHASES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_PHASES stores all pricing phases. ,  implementation_dba_data: QP.QP_PRICING_PHASES , 

  • Table: QP_PRICING_PHASES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_PHASES,  object_name:QP_PRICING_PHASES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_PHASES stores all pricing phases. ,  implementation_dba_data: QP.QP_PRICING_PHASES , 

  • Table: QP_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_HEADERS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • Table: QP_LIST_HEADERS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B ,