Search Results amw_export_ctrl_v




Overview
Explore in AI Chat

Overview

AMW_EXPORT_CTRL_V is a reporting view within the Oracle E-Business Suite Internal Controls Manager (AMW) module. Its purpose is to flatten and decode control master data for export and reporting purposes, resolving foreign keys into descriptive lookup meanings so that consumers do not need to join multiple AMW_LOOKUPS, FND_APPLICATION, PER_JOBS, and PER_BUSINESS_GROUPS tables themselves. The naming convention ("EXPORT") and column aliases (short codes such as CID, CRID, CNM, CAPP) indicate the view was designed to feed external extracts or interface programs, producing a denormalized, human-readable dataset of control definitions.

It is important to note that AMW is flagged as Obsolete in the ETRM documentation for 12.1.1 and 12.2.2, and the metadata explicitly states the view is "Not implemented in this database." This means the view, while still defined in the data dictionary, is no longer actively populated or supported in current releases. References to it should be treated as legacy. The user search term "objective_code" reflects a recurring need to identify control objectives; however, this view does not expose an OBJECTIVE_CODE column directly — objective data is referenced elsewhere in the AMW data model (for example via AMW_CONTROL_OBJECTIVES or related objective tables).

Underlying Base Objects

The view text defines it over two primary AMW base tables:

Supporting lookups resolve status values: AMW_LOOKUPS (for AMW_CONTROL_APPROVAL_STATUS, AMW_CONTROL_LOCATION, AMW_CONTROL_TYPE, AMW_AUTOMATION_TYPE, AMW_VERIFICATION_SOURCE, AMW_CONTROL_FREQUENCY), FND_APPLICATION, PER_BUSINESS_GROUPS, and PER_JOBS. The documented referenced base objects list is empty, so these relationships are derived from the embedded view SQL rather than from formal metadata.

Key Columns

  • CID / CRID / CRNM — Control ID, control revision ID, and revision number; the identity of a specific control version.
  • CNM / CDS — Control name and description from the translation table.
  • CAPP / CAPDT — Approval status meaning and approval date.
  • CLOC / CTYP / CAUT — Resolved meanings for control location, control type, and automation type.
  • CAPL — Application short name, linking the control to an EBS application.
  • CBGR / CJOB — Business group name and job name.
  • CPRV / CDET / CDIS / CKEY — Flags for preventive, detective, and disclosure controls and key mitigating classification.
  • CVSO / CVNM / CVIN — Verification source meaning, verification source name, and verification instruction.
  • CPEV — Physical evidence description.

Common Use Cases and Queries

Typical use is to extract control inventories for audit, SOX reporting, or migration to an external GRC platform. A representative query:

SELECT cid, cnm, cloc, ctyp, caut, capp, capdt, cjob, cbgr
FROM   amw_export_ctrl_v
WHERE  capp = 'Approved'
AND    cend IS NULL
ORDER BY cnm;

Because the view pre-resolves lookups, it avoids repetitive joins for status and type descriptions. Where objective_code is required, the consumer must join separately to the AMW objective tables, as this view does not carry objective data. Given the obsolete status and the "Not implemented" note, queries should be validated against the specific environment before being relied upon in production reporting.