Search Results price




The ICX.ICX_POR_PRICE_LIST_LINES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the iProcurement module, specifically supporting the Price Lists functionality. This table stores detailed pricing information for items available for procurement, enabling organizations to maintain standardized pricing across purchasing transactions. Below is a detailed technical and functional breakdown of this table in the context of Oracle EBS.

Functional Overview

The ICX_POR_PRICE_LIST_LINES table serves as a repository for item pricing data tied to price lists defined in the Oracle Purchasing module. It integrates with Oracle iProcurement to ensure that requisitioners view accurate, up-to-date prices when selecting items. This table supports:
  • Price List Management: Stores item-level pricing details, including base price, discounts, and effective dates.
  • Multi-Currency Support: Captures currency-specific pricing for global procurement operations.
  • Catalog Integration: Links to catalog items (via INVENTORY_ITEM_ID and CATEGORY_ID), enabling dynamic price displays in punchout or hosted catalogs.

Key Columns and Relationships

The table's structure includes columns that establish relationships with other EBS modules and enforce pricing rules:
  • PRICE_LIST_LINE_ID: Primary key, uniquely identifying each price list entry.
  • PRICE_LIST_ID: Foreign key linking to ICX_POR_PRICE_LISTS, associating lines with a parent price list.
  • INVENTORY_ITEM_ID: References MTL_SYSTEM_ITEMS_B to tie prices to specific inventory items.
  • CATEGORY_ID: Optional link to MTL_CATEGORIES_B for category-based pricing.
  • UOM_CODE: Unit of measure (e.g., EA, KG) for the priced item.
  • UNIT_PRICE: The base price per unit, critical for cost calculations.
  • CURRENCY_CODE: Currency of the price (e.g., USD, EUR), tied to FND_CURRENCIES.
  • START_DATE_ACTIVE/END_DATE_ACTIVE: Defines the price validity period.

Integration Points

ICX_POR_PRICE_LIST_LINES interacts with several EBS modules:
  • Oracle Purchasing: Price lists originate in Purchasing (PO_PRICE_LIST_LINES) and are replicated to iProcurement for requisitioning.
  • Inventory: Item and category references ensure alignment with master data.
  • General Ledger: Currency data syncs with GL for financial reporting.

Technical Considerations

  • Indexing: Key columns like PRICE_LIST_LINE_ID, PRICE_LIST_ID, and INVENTORY_ITEM_ID are typically indexed for performance.
  • Data Volume: Large organizations may have millions of rows, necessitating partitioning strategies.
  • Concurrency: Price updates during active procurement periods require row-level locking to prevent conflicts.

Customization and Extensions

Common extensions include:
  • Custom Pricing Logic: Triggers or APIs may modify prices based on business rules (e.g., volume discounts).
  • Reporting: Views or materialized snapshots for historical price analysis.

Conclusion

The ICX.ICX_POR_PRICE_LIST_LINES table is a cornerstone of Oracle iProcurement’s pricing framework, ensuring accurate, auditable, and scalable price management. Its integration with Purchasing, Inventory, and Financial modules underscores its role in end-to-end procurement processes. Administrators should prioritize indexing, data purging policies, and validation rules to maintain performance and data integrity.