Results for “sr_task_type_det_id”

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

Overview

CUG.CUG_SR_TASK_TYPE_DETS_TL is the translation (TL) table for the Citizen Interaction Center (CUG) service request task type detail entity in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold the translated values for the base table CUG_SR_TASK_TYPE_DETS_B, following the standard Oracle EBS multilingual architecture in which the _B table stores language-independent rows and the _TL table stores one translatable row per installed language. In this pattern the _B table owns the surrogate identifier and the _TL table carries the user-facing text columns that must be rendered in the session language.

The object is owned by the CUG schema and is documented as VALID in the ETRM repository. The physical schema exposes eleven columns. Under the heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning: it is keyed by a composite of an identifier inherited from a parent business entity plus LANGUAGE, it carries descriptive and audit attributes, and it references an FND security group. That classification is offered as a modeling suggestion rather than a mandated design; the table can be treated as the descriptive companion of the base row it translates.

Key Information Stored

The primary key is documented as CUG_SR_TASK_TYPE_DETS_TL_PK over (SR_TASK_TYPE_DET_ID, LANGUAGE). SR_TASK_TYPE_DET_ID is the surrogate key inherited from CUG_SR_TASK_TYPE_DETS_B and is the only foreign key column present in the primary key; LANGUAGE identifies the language of the translated row and completes the uniqueness of the key. Together these two columns form the join back to the base entity and the filter for the active session language.

• SR_TASK_TYPE_DET_ID — surrogate identifier of the task type detail, originating in the _B table.
• LANGUAGE — language code of the translated row; the second component of the primary key.
• TASK_NAME — the translatable display name of the task type detail.
• DESCRIPTION — the translatable descriptive text for the task type detail.
• SOURCE_LANG — the language in which the row was originally authored, used by the translation tooling.
• SECURITY_GROUP_ID — operating unit / security group discriminator, referencing FND_SECURITY_GROUPS and enabling multi-org data segregation.
• CREATED_BY, CREATION_DATE — standard who-column audit attributes for row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who-column audit attributes for the most recent update.

No additional unique business-key index is documented beyond the composite primary key, so SR_TASK_TYPE_DET_ID plus LANGUAGE is the effective business identity of a translated row.

Common Use Cases and Queries

The predominant access pattern is a joined read of the base and translation tables filtered by language, typically to populate task type detail lookups in the Citizen Interaction Center UI or in custom reports and extracts.

• Retrieve the translated task name and description for a given detail identifier in the session language.
• List all task type details with their translations for a specific language to build reference lists.
• Audit translation coverage by comparing the count of _B rows against the count of _TL rows per language.
• Inspect source text and translation status using SOURCE_LANG alongside LANGUAGE for translation-maintenance reporting.

A representative query joining the translation to the base table and constraining by language:

SELECT b.sr_task_type_det_id, t.task_name, t.description
FROM cug.cug_sr_task_type_dets_b b,
     cug.cug_sr_task_type_dets_tl t
WHERE b.sr_task_type_det_id = t.sr_task_type_det_id
  AND t.language = USERENV('LANG');

Related Objects

The most significant dependencies are the base entity this table translates and the security group used for data segregation, together with the applications that surface the translated text.

• CUG_SR_TASK_TYPE_DETS_B — the base table; joined on SR_TASK_TYPE_DET_ID (the documented foreign key from _TL to _B).
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for multi-org security filtering.
• FND_LANGUAGES — supplies valid values for the LANGUAGE and SOURCE_LANG columns.
• FND_TERRITORIES / FND_LANGUAGES_TL — supporting language metadata used when presenting translations.
• CUG service request task configuration objects — the surrounding Citizen Interaction Center task type detail setup that consumes TASK_NAME and DESCRIPTION for display.

Because the table is a translation satellite, direct DML is normally performed through the CUG setup and translation maintenance functions rather than by ad hoc inserts, ensuring the _B and _TL rows remain synchronized across installed languages.