Search Results process_rev_id




Overview
Explore in AI Chat

Overview

AMW_PROCESS_ALL_VL is a view in the APPS schema belonging to the AMW – Internal Controls Manager product family. The ETRM metadata classifies this object explicitly as Obsolete, a status that carries immediate implications for any implementation or upgrade project targeting Oracle EBS 12.1.1 or 12.2.2. The view was originally designed to expose a denormalized, presentation-ready projection of process records maintained by the Internal Controls Manager module — the component historically used to document, certify, and monitor significant business processes and their associated risks and controls, typically as part of an SOX compliance program.

The "_VL" suffix conventionally denotes a "view with translation" pattern in EBS, indicating that the underlying column set surfaces descriptive, user-facing attributes (such as NAME) that would ordinarily join the base multilingual translation table. Although the documented view text shows a straight SELECT from AMW_PROCESS with no explicit translation join in the excerpt, the naming convention and column list confirm its intended role as a reporting-friendly interface layer. Because the object is flagged Obsolete, Oracle no longer supports it in current releases; the metadata should be treated as reference material for legacy code remediation rather than as a functional integration point.

Underlying Base Objects

The view text indicates a single documented base object: the AMW_PROCESS table. The SELECT statement projects the base table's columns directly, including its ROWID and the full set of standard EBS WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), the DFF columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15), the multi-org security column SECURITY_GROUP_ID, the concurrency columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the OAF-style optimistic locking column OBJECT_VERSION_NUMBER.

Notably, the ETRM metadata lists no additional referenced base objects beyond AMW_PROCESS. In a typical EBS 12.2.2 installation, AMW_PROCESS itself is a partitioned or non-partitioned table storing one row per process revision. The "ALL" component of the view name suggests it may have been intended to span multiple operating units or security groups, though the documented SQL does not include an organizational filter, and SECURITY_GROUP_ID is returned as a plain column. Legacy integrations that federated AMW data across business groups would have relied on this behavior.

Key Columns

  • PROCESS_REV_ID — The unique identifier for the process revision; this is the column most relevant to the user's search term and typically serves as the primary key used to join AMW sub-entities such as risks, controls, and certifications.
  • PROCESS_ID — Identifies the parent business process independently of its revision, allowing a process to be tracked across multiple revisions over time.
  • SIGNIFICANT_PROCESS_FLAG — Indicates whether the process was designated significant for scoping or certification purposes.
  • APPROVAL_STATUS / CERTIFICATION_STATUS — Workflow and compliance state indicators for the revision.
  • PROCESS_OWNER_ID — Reference to the responsible owner, typically resolved against a party or HR table.
  • NAME — The user-facing process name, the attribute that justifies the "_VL" translation-view convention.
  • CONTROL_COUNT / RISK_COUNT — Denormalized counters for the number of controls and risks attached to the revision, retained for reporting performance.
  • ITEM_TYPE, CREATED_FROM, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER — Supporting attributes for classification, provenance, access control, and concurrency.

Common Use Cases and Queries

In 12.1.1 and 12.2.2 deployments where the AMW module is still licensed, this view may have supported custom reports and extracts. A representative query retrieving process revisions by identifier is:

SELECT process_rev_id, process_id, name, approval_status, certification_status, control_count, risk_count FROM apps.amw_process_all_vl WHERE significant_process_flag = 'Y';

A second common pattern joins the view to certification or risk tables on PROCESS_REV_ID to build compliance dashboards. Given the Obsolete designation, however, the recommended remediation is to migrate such queries to the supported base table, AMW_PROCESS, or to the module's current successor objects. Implementations should confirm object availability in their specific patch level before relying on this view, as obsolete objects are frequently removed without replacement in later 12.2.x rollups.