Results for “title_id”

4 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ICX_POR_TITLE_ADMIN_TL is a translation (TL) table within the ICX schema, owned by the Oracle iProcurement product module. It stores the display titles and descriptive attributes associated with supplier catalogs that are administered through iProcurement. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, this object supports the multi-language catalog presentation layer, allowing each catalog title and description to exist in one or more installed languages.

The table is the translated child of the base title administration entity. The _TL suffix signals that rows in this table are keyed in part by LANGUAGE, and that a companion base table holds language-independent columns. From a heuristic Data Vault modeling perspective, the metadata classifies ICX_POR_TITLE_ADMIN_TL as standalone, with no mined foreign key relationships to other entities. This suggests treating it as a self-contained satellite-like structure whose natural parent linkage is expressed through the composite key rather than an enforced FK constraint.

Key Information Stored

The documented physical schema contains 17 columns. The most operationally significant are listed below.

  • TITLE_ID — Surrogate identifier for the catalog title. Forms part of the composite primary key and is the column most frequently referenced in application queries and joins.
  • LANGUAGE — Installed language code for the translated row. Combined with TITLE_ID, it forms the composite primary key ICX_POR_TITLE_ADMIN_TL_PK.
  • SOURCE_LANG — Language from which the translation was derived, supporting the standard Oracle MLS translation model.
  • TITLE — The translated display name of the supplier catalog presented to users.
  • DESCRIPTION — Translated descriptive text for the catalog.
  • SOURCE — Indicates the origin or source system of the catalog title record.
  • DOMAIN — Categorization or domain grouping for the title, used for filtering and segmentation.
  • TYPE — Classifies the title or catalog record type.
  • PICTURE and IMAGE — Hold image references or binary content associated with the catalog presentation.
  • CREATIONDATE and UPDATEDATE — Legacy application-level timestamps for record creation and modification.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle WHO columns capturing audit and accountability information.

The composite primary key (TITLE_ID, LANGUAGE) is the only documented unique constraint; no additional unique indexes or business-key candidates are recorded in the metadata. The surrogate key is therefore TITLE_ID, while LANGUAGE differentiates the translated variants of the same title.

Common Use Cases and Queries

Typical usage centers on resolving catalog names for a user's session language and reporting on catalog inventory. A common pattern filters by language to return a single translated row per title:

  • Catalog lookup by ID: SELECT title, description FROM icx.icx_por_title_admin_tl WHERE title_id = :p_title_id AND language = USERENV('LANG');
  • Multi-language reporting: aggregate titles across languages to verify translation coverage, joining to the base title table to detect missing translations.
  • Catalog administration screens: the iProcurement catalog administration UI reads and writes here when maintainers edit titles and descriptions.
  • Audit reporting: queries on LAST_UPDATE_DATE and LAST_UPDATED_BY identify recent changes to catalog titles.

Because the table has no mined FK relationships, joins must be constructed on the shared TITLE_ID column against the base title table and dependent catalog objects.

Related Objects

The metadata documents no foreign keys, so relationships are inferred from the TITLE_ID and LANGUAGE key columns.

  • ICX_POR_TITLE_ADMIN_B (or the corresponding base title table) — holds language-independent title attributes; joined on TITLE_ID.
  • ICX_POR_TITLE_ADMIN_TL companion rows — self-join on TITLE_ID across different LANGUAGE values for translation comparison.
  • FND_LANGUAGES — validates the LANGUAGE and SOURCE_LANG values.
  • ICX_POR_CATALOGS and related catalog staging tables — consume title metadata for storefront display.
  • FND_USER — resolves CREATED_BY and LAST_UPDATED_BY to application user names.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — contextual references confirming ICX module installation.

These objects are the primary consumers and validators for title administration data in iProcurement.