Search Results amw_setup_risk_types_tl_pk

Overview

The AMW_SETUP_RISK_TYPES_TL table is a translation (TL) table belonging to the Oracle Internal Controls Manager (AMW) module, classified in the ETRM metadata as Obsolete. It stores the language-specific name and description of risk types defined for the Internal Controls Manager application. As the translation companion to AMW_SETUP_RISK_TYPES_B, this table holds the multilingual representations of each risk type record keyed by SETUP_RISK_TYPE_ID and LANGUAGE. The metadata records that the object is "Not implemented in this database," indicating that in the surveyed 12.1.1 environment the table was either not deployed or had been superseded by the deprecation of the AMW product line.

The heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault modeling terms this suggests treating the table as neither a classic hub nor a link in isolation; it functions as a descriptive satellite joined to its base table via the shared SETUP_RISK_TYPE_ID. The absence of a foreign key to the base table within the documented FK set reinforces that the relationship is enforced through the application layer rather than a database constraint.

Key Information Stored

The table's physical schema in the 12.1.1 documentation carries eleven columns. The most significant are:

• SETUP_RISK_TYPE_ID — the surrogate identifier for the risk type; together with LANGUAGE it forms the primary key AMW_SETUP_RISK_TYPES_TL_PK, but it is not globally unique on its own.
• LANGUAGE — the language code of the translated row; a component of both the primary key and the unique key.
• NAME — the translated name of the risk type; combined with LANGUAGE it forms the unique key AMW_SETUP_RISK_TYPES_TL_UK, making NAME a business-key candidate.
• DESCRIPTION — the translated descriptive text for the risk type.
• SOURCE_LANG — the language in which the source record was originally authored, used by the translation framework to determine staleness.
• SECURITY_GROUP_ID — the foreign key referencing FND_SECURITY_GROUPS, controlling row-level access under multi-org or function security models.

The remaining audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — are the standard Oracle EBS "Who" columns populated by the framework. Note the distinction between the surrogate PK (SETUP_RISK_TYPE_ID, LANGUAGE) and the unique business key (NAME, LANGUAGE).

Common Use Cases and Queries

Typical usage centers on joining the translation table back to its base table to produce a fully localized listing of risk types for the Internal Controls Manager questionnaire and assessment screens. A representative query would be:

• SELECT b.setup_risk_type_id, t.name, t.description FROM amw_setup_risk_types_b b, amw_setup_risk_types_tl t WHERE b.setup_risk_type_id = t.setup_risk_type_id AND t.language = USERENV('LANG');
• Reporting on available risk types per security group by joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS.
• Auditing translation coverage by comparing the count of base records against translated rows per LANGUAGE.

Because the object is marked obsolete, such queries are relevant primarily for data migration, historical reporting, or when validating legacy AMW configurations prior to archiving.

Related Objects

• AMW_SETUP_RISK_TYPES_B — the base (non-translated) table sharing SETUP_RISK_TYPE_ID; the primary join partner.
• FND_SECURITY_GROUPS — referenced through the SECURITY_GROUP_ID foreign key, providing row-level security context.
• FND_LANGUAGES — the canonical source of valid LANGUAGE and SOURCE_LANG values used by the TL pattern.
• FND_APPLICATION — identifies the owning AMW application in the standard EBS framework.
• Other AMW_SETUP_*_TL tables — sibling translation tables following the same TL convention, useful for cross-referencing setup data.

Given the obsolete status, no supported public API references this object; access is limited to direct SQL for archival or analytical purposes.