Search Results ibc_citem_versions_tl




Overview
Explore in AI Chat

Overview

The IBC_CITEM_VERSIONS_TL table is a core data object within the Oracle E-Business Suite Content Manager (IBC) module for versions 12.1.1 and 12.2.2. It functions as a translation table, storing language-specific (or "language-striped") information for content item versions. Its primary role is to support the multilingual capabilities of the application by holding the translated text for version attributes, such as titles and descriptions, while the base transactional data resides in the related IBC_CITEM_VERSIONS_B table. This design is a standard Oracle EBS pattern for enabling global deployments.

Key Information Stored

The table's structure is designed to manage translated content per language. Its primary key is a composite of CITEM_VERSION_ID and LANGUAGE, ensuring a unique record for each version and language combination. While the specific column list is not fully detailed in the provided metadata, typical translation table columns include SOURCE_LANG, along with translatable attributes like TITLE and DESCRIPTION. Critically, the table also includes foreign key relationships to FND_LOBS for ATTACHMENT_FILE_ID and ATTRIBUTE_FILE_ID, indicating it stores references to translated binary files (like documents or style sheets) associated with a content version. This links translated metadata to the actual multilingual content files.

Common Use Cases and Queries

This table is central to any process involving the display or reporting of content item versions in a user's session language. Common operational and reporting scenarios include retrieving all translations for a specific content version for administrative review, or fetching the version title in the current session language for UI display. A typical query pattern joins this table with its base table and filters on the LANGUAGE column.

  • Retrieve Translated Version Details: SELECT tl.title, tl.description FROM ibc_citem_versions_tl tl, ibc_citem_versions_b b WHERE b.citem_version_id = tl.citem_version_id AND tl.language = USERENV('LANG') AND b.citem_id = :p_citem_id;
  • Audit All Translations for a Version: SELECT language, source_lang, title FROM ibc_citem_versions_tl WHERE citem_version_id = :p_version_id ORDER BY language;

Related Objects

IBC_CITEM_VERSIONS_TL has integral relationships with several key EBS objects. Its defining relationship is with IBC_CITEM_VERSIONS_B, the base table from which it inherits the CITEM_VERSION_ID. It also has two foreign key dependencies on FND_LOBS to manage translated attachment and attribute files. Furthermore, the table is referenced by the PRP_COMP_STYLE_CTNTVERS object, suggesting its use in personalized style or component functionality within the content management framework. For programmatic access, developers typically use the standard IBC Content Manager APIs rather than direct DML on this table.