Search Results icx_por_items




Overview
Explore in AI Chat

Overview

The ICX_POR_ITEMS table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for non-translatable, master information about items available in the procurement catalog. Each record represents a distinct catalog item, acting as the root or parent record for a suite of related data. The table's primary function is to store invariant item descriptors and key identifiers that link to other critical procurement entities, such as suppliers and categories, thereby forming the structural backbone of the iProcurement catalog system.

Key Information Stored

The table's structure is defined by a primary key, RT_ITEM_ID, and a series of descriptor columns. The most significant columns include the unique item identifier (RT_ITEM_ID), the supplier identifier (SUPPLIER_ID) which is a foreign key to HZ_PARTIES, and a set of root descriptor columns. These descriptors, named in the format Axxxx (e.g., A0001, A0002), store specific, non-translatable attributes for the catalog item. According to the documentation, a subset of these descriptors is seeded by Oracle, while others can be customized. The table does not store translated text (like item descriptions), which is instead held in the related ICX_POR_ITEMS_TL (Translation) table.

Common Use Cases and Queries

This table is central to catalog management and reporting. Common use cases include analyzing the catalog item master list, troubleshooting item setup, and generating supplier-specific item reports. A typical query might join ICX_POR_ITEMS with its translation table and supplier information to create a comprehensive item listing. For example:

  • Identifying all active items for a specific supplier: SELECT ipi.rt_item_id, ipit.display_name, hzp.party_name FROM icx_por_items ipi JOIN hz_parties hzp ON ipi.supplier_id = hzp.party_id JOIN icx_por_items_tl ipit ON ipi.rt_item_id = ipit.rt_item_id WHERE hzp.party_name = 'Supplier XYZ';
  • Investigating pricing by joining with the ICX_POR_PRICE_LIST_LINES table.
  • Validating item-category relationships via the ICX_POR_CATEGORY_ITEMS table.

Related Objects

ICX_POR_ITEMS has extensive relationships within the iProcurement schema, as indicated by its foreign key constraints. Key related objects include:

  • ICX_POR_ITEMS_TL: Stores the translatable descriptions for items referenced by RT_ITEM_ID.
  • ICX_POR_CATEGORY_ITEMS: Links catalog items to their assigned categories.
  • ICX_POR_PRICE_LIST_LINES & ICX_POR_PRICE_LIST_LINES_CACHE: Contain and cache pricing information for items.
  • HZ_PARTIES: Provides supplier master data for the SUPPLIER_ID.
  • ICX_POR_THIRD_PARTY_LOGS & MSC_SUP_DEM_ENTRIES: Used for integration logging and supply/demand planning, respectively.