Results for “amw_opinion_values_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMW_OPINION_VALUES_TL is the translatable child table of the Opinion Values entity within the Oracle EBS Internal Controls Manager (AMW) product. Internal Controls Manager supports the documentation, testing, and certification of internal controls over financial reporting, and opinion values represent the discrete assessment outcomes—such as "Effective," "Deficient," or "Significant Deficiency"—that testers and certifiers assign when evaluating a control or a process. This table stores the language-specific display text for those opinion values, allowing the same logical opinion value to be presented in multiple installed languages.

The table resides in the AMW schema and is paired with its base table, AMW_OPINION_VALUES_B, which holds language-independent attributes. AMW_OPINION_VALUES_TL holds only descriptive, translatable fields keyed by opinion value and language. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table carries descriptive, context-dependent attributes attached to the AMW_OPINION_VALUES_B parent rather than representing an independent business entity or a relationship between entities.

Key Information Stored

The table is defined by the primary key AMW_OPINION_VALUES_TL_PK, composed of OPINION_VALUE_ID and LANGUAGE. OPINION_VALUE_ID is the surrogate identifier that links each row to its base record in AMW_OPINION_VALUES_B; it is not a user-visible business key. The unique index AMW_OPINION_VALUES_TL_U1 covers the same two columns (OPINION_VALUE_ID, LANGUAGE) and confirms this composite as the table's business-key candidate.

The principal descriptive column is OPINION_VALUE_NAME, which contains the translated opinion value text displayed in the user interface for the given LANGUAGE. SOURCE_LANG identifies the source language from which translations were derived or seeded, supporting the standard EBS multi-language translation model. LANGUAGE records the specific installed language of the row.

The remaining columns are standard EBS audit and concurrency attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture who created and last modified the row and when, while OBJECT_VERSION_NUMBER supports optimistic locking during concurrent updates. SECURITY_GROUP_ID is a foreign key to FND_SECURITY_GROUPS, enforcing the multi-tenant security model used throughout the AMW product to isolate data by security group. In total, the documented 12.1.1 schema contains eleven columns.

Common Use Cases and Queries

The most frequent use of this table is translation-aware reporting: joining AMW_OPINION_VALUES_TL to AMW_OPINION_VALUES_B to retrieve an opinion value's code or internal identifier alongside its localized display name. A typical pattern constrains LANGUAGE to the session or reporting language and applies the security group filter:

• SELECT b.opinion_value_id, t.opinion_value_name FROM amw_opinion_values_b b, amw_opinion_values_tl t WHERE b.opinion_value_id = t.opinion_value_id AND t.language = USERENV('LANG') AND b.security_group_id = :security_group_id;
• Value-set validation: exposing the ordered list of valid opinion values for LOV or picklist population in control test and certification pages.
• Audit and translation completeness analysis: identifying opinion values that lack a translation for a given language by comparing the base and translation tables.
• Localization diagnostics: querying rows by SOURCE_LANG to verify seeded versus customer-supplied translations.

Reports that summarize control assessment outcomes by opinion value should always join through the base table and filter by LANGUAGE to avoid duplicate rows where multiple translations exist.

Related Objects

The following objects are the most significant dependencies and references for AMW_OPINION_VALUES_TL:

• AMW_OPINION_VALUES_B — the base table joined on OPINION_VALUE_ID; supplies language-independent attributes.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; governs row visibility by security group.
• FND_LANGUAGES — the installed-language definition referenced by the LANGUAGE and SOURCE_LANG columns.
• AMW_OPINION_VALUES_TL_PK and AMW_OPINION_VALUES_TL_U1 — the primary key constraint and the unique index supporting the composite key.
• AMW control test and certification transaction tables that consume opinion values as lookup references for assessment results.
• FND_USER — indirectly referenced through the CREATED_BY and LAST_UPDATED_BY audit columns.

Because AMW objects are not part of the public Oracle EBS API surface, customization should be limited to query and reporting access rather than direct data manipulation.