Search Results csd_bulletins_tl




Overview
Explore in AI Chat

Overview

CSD_BULLETINS_TL is the translation (MLS) table for service bulletins in the CSD – Depot Repair module of Oracle E-Business Suite. Service bulletins are the vehicle by which organizations publish repair instructions, quality alerts, recall notifications, and field-fix guidance associated with depot repair work. Because bulletin text must be presented to users and printed on repair documentation in their own language, the base table CSD_BULLETINS stores language-independent attributes while CSD_BULLETINS_TL stores the translated, language-dependent descriptive content.

In Oracle EBS Release 12.1.1 and 12.2.2 the table resides in the CSD schema and is reported as VALID in the ETRM repository, with a documented physical schema of ten columns. From a Data Vault modeling perspective, the metadata's heuristic classification is standalone because the mined foreign-key structure exposes no outward dependencies. Conceptually, however, a translation table of this shape is best modeled as a satellite: its key combines the parent entity identifier with LANGUAGE, and its payload consists of descriptive, time-stamped, auditable attributes. It should therefore be treated as a language-specific satellite attached to the bulletin hub, not as an independent business entity.

Key Information Stored

The documented primary key is CSD_BULLETINS_TL_PK1, composed of BULLETIN_ID and LANGUAGE. A single unique index, CSD_BULLETINS_TL_U1, exists on the same column pair, which is expected: in EBS MLS tables the primary key and the language uniqueness constraint generally coincide. This means the true business-key candidate for the translation row is the combination of the parent bulletin identifier plus the language code, while the surrogate identity of the parent entity itself is BULLETIN_ID.

The ten documented columns are BULLETIN_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG. The substantive payload columns are:

  • NAME – the translated bulletin title or short name displayed in inquiry and selection lists.
  • DESCRIPTION – the translated long text of the bulletin, containing the actual repair or service instruction.
  • LANGUAGE – the language of the translated row; part of the primary key.
  • SOURCE_LANG – the language in which the row was originally authored, used by the MLS layer to determine whether a translation is still current.
  • BULLETIN_ID – the foreign key to the base bulletin record; part of the primary key.

The remaining columns form the standard EBS WHO audit set: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These support auditing and are also used by MLS maintenance programs and concurrent translation processes to detect stale or missing translations.

Common Use Cases and Queries

Typical usage is language-aware retrieval of bulletin content for depot repair work orders, printed repair packets, and quality reporting. The conventional MLS join pattern is:

  • SELECT b.bulletin_id, t.name, t.description FROM csd_bulletins b, csd_bulletins_tl t WHERE b.bulletin_id = t.bulletin_id AND t.language = USERENV('LANG') AND t.source_lang = USERENV('LANG'); – returns rows for which a true translation exists in the session language.
  • SELECT t.language, t.name FROM csd_bulletins_tl t WHERE t.bulletin_id = :bulletin_id; – enumerates all available translations for a single bulletin.
  • SELECT t.bulletin_id, t.language FROM csd_bulletins_tl t WHERE t.language <> t.source_lang AND t.last_update_date > SYSDATE - 30; – reports recent translation activity, useful when auditing the completeness of multilingual content.
  • SELECT t.bulletin_id, t.language FROM csd_bulletins_tl t, csd_bulletins b WHERE t.bulletin_id = b.bulletin_id AND NOT EXISTS (SELECT 1 FROM csd_bulletins_tl x WHERE x.bulletin_id = t.bulletin_id AND x.source_lang = x.language); – identifies bulletins lacking a base-language row.

Reporting use cases include multilingual bulletin catalogs, translation-coverage dashboards, and joining bulletin text to depot repair order lines and repair history.

Related Objects

  • CSD_BULLETINS – the base, non-translated bulletin table; joined on BULLETIN_ID and the source of the primary key inherited by this table.
  • CSD_BULLETINS_TL_PK1 – the composite primary key constraint on BULLETIN_ID and LANGUAGE.
  • CSD_BULLETINS_TL_U1 – the unique index enforcing one translated row per bulletin per language.
  • CSD_BULLETIN_ASSOCIATIONS / bulletin-to-repair mappings – association tables that link bulletins to repair orders or work orders via BULLETIN_ID; the descriptive text for those links resolves through this translation table.
  • FND_LANGUAGES – the language reference table, joined on LANGUAGE or SOURCE_LANG to obtain the localized language name.
  • CSD Repair Order and Work Order entities – the operational documents whose printed output and inquiry pages consume the translated NAME and DESCRIPTION.

Direct DML against CSD_BULLETINS_TL should be avoided. Modification of bulletin text belongs to the Depot Repair maintenance pages or to the MLS translation utilities, which keep NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG internally consistent.