Search Results icx_por_price_lists




Overview
Explore in AI Chat

Overview

The ICX_POR_PRICE_LISTS table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the master repository for price list header information, serving as a critical component for the procurement and sourcing processes. As documented, its primary purpose is to store price list information, with a foundational rule of one price list per buyer and supplier combination. This table enables organizations to manage negotiated supplier pricing for specific internal buyers, which is essential for enforcing contract compliance and streamlining the requisitioning process within iProcurement.

Key Information Stored

The table's structure centers on a unique header identifier (HEADER_ID), which serves as the primary key. The most significant columns define the relationship and context of the price list. The BUYER_ID and SUPPLIER_ID are foreign keys to the HZ_PARTIES table, identifying the internal buyer and the external supplier party involved in the pricing agreement. The CURRENCY_CODE column, a foreign key to FND_CURRENCIES, specifies the transactional currency for the price list. Other typical columns in such a header table, implied by its function, would include effective dates (START_DATE_ACTIVE, END_DATE_ACTIVE), a name or description for the list, and status fields to control its usability within the application.

Common Use Cases and Queries

This table is central to operations where iProcurement validates line-level pricing during requisition creation. A common reporting use case is to audit active price list agreements by buyer or supplier. For example, to list all price lists for a specific supplier, one might use a query such as:

  • SELECT header_id, buyer_id, currency_code FROM icx_por_price_lists WHERE supplier_id = &supplier_party_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Technical consultants often query this table to troubleshoot missing pricing on requisitions, verifying that a valid and active header exists for the given buyer-supplier pairing before investigating the corresponding line details in related tables like ICX_POR_PRICE_LIST_LINES.

Related Objects

As per the provided metadata, ICX_POR_PRICE_LISTS has several key dependencies. It is the parent table for line-level data in ICX_POR_PRICE_LIST_LINES and the caching table ICX_POR_PRICE_LIST_LINES_CACHE, both linked via HEADER_ID. The table ICX_POR_BUYER_APPROVAL_JOBS references it for approval routing tied to specific price lists. For audit or integration purposes, ICX_POR_THIRD_PARTY_LOGS may log actions against a PRICE_LIST_ID. Crucially, it relies on foundational EBS tables for its key entities: HZ_PARTIES for trading partner details and FND_CURRENCIES for valid currency definition.