Search Results item




The ICX.ICX_CAT_EXT_ITEMS_TLP table is a critical component within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed to support the iProcurement and iSupplier Portal modules. This table stores translated item descriptions and attributes for externally sourced catalog items, enabling multilingual support in procurement processes. Below is a detailed technical breakdown of its purpose, structure, and integration within Oracle EBS.

1. Purpose and Functional Context

The ICX_CAT_EXT_ITEMS_TLP table is part of the Oracle Internet Procurement Catalog (ICX) schema. It serves as a translation layer for externally managed catalog items (e.g., punchout items, hosted catalog items) in Oracle iProcurement. When suppliers provide items in multiple languages, this table stores the translated metadata (e.g., item descriptions, UOM, supplier details) to ensure consistency across global procurement operations. It complements the base table ICX_CAT_EXT_ITEMS_B, which stores non-translatable attributes.

2. Key Columns and Data Structure

The table’s structure includes columns to map translations to the base catalog data:
  • EXT_ITEM_ID: Foreign key linking to ICX_CAT_EXT_ITEMS_B.EXT_ITEM_ID.
  • LANGUAGE: Stores the language code (e.g., 'EN', 'FR') for the translation.
  • SOURCE_LANG: Indicates the original language of the record.
  • ITEM_DESCRIPTION: Translated description of the catalog item.
  • CATEGORY_NAME: Translated category name for classification.
  • UOM: Unit of measure in the specified language.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY: Audit columns for tracking changes.
The table follows Oracle’s Multi-Language Support (MLS) architecture, leveraging the TL (Translation) suffix convention.

3. Integration with Oracle EBS Modules

ICX_CAT_EXT_ITEMS_TLP integrates with:
  • iProcurement: Displays translated item details during requisition creation.
  • iSupplier Portal: Allows suppliers to maintain multilingual item data.
  • Punchout Catalogs: Syncs translated attributes from supplier systems (e.g., cXML).
Data is populated via:
  • Automated punchout transactions.
  • Manual imports using Oracle Procurement Catalog Administration.
  • APIs like ICX_CATALOG_PUB for programmatic updates.

4. Technical Considerations

  • Indexing: Typically indexed on EXT_ITEM_ID and LANGUAGE for performance.
  • Partitioning: In large deployments, partitioning by language may optimize queries.
  • Data Volume: Grows linearly with the number of languages and external items.

5. Customization and Extensions

While Oracle discourages direct DML on this table, extensions can be achieved via:
  • Custom APIs to add/update translations.
  • Triggers to enforce data integrity.
  • Views joining with ICX_CAT_EXT_ITEMS_B for reporting.

6. Upgrade and Patch Impact

In EBS 12.2.2, the table remains backward-compatible with 12.1.1. However, patches (e.g., Procurement Family Pack) may introduce new columns or constraints. Testing is recommended after upgrades.

Conclusion

The ICX.ICX_CAT_EXT_ITEMS_TLP table is a foundational element for global procurement in Oracle EBS, ensuring seamless multilingual support for external catalog items. Its design aligns with Oracle’s MLS standards, and proper utilization enhances user experience in international deployments.