Results for “amw_object_opinion_types_pk”

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

Overview

AMW_OBJECT_OPINION_TYPES is a configuration table owned by the AMW schema within the Oracle E-Business Suite Internal Controls Manager (ICM) module. It defines the association between a registered application object and the opinion types that may be recorded against it. In effect, the table answers the question: "For this object, which opinions are valid?" This is foundational metadata for the ICM opinion framework, enabling the application to present the correct set of opinion values when a user records an assessment, certification, or audit conclusion against a specific object.

The AMW module relies on FND_OBJECTS as its registry of certifiable or assessable business entities; AMW_OBJECT_OPINION_TYPES binds those entities to the opinion taxonomy held in AMW_OPINION_TYPES_B. The table is therefore a bridge or junction artifact that participates in the broader opinion hierarchy used by ICM engagements and certifications.

From a Data Vault modeling perspective, the mined FK structure classifies this object as satellite-leaning. Practically, it behaves as a reference or link table: the primary key OBJECT_OPINION_TYPE_ID is a synthetic identifier, while the meaningful business relationship is captured by the pairing of OBJECT_ID and OPINION_TYPE_ID. Modelers may choose to treat it as a link between object and opinion-type hubs, with the function-reference columns as descriptive satellite attributes.

Key Information Stored

The table contains twelve documented columns. The most significant are:

• OBJECT_OPINION_TYPE_ID — The surrogate primary key, enforced by AMW_OBJECT_OPINION_TYPES_PK and also uniquely indexed by AMW_OBJECT_OPINION_TYPES_U1.
• OBJECT_ID — Foreign key to FND_OBJECTS, identifying the application object to which the opinion type is attached.
• OPINION_TYPE_ID — Foreign key to AMW_OPINION_TYPES_B, identifying the opinion type definition.
• VIEW_FUNCTION_ID — Reference to a function used to control or render the view behavior for this object/opinion combination.
• PERFORM_FUNCTION_ID — Reference to the function invoked when the opinion action is performed for the object.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or operating-unit scoping.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit/who columns populated by the framework.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework (OAF) to detect concurrent updates.

The business-key candidate is the composite unique index AMW_OBJECT_OPINION_TYPES_U2 on (OBJECT_ID, OPINION_TYPE_ID), which prevents duplicate object-to-opinion-type assignments. The surrogate U1 index on OBJECT_OPINION_TYPE_ID supports primary key lookups.

Common Use Cases and Queries

Typical usage includes setup validation before an ICM engagement, determining which opinions are enabled for a given object, and generating configuration reports. A representative query to list valid opinion types for an object joins back to the opinion type definition:

• SELECT oot.object_opinion_type_id, oot.object_id, ot.name opinion_type FROM amw_object_opinion_types oot, amw_opinion_types_b ot WHERE oot.opinion_type_id = ot.opinion_type_id AND oot.object_id = :object_id;
• Identify orphan configuration: SELECT * FROM amw_object_opinion_types oot WHERE NOT EXISTS (SELECT 1 FROM fnd_objects fo WHERE fo.object_id = oot.object_id);
• Audit recent setup changes using LAST_UPDATED_BY and LAST_UPDATE_DATE filtered by a date range.

Because the table underpins opinion capture, misconfigured rows can cause opinions to be unavailable or displayed incorrectly at runtime, making it a frequent target during implementation troubleshooting.

Related Objects

• AMW_OPINION_TYPES_B — Joined on OPINION_TYPE_ID; holds the opinion type definition.
• FND_OBJECTS — Joined on OBJECT_ID; the registry of certifiable business objects.
• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID; provides security scoping.
• AMW_OPINIONS — Child table referencing OBJECT_OPINION_TYPE_ID; stores recorded opinions.
• AMW_OPINION_COMPONTS_B — References OBJECT_OPINION_TYPE_ID; defines opinion components for each object/opinion type.
• AMW_OPINIONS_LOG — Audit trail referencing OBJECT_OPINION_TYPE_ID; captures historical opinion records.