Search Results audit_result_code




Overview
Explore in AI Chat

Overview

AMW_OPINIONS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite module AMW – Internal Controls Manager (ICM). Its documented description is simply “Opinions View,” and the object carries a VALID status in the ETRM 12.1.1 / 12.2.2 metadata. The view consolidates opinion records captured against control objects so that assessments, audit results, and their associated authors can be reported in a denormalized, ready-to-query form.

In the ICM data model, opinions are stored in normalized transactional tables: an opinion header (AMW_OPINIONS), the object-to-opinion-type linkage (AMW_OBJECT_OPINION_TYPES), opinion type definitions (AMW_OPINION_TYPES_B), opinion component definitions (AMW_OPINION_COMPONTS_B), opinion detail rows (AMW_OPINION_DETAILS), and opinion value lookups (AMW_OPINION_VALUES_B / AMW_OPINION_VALUES_TL). AMW_OPINIONS_V joins these together and resolves the “OVERALL” opinion component into a human-readable audit result, making it the natural reporting surface for internal control assessments rather than the base tables. It functions as a read-only integration and reporting layer exposed to BI Publisher, OBIEE/OBIA, and custom SQL.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text embedded in the documentation defines its FROM clause explicitly. AMW_OPINIONS_V is defined over:

  • AMW_OPINIONS (AO) — the opinion header table and primary driver of the query.
  • AMW_OBJECT_OPINION_TYPES (AOOT) and AMW_OPINION_TYPES_B (AOT) — resolve the opinion type code (e.g., EFFECTIVE).
  • FND_OBJECTS (FO) — supplies the OBJ_NAME of the object an opinion applies to.
  • AMW_OPINION_VALUES_B (AOVB) and AMW_OPINION_VALUES_TL (AOVTL) — provide the opinion value code and its translated name, joined by LANGUAGE = USERENV('LANG').
  • AMW_OPINION_DETAILS and AMW_OPINION_COMPONTS_B — correlated subqueries restrict results to the component with OPINION_COMPONENT_CODE = 'OVERALL'.
  • FND_USER (FU), PER_ALL_PEOPLE_F (PAPF) — resolve the authoring user to an employee and full name.

Notably, the join to PER_ALL_PEOPLE_F applies TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE, so only the currently effective person record is returned. The view also references the profile option AMW_OPINION_DISPLAY_OPTION via FND_PROFILE.VALUE, which influences image resolution for the EFFECTIVE opinion value.

Key Columns

Common Use Cases and Queries

The view is typically queried for internal control dashboards, audit opinion listings, and integration extracts. A representative query returns the overall audit result per object instance:

  • SELECT OBJECT_NAME, OPINION_TYPE_CODE, AUDIT_RESULT, AUTHOR, AUTHORED_DATE FROM AMW_OPINIONS_V;
  • Filter to a specific result: ... WHERE AUDIT_RESULT_CODE = 'EFFECTIVE';
  • Restrict by object instance using PK columns: ... WHERE PK1_VALUE = :p_value;
  • Scope to a security group: ... WHERE SECURITY_GROUP_ID = :sg_id;

As a locale-sensitive, profile-dependent view, results vary by the session language and the AMW_OPINION_DISPLAY_OPTION setting, which should be accounted for in any reporting or integration logic.