Search Results amw_audit_objectives_tl

Overview

AMW_AUDIT_OBJECTIVES_TL is the translation (TL) table for Audit Objectives within the Oracle E-Business Suite Internal Controls Manager (AMW) module. Its documented role is to hold the language-specific name and description for each audit objective defined in the base table AMW_AUDIT_OBJECTIVES_B. In Oracle EBS, _TL tables follow the standard multi-language design pattern: the _B table stores the language-independent attributes, while the _TL table stores translatable text keyed by OBJECTIVE_ID and LANGUAGE. This separation allows a single audit objective definition to be rendered in the user's session language without duplicating its operational attributes.

The object is owned by the AMW schema and is documented at 12 columns in the ETRM 12.1.1 physical schema. Its status is VALID. The FK metadata lists a single reference, AMW_AUDIT_OBJECTIVES_TL.SECURITY_GROUP_ID to FND_SECURITY_GROUPS, and the Data Vault classification heuristic mined from that FK structure is standalone. From a dimensional modeling perspective, this would be treated as a satellite or descriptive text component attached to the base audit-objective entity, though the heuristic classification places it as standalone given the absence of a parent FK to AMW_AUDIT_OBJECTIVES_B in the documented relationship data.

Key Information Stored

The table's primary key is AMW_AUDIT_OBJECTIVES_TL_PK, defined on the composite (OBJECTIVE_ID, LANGUAGE). OBJECTIVE_ID is the surrogate identifier shared with the base table and constitutes the join key; LANGUAGE is the language code that selects the appropriate translated row for a given session.

• OBJECTIVE_ID — Surrogate identifier of the audit objective; part of the composite primary key and the join key to the base table.
• LANGUAGE — Language code for the translated content; the second component of the primary key.
• NAME — Language-specific name of the audit objective.
• DESCRIPTION — Language-specific descriptive text for the objective.
• SOURCE_LANG — The language in which the source content was originally entered; relevant to the translation workflow.
• SECURITY_GROUP_ID — Security grouping attribute; the only documented foreign key, referencing FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — Optimistic locking column used to detect concurrent updates.
• CREATION_DATE, CREATED_BY — Standard who-columns recording row creation audit information.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard who-columns capturing the most recent modification audit trail.

Common Use Cases and Queries

The most frequent access pattern joins the translation table back to the base table to retrieve user-facing names and descriptions in the correct language. A representative query filters on the session language and the security group:

• Reporting: SELECT b.objective_id, t.name, t.description FROM amw_audit_objectives_b b, amw_audit_objectives_tl t WHERE b.objective_id = t.objective_id AND t.language = USERENV('LANG') AND t.security_group_id = :security_group_id;
• Translation completeness checks: identify base rows lacking a translated row for a given language by comparing OBJECTIVE_ID sets between the base and translation tables.
• Maintenance: locate the source-language row via SOURCE_LANG to review or amend original text.
• Auditing: use the who-columns and OBJECT_VERSION_NUMBER to track when objectives were reworded and by whom.

Related Objects

The following objects are the most significant in relation to this table. The documented FK to FND_SECURITY_GROUPS is the only explicit relationship in the metadata; the remaining associations derive from the shared OBJECTIVE_ID business key and the AMW module design.

• AMW_AUDIT_OBJECTIVES_B — Base table holding language-independent attributes; joined on OBJECTIVE_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; enforces the security grouping of objective content.
• FND_LANGUAGES — Supplies valid LANGUAGE codes used in the composite key.
• FND_SESSIONS / USERENV — Not tables but the mechanism that determines the runtime LANGUAGE value for queries.
• AMW_AUDIT_OBJECTIVE_ASSOCS (where present) — Association tables linking objectives to controls; typically resolve objective names via the translation table rather than the base table alone.

As with all _TL tables, direct DML should be avoided in favor of the AMW module's internal controls setup and administration forms, which maintain both the base and translation rows in a consistent fashion.