Search Results amw_process_org_relations




Overview
Explore in AI Chat

Overview

The AMW_PROCESS_ORG_RELATIONS table is a core data object within the Oracle EBS Internal Controls Manager (AMW) product module. As its description states, the table holds the process hierarchy in organizations, storing the parent-child relationships that define how business processes are structured and decomposed across an enterprise. This hierarchical model is fundamental to Internal Controls Manager, because controls, risks, and audit procedures are typically associated with specific nodes in a process tree. The table permits processes to be nested, so a high-level process can contain sub-processes that themselves contain further sub-processes, mirroring the way organizations describe business cycles such as Order to Cash or Procure to Pay.

From a Data Vault modeling perspective, the heuristic classification for this object is standalone, meaning it does not participate in a strong hub-link-satellite dependency network within the mined foreign-key structure. It is best regarded as a link-style table that resolves a many-to-many or recursive association between parent processes and child processes, with additional descriptive and auditing attributes carried in the same row. This classification is offered as a modeling suggestion, not an enforced constraint.

Key Information Stored

The table contains twelve documented columns. The most significant are:

The documented metadata does not identify a single surrogate primary key column; the effective business key is the combination of ORGANIZATION_ID, PARENT_PROCESS_ID, CHILD_PROCESS_ID, and INSTANCE_ID, which together uniquely describe a hierarchical edge. The only documented foreign key is the reference from SECURITY_GROUP_ID to FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical use cases include reconstructing process trees for audit scoping, identifying orphaned or unreferenced processes, and reporting on exception conditions. A recursive query is commonly used to traverse the hierarchy. For example, retrieving all children of a given parent process:

SELECT CHILD_PROCESS_ID, EXCEPTION_PRESENT_FLAG
FROM   AMW_PROCESS_ORG_RELATIONS
WHERE  ORGANIZATION_ID = :org_id
AND    PARENT_PROCESS_ID = :parent_id;

Reporting queries frequently join to process definition tables to obtain process names and to FND_SECURITY_GROUPS to validate the security context. Exception dashboards filter on EXCEPTION_PRESENT_FLAG = 'Y'. Hierarchical extraction for audit documentation uses CONNECT BY PARENT_PROCESS_ID = PRIOR CHILD_PROCESS_ID to flatten the tree.

Related Objects

The most significant related object documented is FND_SECURITY_GROUPS, joined on SECURITY_GROUP_ID. Additional dependencies implied by the column semantics include the AMW process definition tables referenced by PARENT_PROCESS_ID and CHILD_PROCESS_ID, and the process instance structures referenced by INSTANCE_ID. Together these objects support the full process hierarchy that underpins Internal Controls Manager.