Search Results violat_resp_entry_id

Overview

The AMW_VIOLAT_RESP_ENTRIES table is a core data object within the Oracle E-Business Suite (EBS) Internal Controls Manager (AMW) module. Its primary function is to store granular details of specific incompatible functions that are accessible from a given responsibility, thereby enabling the enforcement of segregation of duties (SoD) and other access control policies. This table operates as a child table, holding the detailed line items for a broader violation instance recorded in the AMW_VIOLATION_RESP table. Its existence is critical for audit trails, compliance reporting, and remediation workflows, as it provides the specific evidence of which functions constitute a policy violation for a user's assigned responsibility.

Key Information Stored

The table's structure is designed to link a violation instance to the specific application functions involved. While the full column list is not detailed in the provided metadata, the documented relationships and primary key reveal its essential components. The primary key column, VIOLAT_RESP_ENTRY_ID, uniquely identifies each entry. The foreign key column, RESP_VIOLATION_ID, links each entry to its parent violation record in the AMW_VIOLATION_RESP table. Other columns, inferred from its description of storing "details of incompatible functions," would typically include identifiers for the specific function (likely FUNCTION_ID), potentially the application it belongs to, and possibly metadata about the conflict such as the risk policy or rule that was violated.

Common Use Cases and Queries

This table is central to generating detailed violation reports and driving remediation actions. Common use cases include listing all specific function conflicts for a particular user or responsibility, aggregating violation counts by risk type, and providing evidence for access revocation decisions. A typical analytical query would join this table to its parent and to function/application descriptive tables.

• Detailed Violation Report: SELECT avre.*, fv.USER_FUNCTION_NAME FROM AMW_VIOLAT_RESP_ENTRIES avre, AMW_VIOLATION_RESP avr, FND_FORM_FUNCTIONS_VL fv WHERE avre.RESP_VIOLATION_ID = avr.RESP_VIOLATION_ID AND avre.FUNCTION_ID = fv.FUNCTION_ID AND avr.RESPONSIBILITY_ID = :resp_id;
• Violation Summary by Responsibility: Queries often group by RESP_VIOLATION_ID from this table and join to AMW_VIOLATION_RESP to count the number of distinct incompatible function entries per responsibility.

Related Objects

The table has defined dependencies within the AMW schema, primarily serving as a detail table to a master violation record.

• AMW_VIOLATION_RESP: This is the primary parent table. The relationship is enforced by the foreign key where AMW_VIOLAT_RESP_ENTRIES.RESP_VIOLATION_ID references AMW_VIOLATION_RESP. This table stores the header information for a responsibility-level violation, such as the responsibility ID, user ID, and the date the violation was detected.
• The table is also likely referenced by AMW-specific views and packages that generate compliance reports and dashboards, though these are not explicitly listed in the provided metadata.