Search Results amw_work_categories_tl




Overview
Explore in AI Chat

Overview

AMW_WORK_CATEGORIES_TL is the translation (language) table for work category definitions within the Oracle Internal Controls Manager (AMW) product module. In Oracle EBS 12.1.1 and 12.2.2, this table stores the language-specific category name, plural name, and description attributes for each work category. It is the _TL companion to AMW_WORK_CATEGORIES_B, the base table that holds language-independent attributes. Work categories classify work items such as issues, findings, remediation plans, and audit engagements managed through Internal Controls Manager, allowing users to group and report on work of similar type.

From a heuristic Data Vault modeling perspective, this table would most naturally be classified as a satellite, since it carries descriptive, language-dependent attributes (name, description) that qualify the core category business entity whose surrogate key lives in the base table. The metadata also documents a foreign key to FND_SECURITY_GROUPS, indicating integration with Oracle Application Object Library security group definitions.

Key Information Stored

The table is defined in the AMW schema and contains 13 documented columns. The most significant are:

  • CATEGORY_ID – Surrogate key inherited from AMW_WORK_CATEGORIES_B; part of the composite primary key (AMW_WORK_CATEGORIES_TL_PK). It links each translation row to its base category.
  • LANGUAGE – The language code for the translation, forming the second component of the primary key.
  • CATEGORY_NAME – The translated display name shown to end users in the appropriate language.
  • PLURAL_NAME – The translated plural form used in list-of-values and reporting contexts.
  • DESCRIPTION – The translated textual description of the work category.
  • SOURCE_LANG – Identifies the source language of the original translation, supporting Oracle's translation propagation conventions.
  • SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, governing which security group can view the category.
  • OBJECT_VERSION_NUMBER – Optimistic locking column used by the Oracle AOL framework to prevent concurrent update conflicts.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle who-columns tracking record creation and maintenance for audit purposes.

The business key is effectively the combination of the base category identity (CATEGORY_ID) plus LANGUAGE, enforced by the primary key. There is no independent unique business index documented beyond AMW_WORK_CATEGORIES_TL_PK.

Common Use Cases and Queries

Typical uses include building multilingual work category list-of-values and reporting on categories in the user's session language. A common join retrieves the translated name for a given language:

SELECT b.category_id, t.category_name, t.plural_name, t.description
FROM   amw_work_categories_b b,
       amw_work_categories_tl t
WHERE  b.category_id = t.category_id
AND    t.language = USERENV('LANG');

Security-aware queries filter by SECURITY_GROUP_ID, and audit reports typically examine CREATED_BY / LAST_UPDATED_BY columns. Note that in a multi-language installation, rows are keyed by CATEGORY_ID plus LANGUAGE, so queries must always include a language predicate to avoid returning duplicate rows.

Related Objects

  • AMW_WORK_CATEGORIES_B – The base table holding language-independent attributes; joined on CATEGORY_ID.
  • FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID to enforce security group access.
  • FND_LANGUAGES – Provides language validation for the LANGUAGE column via the standard AOL framework.
  • AMW_WORK_CATEGORIES_TL_PK – The composite primary key (CATEGORY_ID, LANGUAGE) enforcing translation uniqueness.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS – Supporting AOL objects whose configuration governs the table's runtime behavior.