Search Results amw_audit_projects_tl_pk




Overview
Explore in AI Chat

Overview

AMW_AUDIT_PROJECTS_TL is the translation table for AMW_AUDIT_PROJECTS_B within the AMW (Internal Controls Manager) product of Oracle E-Business Suite. In the Oracle EBS multilanguage architecture, the _TL suffix denotes a table that stores language-dependent descriptive attributes for a corresponding _B base table. This table holds the user-facing NAME and DESCRIPTION for audit projects defined in the base table, allowing the same audit project record to present translated names and descriptions for each installed and enabled language in the EBS instance.

The object is documented as VALID in the AMW schema on ETRM release 12.1.1, with a physical schema of twelve columns. A heuristic Data Vault classification derived from the foreign key profile suggests this table behaves as a satellite—specifically a descriptive, language-qualified satellite attached to the audit project hub represented by AMW_AUDIT_PROJECTS_B. This classification is a modeling suggestion only; the physical implementation follows standard EBS translation-table conventions rather than a formal Data Vault design.

Key Information Stored

The table is anchored by the composite primary key AMW_AUDIT_PROJECTS_TL_PK, defined on the surrogate identifier AUDIT_PROJECT_ID combined with LANGUAGE. The pair forms a one-row-per-language relationship to the base table, where AUDIT_PROJECT_ID is the foreign business key reference to AMW_AUDIT_PROJECTS_B and LANGUAGE identifies the language of the descriptive text. The name and description columns are the primary business-facing content:

  • AUDIT_PROJECT_ID — surrogate identifier linking the translation row to its parent audit project in AMW_AUDIT_PROJECTS_B.
  • LANGUAGE — language code qualifying the translated text; part of the composite primary key.
  • NAME — the translated audit project name exposed in forms and reports.
  • DESCRIPTION — the translated narrative description of the audit project.
  • SOURCE_LANG — the language in which the source text was originally entered, used by the translation framework for language comparison.
  • SECURITY_GROUP_ID — the security group context, joining to FND_SECURITY_GROUPS for multi-organization data access control.
  • OBJECT_VERSION_NUMBER — optimistic locking column supporting concurrent update detection.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit who-columns tracking row creation and modification history.

Common Use Cases and Queries

Reporting against audit projects almost always requires joining the translation table to the base table to retrieve the current-language name and description. The standard pattern joins on AUDIT_PROJECT_ID and filters by the session language, typically using the FND_GLOBAL language mechanism or a bind variable:

  • Listing audit projects with localized names: SELECT b.audit_project_id, t.name, t.description FROM amw_audit_projects_b b, amw_audit_projects_tl t WHERE b.audit_project_id = t.audit_project_id AND t.language = USERENV('LANG').
  • Verifying translation completeness by counting rows per LANGUAGE for a given audit project.
  • Auditing who last changed a project name or description via LAST_UPDATED_BY and LAST_UPDATE_DATE.
  • Extracting multilingual extracts for global internal controls reporting.

Because the table is maintained exclusively through the AMW Internal Controls Manager application and its translation framework, direct DML is not recommended; inserts and updates should flow through the corresponding AOL/AMW APIs to preserve the base-to-translation integrity.

Related Objects

The table participates in a small, tightly bound object set:

  • AMW_AUDIT_PROJECTS_B — the base table holding language-independent audit project attributes; joined on AUDIT_PROJECT_ID.
  • AMW_AUDIT_PROJECTS_TL_PK — the primary key constraint enforcing uniqueness of AUDIT_PROJECT_ID plus LANGUAGE.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, governing security group access to audit project translations.
  • FND_LANGUAGES — defines the valid LANGUAGE values available to the translation row.
  • FND_APPLICATION — identifies the AMW application context for the object.

Together these objects support the localized presentation layer for audit projects in Oracle Internal Controls Manager.