Results for “sr_attr_default_value”

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

Overview

CUG_SR_TYPE_ATTR_MAPS_TL is a translation (TL) table within the CUG schema, belonging to the Citizen Interaction Center product module of Oracle E-Business Suite. It is a multi-language companion to CUG_SR_TYPE_ATTR_MAPS_B, storing the language-specific and translated values for the attribute mappings defined against service request types. In EBS Release 12.1.1 and 12.2.2, the CUG module supports citizen-facing service request configuration; the _B table holds the base (untranslated) definition, while this _TL table holds the same logical rows expressed in each installed language.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is modeled as satellite-leaning. In practical terms, it behaves as a dependent satellite hanging off the base entity CUG_SR_TYPE_ATTR_MAPS_B, carrying descriptive, mutable, and language-dependent attributes rather than defining independent business entities or linking two hubs. The classification is a modeling suggestion only; the object remains a standard Oracle EBS MLS (Multi-Language Support) translated table.

Key Information Stored

The table contains ten documented columns. The most significant are:

• SR_TYPE_ATTR_MAP_ID — The surrogate identifier of the attribute map. It is the first component of the composite primary key CUG_SR_TYPE_ATTR_MAPS_TL_PK and the foreign key pointing back to CUG_SR_TYPE_ATTR_MAPS_B. It is not unique on its own within this table.
• LANGUAGE — The installed language code of the row. It is the second component of the composite primary key, so the true uniqueness of the table is the pairing of SR_TYPE_ATTR_MAP_ID and LANGUAGE (the composite business key for retrieval purposes).
• SR_ATTR_DEFAULT_VALUE — The translated default value applied to the corresponding service request attribute. Because it is a TL-column, its content is language-sensitive and differs per LANGUAGE row.
• SOURCE_LANG — The language of the base record from which the translated value was derived; used by MLS to determine whether the current row reflects the source text or an actual translation.
• SECURITY_GROUP_ID — The security group under which the row is registered, with a foreign key to FND_SECURITY_GROUPS. This supports multi-org and data-security filtering.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard Oracle EBS who/when audit information for each translated row.

Columns such as the audit and MLS fields are not business identifiers; only the composite (SR_TYPE_ATTR_MAP_ID, LANGUAGE) provides row uniqueness.

Common Use Cases and Queries

Typical usage centers on presenting service request attribute configurations in the user's session language, and on administrative joins back to the base table.

• Retrieve the translated default value for a given attribute map and language:

SELECT tl.sr_attr_default_value
FROM cug.cug_sr_type_attr_maps_tl tl
WHERE tl.sr_type_attr_map_id = :map_id
AND tl.language = USERENV('LANG');

• Join base and translated rows for a bilingual report:

SELECT b.sr_type_attr_map_id, tl.language, tl.sr_attr_default_value
FROM cug.cug_sr_type_attr_maps_b b,
cug.cug_sr_type_attr_maps_tl tl
WHERE b.sr_type_attr_map_id = tl.sr_type_attr_map_id;

• Identify rows lacking a translation in a target language, or audit which rows were entered in a specific language using SOURCE_LANG.
• Filter by SECURITY_GROUP_ID to honor data security when reporting across organizations.

Related Objects

The following objects are most significant based on documented key relationships:

• CUG_SR_TYPE_ATTR_MAPS_B — The base table; joined on SR_TYPE_ATTR_MAP_ID, this _TL row depends on the base record for its existence.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID, controlling organization-level access to the row.
• FND_LANGUAGES — Not documented as a formal FK here, but the LANGUAGE column conventionally aligns to installed languages; useful for resolving language descriptions.
• CUG_SR_TYPE_ATTR_MAPS_TL_PK — The primary key constraint that enforces the composite (SR_TYPE_ATTR_MAP_ID, LANGUAGE) uniqueness.
• FND_APPLICATION / CUG module lookup views — MLS-enabled views over this object resolve translations for UI display in the Citizen Interaction Center flows.

Together these relationships confirm the table's role as a language satellite supporting the service request type attribute mapping configuration in the CUG module.