Results for “ap_association_id”

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

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:

• AP_ASSOCIATION_ID — the surrogate primary key, enforced by the AMW_AP_ASSOCIATIONS_PK constraint and also supported by the unique index AMW_AP_ASSOCIATIONS_U1.
• AUDIT_PROCEDURE_ID and AUDIT_PROCEDURE_REV_ID — identify the audit procedure and its specific revision to which the association applies. The revision column carries a foreign key to AMW_AUDIT_PROCEDURES_B.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, controlling which security group can access the association record.
• OBJECT_TYPE — categorizes the type of object with which the audit procedure is associated.
• DESIGN_EFFECTIVENESS and OP_EFFECTIVENESS — record the assessed design effectiveness and operating effectiveness of the associated control or procedure.
• ASSOCIATION_CREATION_DATE, APPROVAL_DATE, DELETION_DATE, and DELETION_APPROVAL_DATE — lifecycle dates tracking when the association was created, approved, deleted, or had its deletion approved.
• OBJECT_VERSION_NUMBER — supports optimistic locking during concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard "Who" audit columns.

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.