Search Results items price lis




The ICX_POR_PRICE_LISTS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the iProcurement module, specifically supporting the Purchasing (PO) and iSupplier Portal functionalities. This table stores pricing information for items, enabling organizations to manage supplier catalogs, negotiated contracts, and price lists efficiently. Below is a detailed technical and functional analysis of this table.

Table Overview

The ICX_POR_PRICE_LISTS table acts as a repository for price list data, linking items, suppliers, and contractual agreements. It is part of the Oracle iProcurement framework, facilitating self-service procurement by allowing users to view approved item prices during requisition creation. The table integrates with core modules like Purchasing (PO), Inventory (INV), and Supplier Portal (ICX), ensuring consistency in pricing across procurement workflows.

Key Columns and Structure

The table's schema includes columns critical for price management:

  • PRICE_LIST_ID: Primary key, uniquely identifying each price list.
  • PRICE_LIST_NAME: Descriptive name for the price list.
  • ITEM_ID: References MTL_SYSTEM_ITEMS_B to associate items with prices.
  • SUPPLIER_ID: Links to AP_SUPPLIERS, tying prices to specific suppliers.
  • CURRENCY_CODE: Defines the currency for the price (e.g., USD, EUR).
  • UNIT_PRICE: The base price per unit of the item.
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the price.
  • CATALOG_ID: Associates the price with a supplier catalog (ICX_POR_CATALOGS).

Functional Integration

The table supports several procurement processes:

  • Requisition Creation: Users select items from catalogs, with prices pulled from ICX_POR_PRICE_LISTS.
  • Contract Compliance: Ensures purchases adhere to negotiated supplier contracts.
  • Supplier Collaboration: Suppliers update prices via the iSupplier Portal, which propagates to this table.

Technical Dependencies

The table interacts with other EBS components:

  • PO_HEADERS_ALL and PO_LINES_ALL: Purchase orders reference price lists for validation.
  • MTL_SYSTEM_ITEMS_B: Item master data ensures accurate price-to-item mapping.
  • AP_SUPPLIERS: Supplier details are validated during price list maintenance.

Customization and Extensions

Organizations often extend the table's functionality via:

  • API Hooks: Custom PL/SQL scripts to enforce complex pricing rules.
  • Workflow Notifications: Alerts for price changes or expirations.
  • Data Integrations: ERP-to-SRM price synchronization.

Performance Considerations

For optimal performance:

  • Indexes on ITEM_ID, SUPPLIER_ID, and CATALOG_ID are recommended.
  • Partitioning by END_DATE_ACTIVE improves query efficiency for active price lists.
  • Caching frequently accessed price lists reduces database load.

Conclusion

The ICX_POR_PRICE_LISTS table is a cornerstone of Oracle EBS procurement, enabling dynamic pricing, supplier collaboration, and contract adherence. Its integration with core modules and extensibility make it vital for organizations leveraging Oracle iProcurement. Proper configuration and indexing are essential to maintain performance in high-volume environments.