Search Results amw_evaluations_tl_pk

Overview

AMW_EVALUATIONS_TL is the translation table for the AMW_EVALUATIONS base table within the Oracle E-Business Suite Internal Controls Manager (AMW) module. Internal Controls Manager is used to document, test, and certify internal control frameworks and business processes as part of regulatory compliance initiatives such as Sarbanes-Oxley. The _TL suffix identifies this as a multilingual (translated) companion table, which stores language-specific descriptive text for a parent entity. In Oracle EBS, every base table that carries user-facing descriptive content typically has a corresponding _TL table to support the Multi-Language Support (MLS) framework, and AMW_EVALUATIONS_TL fulfills this role for evaluation records.

From a data modeling perspective, the mined Data Vault classification for this object is standalone. Because the only referenced foreign key is to the generic FND_SECURITY_GROUPS table rather than to another core AMW entity, the table is best treated as an independent satellite of the evaluation entity rather than a hub or link. Its grain is one row per evaluation per installed language, and it holds the translated descriptive attribute COMMENTS keyed by EVALUATION_ID and LANGUAGE.

Key Information Stored

The table contains eleven documented columns in the 12.1.1 physical schema. The columns of greatest functional significance are:

• EVALUATION_ID — The surrogate primary key component that links each translation row back to its parent record in AMW_EVALUATIONS. This is the principal join column.
• LANGUAGE — The installed Oracle language code identifying the language of the translated content. Together with EVALUATION_ID it forms the composite primary key AMW_EVALUATIONS_TL_PK.
• SOURCE_LANG — Identifies the source language from which the translation was created, supporting the MLS translation workflow.
• COMMENTS — The translated descriptive text for the evaluation; this is the attribute being translated and the primary payload of the table.

The remaining columns are standard EBS audit and concurrency attributes present on nearly all transactional tables: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER. The column SECURITY_GROUP_ID, which appears as a foreign key reference to FND_SECURITY_GROUPS, enables multi-tenant / operating-unit data segregation consistent with the AMW data security model.

Two unique indexes are documented: the primary key AMW_EVALUATIONS_TL_PK (EVALUATION_ID, LANGUAGE) and the business-key candidate AMW_EVALUATIONS_TL_U1 (EVALUATION_ID, LANGUAGE). The surrogate key of the parent entity is EVALUATION_ID; the composite business key is the pairing of EVALUATION_ID with LANGUAGE.

Common Use Cases and Queries

Because AMW_EVALUATIONS_TL is an MLS companion table, it is rarely queried in isolation. Reporting and integration scenarios typically join it back to the base table to retrieve translated comments for a specific language. A representative query pattern is:

• Retrieve evaluation comments in a specific language: SELECT t.EVALUATION_ID, t.COMMENTS FROM AMW_EVALUATIONS_TL t WHERE t.LANGUAGE = USERENV('LANG') AND t.EVALUATION_ID = :id;
• Diagnose missing translations by comparing base and translation counts: SELECT b.EVALUATION_ID FROM AMW_EVALUATIONS b WHERE NOT EXISTS (SELECT 1 FROM AMW_EVALUATIONS_TL t WHERE t.EVALUATION_ID = b.EVALUATION_ID AND t.LANGUAGE = USERENV('LANG'));
• Audit translated content changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance evidence trails.
• Operational-unit-scoped extracts filtered by SECURITY_GROUP_ID.

Typical consumers are MLS-aware AMW forms, concurrent programs that generate compliance reports, and custom extracts feeding external GRC tools.

Related Objects

• AMW_EVALUATIONS — The parent/base table; joined on EVALUATION_ID and the dominant dependency.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID to enforce operating-unit security.
• FND_LANGUAGES — Supplies the valid LANGUAGE codes used in the LANGUAGE column.
• AMW_EVALUATIONS_TL_PK — Primary key constraint (EVALUATION_ID, LANGUAGE).
• AMW_EVALUATIONS_TL_U1 — Unique business-key index (EVALUATION_ID, LANGUAGE).
• FND_MLS_* / TCA MLS utilities — EBS MLS framework objects that manage translation population and retrieval.

These objects should be considered when building joins, extraction logic, or data lineage documentation for AMW evaluation data.