Results for “task_attr_default_value”

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

Overview

The table CUG_TSK_TYP_ATTR_MAPS_TL is the translation (language) table for CUG_TSK_TYP_ATTR_MAPS_B, the base table that defines mappings between task types and their attributes within the Citizen Interaction Center (CUG) module of Oracle E-Business Suite. In Oracle EBS, the _TL suffix designates a table that stores translatable, language-specific text for a corresponding base entity, keyed by the entity identifier plus a LANGUAGE column. Each base row in CUG_TSK_TYP_ATTR_MAPS_B may therefore have one translation row per installed language, allowing task-attribute mapping definitions to be presented in the user's session language.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. The base entity CUG_TSK_TYP_ATTR_MAPS_B acts as the hub, and the _TL table behaves as a satellite that carries descriptive, language-dependent attributes tied back to the hub via TSK_TYP_ATTR_MAP_ID. This classification is a heuristic suggestion rather than a documented constraint. The object resides in the CUG schema and is marked VALID in the ETRM repository for the 12.1.1 and 12.2.2 releases.

Key Information Stored

The table is defined with 11 columns. The most significant are:

• TSK_TYP_ATTR_MAP_ID — Surrogate identifier inherited from CUG_TSK_TYP_ATTR_MAPS_B; the foreign key that joins each translation row to its base mapping. It forms the leading component of the primary key.
• LANGUAGE — The language code of the translation row. Together with the identifier it forms the composite primary key CUG_TSK_TYP_ATTR_MAPS_TL_PK.
• TASK_ATTR_DEFAULT_VALUE — The language-specific default value displayed for a task attribute in this mapping. This is the primary translated business attribute of the table.
• SOURCE_LANG — Indicates the language in which the base record was originally authored, supporting the standard EBS translation model.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing the data security grouping under which the row is visible.
• ZD_EDITION_NAME — Editioning discriminator, matched against the edition specified in the unique index CUG_TSK_TYP_ATTR_MAPS_TL_U1 (TSK_TYP_ATTR_MAP_ID, LANGUAGE, ZD_EDITION_NAME).
• WHO audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide creation and last-update lineage.

The surrogate primary key is the composite (TSK_TYP_ATTR_MAP_ID, LANGUAGE). The unique index CUG_TSK_TYP_ATTR_MAPS_TL_U1, which additionally includes ZD_EDITION_NAME, distinguishes business-key candidates under the editioning model used in 12.2.2.

Common Use Cases and Queries

Typical scenarios involve resolving the translated default value for a task-type attribute mapping in a given language, or producing multilingual extracts of task configuration. A representative query joining the translation and base tables is:

• SELECT tl.TSK_TYP_ATTR_MAP_ID, tl.LANGUAGE, tl.TASK_ATTR_DEFAULT_VALUE FROM CUG.CUG_TSK_TYP_ATTR_MAPS_TL tl WHERE tl.LANGUAGE = USERENV('LANG') AND tl.TSK_TYP_ATTR_MAP_ID = :map_id;
• Reporting joins against CUG_TSK_TYP_ATTR_MAPS_B to list all mappings with their translated values for a specific locale.
• Data migration or audit queries that compare SOURCE_LANG entries to detect untranslated or stale rows.
• Security-filtered extracts using SECURITY_GROUP_ID to scope results to the appropriate group.

Related Objects

• CUG_TSK_TYP_ATTR_MAPS_B — Base table; joined on TSK_TYP_ATTR_MAP_ID. The translation table depends on it through the documented foreign key.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID to control row visibility.
• Related CUG task-type and attribute configuration tables (for example, task type definitions and attribute definitions) that supply the TSK_TYP_ATTR_MAP_ID values resolved by this translation table.
• Standard FND language and territory lookup views, used to interpret the LANGUAGE and SOURCE_LANG columns.