Results for “amw_controls_tl”

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

Overview

AMW_CONTROLS_TL is the translation (TL) table for the Oracle Internal Controls Manager (AMW) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific values for translatable attributes of controls, most notably the control NAME, DESCRIPTION, and verification-related text. In the standard EBS multilingual architecture, every base table with translatable columns is paired with a corresponding _TL table, which holds one row per (entity, language) combination. AMW_CONTROLS_TL therefore allows the same control definition to be displayed in multiple installed languages without duplicating the operational attributes held in the base table.

Under a heuristic Data Vault classification mined from its foreign-key structure, AMW_CONTROLS_TL is best characterized as satellite-leaning. It carries descriptive, language-dependent attributes keyed by a parent identifier (CONTROL_REV_ID) rather than acting as a hub or link. This should be treated as a modeling suggestion, since the table's design intent in EBS is a normalized translation store, not a formal Data Vault construct.

Key Information Stored

AMW_CONTROLS_TL contains 15 documented columns. The most significant are:

• CONTROL_REV_ID — The parent control revision identifier. This column, combined with LANGUAGE, forms the primary key AMW_CONTROLS_TL_PK. It references AMW_CONTROLS_B, the base table that holds the language-independent control attributes.
• LANGUAGE — The installed Oracle language code (for example, US, DE, FR, JA) identifying which translation this row supplies. Together with CONTROL_REV_ID it defines uniqueness, reinforced by the unique index AMW_CONTROLS_TL_U1.
• SOURCE_LANG — The language from which the translated value was derived, used by the translation workflow to track origin.
• NAME — The translated short name of the control, presented in reports, dashboards, and inquiry screens.
• DESCRIPTION — The translated long description of the control, providing business context for auditors and process owners.
• VERIFICATION_SOURCE_NAME — The translated label describing the verification source.
• VERIFICATION_INSTRUCTION — The translated instruction text guiding how the control is verified.
• PHYSICAL_EVIDENCE — The translated description of physical evidence associated with the control.
• SECURITY_GROUP_ID — The security group partition identifier, which references FND_SECURITY_GROUPS and enforces multi-organization data segregation.
• OBJECT_VERSION_NUMBER — The optimistic locking counter used by the AMW forms and OAF pages to detect concurrent updates.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture who created and modified each translation row and when.

The surrogate primary key is AMW_CONTROLS_TL_PK on (CONTROL_REV_ID, LANGUAGE); the unique index AMW_CONTROLS_TL_U1 maps to the same business-key candidate, confirming that no control may hold more than one translation row per language.

Common Use Cases and Queries

The most frequent requirement is retrieving a control's display text in the user's session language, falling back to the base table when no translation exists. A typical query joins the base and translation tables:

• Translated control lookup: SELECT b.control_rev_id, t.name, t.description FROM amw_controls_b b, amw_controls_tl t WHERE b.control_rev_id = t.control_rev_id AND t.language = USERENV('LANG').
• Translation coverage audit: identify controls lacking a row for a given language by outer-joining AMW_CONTROLS_B to AMW_CONTROLS_TL on CONTROL_REV_ID and filtering where LANGUAGE IS NULL for the target code.
• Maintenance reporting: list all translations updated since a given LAST_UPDATE_DATE to support release and audit trails.
• Multilingual reporting: extract NAME and DESCRIPTION per language for regulatory or audit deliverables requiring parallel-language output.

Because translations are seeded through the standard EBS translation forms and the Translation Synchronization process, direct DML should be avoided in favor of the supported AMW maintenance UI.

Related Objects

• AMW_CONTROLS_B — The base table holding language-independent control attributes. Joined on AMW_CONTROLS_TL.CONTROL_REV_ID = AMW_CONTROLS_B.CONTROL_REV_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for data partitioning.
• FND_LANGUAGES — Defines the valid LANGUAGE and SOURCE_LANG codes used in translation rows.
• AMW_CONTROLS_VL — The translated view combining base and _TL data for reporting and LOV use.
• AMW_CONTROL_REVISIONS — Versioning context for CONTROL_REV_ID.
• AMW_PROCESSES / AMW_ORGANIZATIONS — Parent business objects whose controls surface translated names in AMW screens.