Results for “amw_risks_tl”

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

Overview

AMW_RISKS_TL is a translation (TL) table within the Oracle E-Business Suite Internal Controls Manager (AMW) module. It stores the language-dependent, translated attribute values for risk records that are defined in the base table AMW_RISKS_B. In Oracle EBS, the TL pattern separates language-independent data (held in the _B base table) from language-specific descriptive text (held here), so that a single risk definition can be presented in multiple installed languages without duplicating its structural attributes. This object is owned by the AMW schema and is marked VALID in the 12.1.1 / 12.2.2 documentation set.

From a data-modeling perspective, the mined Data Vault classification is satellite-leaning. In this interpretation, AMW_RISKS_TL behaves as a satellite attached to the AMW_RISKS_B hub, carrying descriptive, time-versioned translation attributes keyed to the parent risk revision. This classification is a heuristic suggestion rather than a formal declaration; the table's primary role is that of a language overlay on the base risk record.

Key Information Stored

The table's composite primary key, AMW_RISKS_TL_PK, is defined over LANGUAGE and RISK_REV_ID. The unique index AMW_RISKS_TL_U1 over RISK_REV_ID and LANGUAGE serves as the business-key candidate, guaranteeing that any given risk revision has at most one translation row per language. The documented columns (12 in total) include the following significant attributes:

• RISK_REV_ID — The revision identifier that links each translation row to its parent record in AMW_RISKS_B; part of both the primary key and the unique business key.
• RISK_ID — The logical risk identifier, carrying the underlying risk's identity independent of revision.
• LANGUAGE — The installed Oracle language code for which the translated text applies; the second component of the primary key.
• SOURCE_LANG — The language in which the source text was originally authored, used by the translation framework to determine the base language of comparison.
• NAME — The translated short name or title of the risk.
• DESCRIPTION — The translated free-text description of the risk, typically the largest payload column in a TL table.
• SECURITY_GROUP_ID — The security grouping used for multi-tenant / operating-unit data segregation, with a foreign key to FND_SECURITY_GROUPS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns that capture who created and last modified each translation row and when.

Common Use Cases and Queries

TL tables are almost always joined to their base table when reporting. A typical query retrieves the translated name and description for a given risk in the user's session language:

• Language-specific reporting: JOIN AMW_RISKS_B to AMW_RISKS_TL ON B.RISK_REV_ID = TL.RISK_REV_ID, filtered by TL.LANGUAGE = USERENV('LANG'), to produce localized risk registers.
• Missing-translation audits: Compare installed languages against rows present in AMW_RISKS_TL to find risks without a translation for a required language.
• Source-language reconciliation: Filter on SOURCE_LANG to identify strings authored in a language other than the primary installation language, supporting localization governance.
• Security-scoped extracts: Constrain by SECURITY_GROUP_ID to restrict translated risk content to the appropriate operating unit or responsibility.

Because translation rows are keyed by revision, joins should generally include RISK_REV_ID rather than RISK_ID to ensure the translated text matches the current revision of the risk.

Related Objects

The following objects are most closely coupled to AMW_RISKS_TL:

• AMW_RISKS_B — The base risks table; AMW_RISKS_TL.RISK_REV_ID references AMW_RISKS_B, and the two tables are always joined for localized retrieval.
• FND_SECURITY_GROUPS — Referenced via AMW_RISKS_TL.SECURITY_GROUP_ID, governing which security group may view each translation row.
• AMW_RISKS_TL_PK — The composite primary key constraint over LANGUAGE and RISK_REV_ID.
• AMW_RISKS_TL_U1 — The unique index over RISK_REV_ID and LANGUAGE, enforcing one translation per risk revision per language.
• AMW_RISKS_VL (and similar _VL views) — The standard EBS "view language" layer that exposes translated risk content to forms, OAF pages, and concurrent programs by joining the _B and _TL tables.