Search Results amw_audit_procedures_b

Overview

The AMW_AUDIT_PROCEDURES_B table is a core data object within the Oracle E-Business Suite (EBS) Internal Controls Manager (AMW) module. It serves as the base table for storing the master, non-translatable information for audit procedures. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the governance, risk, and compliance (GRC) framework, enabling organizations to define, document, and manage the specific tests and steps performed during internal control audits. Its primary role is to act as the central repository for the procedural definition of an audit, which is then referenced throughout the control testing and compliance monitoring lifecycle.

Key Information Stored

While the provided ETRM metadata does not list specific column details, the structure and naming conventions of Oracle EBS tables provide strong indicators. As a base table ('_B' suffix), AMW_AUDIT_PROCEDURES_B typically holds the primary key and core attributes for an audit procedure entity. The documented primary key is AUDIT_PROCEDURE_REV_ID, which uniquely identifies each revision of an audit procedure record. Common columns expected in such a table, based on Oracle EBS design patterns, would include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and a LAST_UPDATE_LOGIN column. It likely also contains critical foreign keys, such as one linking to the associated control or risk, and status fields to manage the procedure's lifecycle (e.g., DRAFT, ACTIVE, INACTIVE). The actual descriptive, user-facing name of the procedure is stored in the related translation table, AMW_AUDIT_PROCEDURES_TL.

Common Use Cases and Queries

This table is central to reporting and data extraction for internal audit activities. Common use cases include generating a master list of all defined audit procedures for a compliance cycle, integrating control test data with external GRC systems, and analyzing procedure assignment coverage. A fundamental query involves joining the base table with its translation table to retrieve a complete, language-specific record.

SELECT b.audit_procedure_rev_id,
       tl.name,
       tl.description,
       b.creation_date,
       b.created_by
FROM amw_audit_procedures_b b,
     amw_audit_procedures_tl tl
WHERE b.audit_procedure_rev_id = tl.audit_procedure_rev_id
AND tl.language = USERENV('LANG')
AND b.status = 'ACTIVE';

Another critical use case is tracing the relationship between audit procedures and their execution results or findings, which would involve joins to other AMW transaction tables not listed in the provided metadata.

Related Objects

The documented relationship data specifies a direct foreign key dependency with the AMW_AUDIT_PROCEDURES_TL table. This is a standard Oracle EBS multilingual architecture pattern.

• AMW_AUDIT_PROCEDURES_TL: This is the translation table that holds the language-specific names and descriptions for the audit procedures defined in the base table. The tables are joined on the primary key column: AMW_AUDIT_PROCEDURES_B.AUDIT_PROCEDURE_REV_ID = AMW_AUDIT_PROCEDURES_TL.AUDIT_PROCEDURE_REV_ID.

In a full implementation, AMW_AUDIT_PROCEDURES_B would also have relationships with tables storing control definitions (AMW_CONTROLS_B), risk assessments, and audit execution evidence, forming the complete internal controls data model.