Search Results amw_assess_procedures_tl




Overview
Explore in AI Chat

Overview

AMW_ASSESS_PROCEDURES_TL is the translation table that stores the language-specific name and description for records held in AMW_ASSESS_PROCEDURES_B. It belongs to the AMW schema within the Internal Controls Manager (ICM) product, a module of Oracle E-Business Suite used to document, test, and certify internal controls. In the ETRM 12.1.1 documentation this object is classified as VALID, contains 10 documented columns, and is owned by AMW.

From a data-modeling perspective, the heuristic Data Vault classification extracted from the foreign-key structure is standalone. This suggests the table can be modeled as an independent satellite-like entity keyed by its own composite identifier; because no join dependencies were mined from the FK metadata, it should not be treated as a link table connecting two hubs. The semantic reality is that AMW_ASSESS_PROCEDURES_TL is a child/satellite of AMW_ASSESS_PROCEDURES_B, delivering translated (TL) text attributes for assessment procedures.

Key Information Stored

The primary key AMW_ASSESS_PROCEDURES_TL_PK is a composite of ASSESS_PROCEDURE_ID and LANGUAGE. ASSESS_PROCEDURE_ID is the surrogate foreign-key column that points back to the base table AMW_ASSESS_PROCEDURES_B, while LANGUAGE identifies the ISO/native language of the translated row. Together they form the unique business key of the translation record.

  • ASSESS_PROCEDURE_ID — surrogate identifier of the parent assessment procedure; part of the composite primary key.
  • LANGUAGE — the language code of the translation row; part of the composite primary key.
  • NAME — the translated display name of the assessment procedure.
  • DESCRIPTION — the translated long description of the assessment procedure.
  • SOURCE_LANG — the source language from which the translation originated (Oracle Applications TL convention, typically US).
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — audit stamps recording the last modification and the user who made it.
  • CREATION_DATE / CREATED_BY — audit stamps recording when and by whom the row was created.
  • LAST_UPDATE_LOGIN — the login session identifier associated with the last update, supporting audit traceability.

Common Use Cases and Queries

The table is primarily queried to retrieve translated procedure names for reports, LOVs, and certification pages, and to verify translation completeness across languages. A typical pattern joins the base table to the translation table on the shared identifier and filters by the caller's language:

SELECT b.ASSESS_PROCEDURE_ID, t.NAME, t.DESCRIPTION
FROM AMW.AMW_ASSESS_PROCEDURES_B b,
AMW.AMW_ASSESS_PROCEDURES_TL t
WHERE b.ASSESS_PROCEDURE_ID = t.ASSESS_PROCEDURE_ID
AND t.LANGUAGE = USERENV('LANG');

Translation-coverage reports use an outer-join or MINUS query against the base table to find procedures lacking a row for a required language. Audit-oriented queries inspect LAST_UPDATED_BY and CREATION_DATE to determine who last touched a translation. Because the table is small and keyed by procedure plus language, it is also a common target for BI Publisher and OBIEE extracts for control documentation.

Related Objects

  • AMW_ASSESS_PROCEDURES_B — the base (non-translated) table holding the primary key ASSESS_PROCEDURE_ID; parent of this translation table.
  • AMW_ASSESS_PROCEDURES_TL_PK — the composite primary key constraint (ASSESS_PROCEDURE_ID, LANGUAGE) enforcing uniqueness.
  • AMW_ASSESS_PROCEDURES_VL — the typical translated view that joins _B and _TL for language-aware access.
  • FND_LANGUAGES / FND_LANGUAGE_TL — reference tables validating the LANGUAGE and SOURCE_LANG values.
  • FND_USER — provides CREATED_BY and LAST_UPDATED_BY user identities for audit reporting.
  • ICM certification and assessment pages — application UI components that render NAME and DESCRIPTION values from this table.

This object is read-mostly and maintained through ICM setup forms; direct DML is discouraged and should be performed only by the AMW schema owner or via supported Oracle patches.