Search Results amw_certification_tl




Overview
Explore in AI Chat

Overview

AMW_CERTIFICATION_TL is the translation table for certification definitions within the Oracle E-Business Suite Internal Controls Manager (AMW) module. In the Oracle EBS multilanguage architecture, base entities are stored in a "_B" table (AMW_CERTIFICATIONS_B), translatable descriptive attributes are stored in the corresponding "_TL" table, and the two are joined on the primary key. AMW_CERTIFICATION_TL holds the language-specific values for the certification name and description, allowing a single certification record to be presented in any installed language without duplicating transactional data.

The table resides in the AMW schema and is defined with a composite primary key, AMW_CERTIFICATION_TL_PK, consisting of CERTIFICATION_ID and LANGUAGE. This composite key is the defining characteristic of an EBS translation table: for each certification, one row exists per installed language. The documentation classifies this object as standalone under the heuristic Data Vault model. In Data Vault terms, translation tables of this type are most naturally modeled as satellites, since they carry descriptive, time-variant attributes (name and description) keyed by the parent business key plus a language qualifier. A standalone classification reflects the absence of strong transactional foreign-key dependencies beyond the security group reference.

Key Information Stored

The table contains fourteen documented columns. The most significant are listed below.

  • CERTIFICATION_ID — Surrogate identifier inherited from the parent certification entity and part of the composite primary key. It links the translation row to its base record.
  • LANGUAGE — The language code for this translated row, and the second component of the primary key.
  • CERTIFICATION_NAME — The translated certification name displayed to users in the selected language.
  • CERTIFICATION_DESCRIPTION — The translated descriptive text for the certification.
  • SOURCE_LANGUAGE and SOURCE_LANG — Indicate the language in which the certification was originally authored, supporting the translation comparison and seeding logic used by the Oracle translation framework.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing the multi-tenant security model by restricting visibility of translation rows to authorized security groups.
  • OBJECT_VERSION_NUMBER — Supports optimistic locking during concurrent updates by the Oracle Applications Framework (OAF) or Forms-based UI.
  • ORIG_SYSTEM_REFERENCE — Identifies the originating system when certification data is migrated or synchronized from an external source.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS who-column audit fields recording row creation and modification history.

The primary key (CERTIFICATION_ID, LANGUAGE) serves as the effective unique business key: no two rows may share the same certification and language combination. The WHO columns and SECURITY_GROUP_ID are administrative rather than business-identifying attributes.

Common Use Cases and Queries

The most frequent access pattern is a join to the base table to retrieve a user-facing certification name in the session language. A representative query is:

SELECT b.certification_id, t.certification_name, t.certification_description FROM amw_certifications_b b, amw_certification_tl t WHERE b.certification_id = t.certification_id AND t.language = USERENV('LANG');

Reporting use cases include building certification catalogues and compliance dashboards that require localized labels, auditing which languages have been populated for a given certification, and identifying untranslated records by comparing SOURCE_LANGUAGE against available LANGUAGE rows. Administrators may also query the table to verify that translation seeding ran correctly after a patch or language installation.

Related Objects

  • AMW_CERTIFICATIONS_B — The base certification table; joined on CERTIFICATION_ID to supply non-translatable attributes.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID to enforce security group access.
  • FND_LANGUAGES — Provides the valid language definitions corresponding to the LANGUAGE column.
  • AMW_CERTIFICATION_TL_PK — The unique index enforcing the composite primary key.
  • Certification-related child tables and OAF/Forms certification maintenance pages within the AMW module that consume the translated name and description at runtime.

Because the object is classified as standalone in the Data Vault heuristic, downstream dependencies are limited primarily to the parent base table and standard EBS language and security infrastructure rather than to a broad web of transactional relationships.