Search Results amw_ap_associations




Overview
Explore in AI Chat

Overview

AMW_AP_ASSOCIATIONS is a table in the Oracle E-Business Suite module AMW — Internal Controls Manager, a component historically used for documenting, evaluating, and certifying internal controls in support of regulatory compliance initiatives such as Sarbanes-Oxley. The table's documented purpose is to hold information about audit procedure associations, meaning it links audit procedures to the business objects, processes, or control definitions they are intended to evaluate. In practice, it functions as the connective layer between the definition of an audit procedure and the specific subject matter to which that procedure applies.

The ETRM metadata classifies this object with a heuristic Data Vault label of standalone. As a modeling suggestion, this indicates that AMW_AP_ASSOCIATIONS does not present the characteristics of a classic hub or link, and that its relationships are largely reflected through descriptive attributes and foreign-key references rather than through a shared business-key structure. It is important to note that the metadata records the object as "Not implemented in this database," meaning it exists in the documented schema definition but may not be physically present or populated in every environment. Its product is also marked obsolete, so references to it are primarily of historical or upgrade-analysis interest.

Key Information Stored

AMW_AP_ASSOCIATIONS is documented with 38 columns, with the following being the most operationally significant:

Common Use Cases and Queries

Because the module is obsolete, the primary use cases involve historical reporting and migration analysis. A typical query joins the association to its procedure revision to retrieve effectiveness assessments:

SELECT a.ap_association_id, a.audit_procedure_id, a.audit_procedure_rev_id,
       a.design_effectiveness, a.op_effectiveness, a.approval_date
FROM   amw_ap_associations a
WHERE  a.security_group_id = :security_group_id
AND    a.deletion_date IS NULL;

Analysts frequently filter on the lifecycle dates to identify active versus deleted associations, or group by OBJECT_TYPE to report coverage of audit procedures across object categories. Joining to FND_SECURITY_GROUPS supports security-scoped extracts, while effectiveness columns are commonly used to summarize control assessment results.

Related Objects

  • AMW_AUDIT_PROCEDURES_B — referenced via AUDIT_PROCEDURE_REV_ID; holds the audit procedure definitions.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; provides security group context.
  • AMW_AUDIT_PROCEDURE_INTERFACE — references AMW_AP_ASSOCIATIONS through its AP_ASSOCIATION_ID column, supporting interface or staging processes.
  • AMW_AP_ASSOCIATIONS_PK — the primary key constraint on AP_ASSOCIATION_ID.
  • AMW_AP_ASSOCIATIONS_U1 — the unique index on AP_ASSOCIATION_ID.