Search Results view_function_id

Overview

The AMW_OBJECT_OPINION_TYPES table is a core reference table within the Oracle E-Business Suite (EBS) Application Management (AMW) module, specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction table that defines the permissible types of opinions or assessments that can be recorded for specific business objects within the system. Its primary role is to establish and enforce a controlled relationship between application entities (from FND_OBJECTS) and the defined opinion classifications (from AMW_OPINION_TYPES_B). This table is fundamental to the AMW module's functionality for risk management, control assessment, and audit tracking, as it governs what kind of feedback or evaluation can be attached to a given object.

Key Information Stored

The table stores the mapping relationship along with associated security and auditing metadata. The most critical columns include:

• OBJECT_OPINION_TYPE_ID: The primary key and unique identifier for each mapping record.
• OBJECT_ID: A foreign key referencing FND_OBJECTS. This identifies the specific application entity (e.g., a process, risk, or control) to which an opinion type can be applied.
• OPINION_TYPE_ID: A foreign key referencing AMW_OPINION_TYPES_B. This identifies the specific classification of opinion (e.g., Design Assessment, Operating Effectiveness) that is allowed for the linked object.
• VIEW_FUNCTION_ID and PERFORM_FUNCTION_ID: These columns link to function security (FND_FORM_FUNCTIONS), controlling which users can view or create opinions of this type for the associated object, thereby enforcing data security at a granular level.
• Standard Who Columns (CREATED_BY, CREATION_DATE, etc.): Provide audit trail information for each record.

Common Use Cases and Queries

This table is central to queries that determine valid opinion entry points or audit the configuration of the assessment framework. A common use case is to retrieve all opinion types available for a specific business object, such as a particular control, to drive user interface options in an assessment form. Another scenario involves administrative reporting to review the security setup linking functions to opinion types.

Sample SQL to find all configured opinion types for a known OBJECT_ID (e.g., 1001):

SELECT aot.object_id,
       aot.opinion_type_id,
       ot.opinion_type_name,
       aot.view_function_id,
       aot.perform_function_id
FROM amw_object_opinion_types aot,
     amw_opinion_types_b ot
WHERE aot.opinion_type_id = ot.opinion_type_id
  AND aot.object_id = 1001
ORDER BY ot.opinion_type_name;

This table is also essential for any data migration or setup scripts when implementing or extending the AMW module's assessment capabilities.

Related Objects

AMW_OBJECT_OPINION_TYPES sits at the center of several key relationships, as documented in the provided metadata:

• Referenced Foreign Keys (Parent Tables):
  • FND_OBJECTS via the OBJECT_ID column. This provides the list of all application entities.
  • AMW_OPINION_TYPES_B via the OPINION_TYPE_ID column. This provides the list of valid opinion classifications.
• Referencing Foreign Keys (Child Tables):
  • AMW_OPINIONS via OBJECT_OPINION_TYPE_ID. This is the primary transactional table where actual opinion data is stored, dependent on this configuration.
  • AMW_OPINION_COMPONENTS_B via OBJECT_OPINION_TYPE_ID. This table stores sub-component or detailed questions linked to an opinion type for an object.
• Materialized Views: The table is referenced by AMW_OPINION_LOG_MV and AMW_OPINION_MV, indicating its importance for performance and reporting within the module.