Search Results amw_certification_status




Overview
Explore in AI Chat

Overview

APPS.AMW_WF_ORG_HIERARCHY_MAIN_V is a reporting and integration view within the Oracle E-Business Suite Applications Manager (AMW/E-TRM) module, which provides the governance, risk, and compliance framework underpinning Oracle Workflow-driven process management. The view exposes a flattened, denormalized representation of the organizational hierarchy of AMW processes as they are deployed across process organizations, combined with their associated Oracle Workflow activity definitions and current approval and certification states.

Its primary role is to present a single, query-friendly row per process node, joining the Workflow process/activity structure (parent-to-child relationships) to the AMW process organization definition and lookup-driven status meanings. This makes it suitable for operational dashboards, process certification tracking, and reporting on control and risk coverage across an organization's process hierarchy. Because the view surfaces certification_status and its decoded meaning, it is a natural starting point for queries monitoring process certification.

Underlying Base Objects

Based on the documented view text, the view draws from the following objects:

  • WF_PROCESS_ACTIVITIES (aliased wpa) — provides the parent process name/type and child process (activity) name/type, defining hierarchy edges.
  • WF_ACTIVITIES (aliased wapr) — the Workflow activity definition referenced in the join.
  • AMW_PROCESS (aliased amwp1 and amwp2) — supplies parent_process_id and child_process_id, resolving the Workflow activities to AMW process records.
  • AMW_PROCESS_ORG_BASICINFO_V (aliased ampo) — the core process organization view supplying organizational context (organization_id, audit unit, display name), process attributes, risk and control counts, ownership, and certification status.
  • AMW_LOOKUPS (aliased amwlkup) — decodes the certification_status code into a meaningful display value.

The view also invokes the package function AMW_WF_HIERARCHY_PKG.find_transition_order(instance_id), which computes a reverse transition ordering used to sequence hierarchy nodes. No base tables are separately documented in the ETRM metadata, so the join semantics are inferred from the view body itself.

Key Columns

Common Use Cases and Queries

The view supports process hierarchy reporting, certification-status monitoring, and drill-down navigation to process details. A typical certification report:

  • Listing processes with their certification status for a given process organization.
  • Identifying significant processes that remain uncertified.
  • Reviewing risk and control coverage per hierarchy node.

A representative query:

SELECT process_org_id,
       org_id,
       org_name,
       name,
       significant_process_flag,
       certification_status_code,
       certification_status,
       risk_count,
       control_count
FROM   apps.amw_wf_org_hierarchy_main_v
WHERE  certification_status <> 'Certified'
AND    significant_process_flag = 'Y';

Because the view exposes URLString columns, it is also used by OAF-based pages to build process detail links, making it valuable both for direct SQL reporting and for embedding within AMW application flows.