Search Results amw_violations

Overview

The AMW_VIOLATIONS table is a core data repository within the Oracle E-Business Suite module AMW (Internal Controls Manager), which is designated as obsolete in releases 12.1.1 and 12.2.2. Its primary function is to serve as the central audit log for constraint violation check requests. In the context of internal controls management, a constraint defines a business rule or policy, and a violation record is generated when a system check or user assessment identifies a non-conformance with that rule. This table systematically stores the results of these compliance checks, forming the foundational data layer for subsequent analysis, reporting, and remediation workflows within the obsolete Internal Controls Manager functionality.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond key identifiers, the table's description and relationships indicate it holds critical metadata for each violation instance. The primary identifier is the VIOLATION_ID, which is the table's primary key. A crucial foreign key is CONSTRAINT_REV_ID, which links each violation to the specific version of the control constraint (in AMW_CONSTRAINTS_B) that was evaluated. This ensures traceability to the exact business rule in effect at the time of the check. Other inferred data points likely stored include timestamps for when the violation was detected and logged, the status of the violation (e.g., open, in remediation, closed), and identifiers for the object or process that failed the constraint check.

Common Use Cases and Queries

The primary use case for the AMW_VIOLATIONS table is generating compliance and audit reports to identify control failures. Common queries would involve joining to related tables to produce meaningful listings. For instance, a report showing all open violations with their corresponding constraint details would be fundamental. A sample SQL pattern for such a report might be:

SELECT v.VIOLATION_ID, c.CONSTRAINT_NAME, v.CREATION_DATE
FROM AMW_VIOLATIONS v,
     AMW_CONSTRAINTS_B c
WHERE v.CONSTRAINT_REV_ID = c.CONSTRAINT_REV_ID
AND v.STATUS = 'OPEN';

Another critical use case is tracking the lifecycle of a violation by joining to its related response and assignment tables to see remediation actions and responsible parties.

Related Objects

The AMW_VIOLATIONS table sits at the center of a key relationship model within the obsolete AMW schema. The documented foreign key relationships are as follows:

• References (Parent Table): AMW_CONSTRAINTS_B via the column AMW_VIOLATIONS.CONSTRAINT_REV_ID. This links a violation to the specific control constraint that was violated.
• Referenced By (Child Tables):
  • AMW_VIOLATION_RESP: Linked via AMW_VIOLATION_RESP.VIOLATION_ID. This table stores responses and remediation plans for each recorded violation.
  • AMW_VIOLATION_USERS: Linked via AMW_VIOLATION_USERS.VIOLATION_ID. This table manages the assignment of violations to specific users for action or acknowledgment.

These relationships create a complete data model for logging a control failure (AMW_VIOLATIONS), assigning it (AMW_VIOLATION_USERS), and managing its resolution (AMW_VIOLATION_RESP).