Search Results qp_list_headers_b




The QP_LIST_HEADERS_B table is a fundamental data structure within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically serving as the backbone for pricing functionality in the Oracle Advanced Pricing module. This table stores header-level information for price lists, modifiers, and qualifiers, which are essential for defining complex pricing rules, discounts, surcharges, and promotions in Oracle Order Management and other related modules. Below is a detailed technical breakdown of its structure, purpose, and integration within Oracle EBS.

Key Attributes of QP_LIST_HEADERS_B

  • LIST_HEADER_ID: Primary key column that uniquely identifies each price list or modifier.
  • LIST_TYPE_CODE: Specifies the type of list (e.g., PRL for Price Lists, PLL for Modifiers).
  • NAME: Descriptive name of the price list or modifier.
  • DESCRIPTION: Optional field for additional details.
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the list.
  • CURRENCY_CODE: Indicates the currency associated with the price list.
  • ACTIVE_FLAG: Boolean flag (Y/N) to enable/disable the list.
  • AUTOMATIC_FLAG: Determines whether the list is system-generated or manually created.
  • PROGRAM_ID, REQUEST_ID, and CREATED_BY: Audit columns for tracking creation and modification.

Functional Role in Oracle EBS

The QP_LIST_HEADERS_B table acts as the parent entity for pricing hierarchies. It links to child tables like QP_LIST_LINES (for line-level pricing details) and QP_QUALIFIERS (for rule-based pricing conditions). For example:

  • Price Lists: When LIST_TYPE_CODE = 'PRL', the table defines base selling prices for items, services, or categories.
  • Modifiers: When LIST_TYPE_CODE = 'PLL', it stores discounts, surcharges, or promotions applied during order entry.

Integration with Other Modules

The table integrates tightly with Oracle Order Management (OE_ORDER_HEADERS_ALL), Inventory (MTL_SYSTEM_ITEMS_B), and Accounts Receivable (RA_CUSTOMERS). Pricing engine APIs (e.g., QP_PREQ_GRP) reference this table to evaluate real-time pricing during transactions.

Technical Considerations

  • Indexes: Key indexes include QP_LIST_HEADERS_B_N1 (on LIST_HEADER_ID) and QP_LIST_HEADERS_B_U1 (unique constraint on NAME).
  • Partitioning: In high-volume environments, partitioning by LIST_TYPE_CODE or date ranges may improve performance.
  • API Usage: Customizations should leverage Oracle's Pricing APIs (QP_PRICE_REQUEST_PUB) rather than direct DML to maintain data integrity.

Common Customizations

Extensions often include:

  • Adding custom columns via AD_ZD tables for industry-specific attributes.
  • Creating triggers to synchronize price lists with external CRM systems.
  • Implementing batch jobs to expire/inactivate lists based on business rules.

Conclusion

The QP_LIST_HEADERS_B table is a critical component of Oracle Advanced Pricing, enabling flexible and scalable pricing strategies. Its design supports multi-currency, date-effective, and rule-based pricing, making it indispensable for global enterprises. Proper understanding of this table is essential for configuring, customizing, or troubleshooting pricing workflows in Oracle EBS 12.1.1 and 12.2.2.