Search Results icx_por_items_tl_pk




Overview
Explore in AI Chat

Overview

The ICX_POR_ITEMS_TL table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual text for items within the procurement catalog. Its primary role is to support global deployments by enabling the storage of item descriptions, names, and other descriptive attributes in multiple languages. The table maintains a one-to-many relationship with its base table, ICX_POR_ITEMS, ensuring that a single catalog item can have corresponding textual data for each supported language code. This design is fundamental to providing localized user experiences in the iProcurement self-service interface.

Key Information Stored

The table's structure is defined by a composite primary key consisting of RT_ITEM_ID and LANGUAGE, linking each record to a specific catalog item and language. The core data comprises translatable "root descriptors," which are dynamic attribute columns named in the format Axxxx (e.g., A0001, A0002). These columns hold the actual translated text for item characteristics. While the specific meaning of each Axxxx column is determined by the catalog's configuration, they typically store data such as the item description, long description, supplier part number, or manufacturer name. The LANGUAGE column stores the standard Oracle language code (e.g., 'US', 'FR', 'DE'). The table does not store transactional or pricing data; its exclusive purpose is the management of multilingual item descriptors.

Common Use Cases and Queries

The primary use case is generating localized catalog content for iProcurement users based on their session language. It is also critical for data migration and reporting on multilingual catalog items. A common query retrieves all translations for a specific item to verify content completeness. For example: SELECT LANGUAGE, A0001, A0002 FROM ICX_POR_ITEMS_TL WHERE RT_ITEM_ID = :item_id ORDER BY LANGUAGE;. Another typical pattern joins this table to its base table to produce a report of items with their primary and translated descriptions: SELECT b.SEGMENT1, t.LANGUAGE, t.A0001 FROM ICX_POR_ITEMS b, ICX_POR_ITEMS_TL t WHERE b.RT_ITEM_ID = t.RT_ITEM_ID AND b.ORG_ID = :org_id;. Administrators may also query for items missing translations in a key language.

Related Objects

ICX_POR_ITEMS_TL has defined foreign key relationships with two primary tables, as per the provided metadata:

  • ICX_POR_ITEMS: This is the base table for catalog items. The foreign key from ICX_POR_ITEMS_TL.RT_ITEM_ID references ICX_POR_ITEMS.RT_ITEM_ID. This is the principal relationship for retrieving an item's core, non-translatable data.
  • ICX_POR_CTX_TL: This table stores translatable catalog category information. It references ICX_POR_ITEMS_TL via the columns RT_ITEM_ID and LANGUAGE, establishing a relationship between item translations and their associated category context translations.
The table's primary key constraint is named ICX_POR_ITEMS_TL_PK.