Search Results amw_wf_hierarchy_pkg




Overview
Explore in AI Chat

Overview

AMW_WF_HIERARCHY_PKG is an Oracle EBS Applications (APPS) PL/SQL package that supports the Oracle Application Management Workbench (AMW) framework, the technical foundation for Applications Management and the governance, risk, and compliance (GRC) capabilities introduced with the E-Business Suite. Its primary role is to construct, synchronize, and traverse the hierarchical relationships that underpin the AMW process model — linking processes, organizations, risks, and controls in a parent/child graph. The package also integrates AMW metadata with Oracle Workflow, allowing the hierarchy to drive workflow routing and transition sequencing.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package belongs to the APPS schema and is classified under the "OTHER" API category in the E-Business Tax and Reference Manual (ETRM) repository. It is referenced by five other packages, indicating it is a shared dependency in the AMW hierarchy subsystem rather than a standalone utility.

Key Procedures and Functions

The documented interface exposes 43 procedures and functions. Central to authoring hierarchy metadata is WRITE_AMW_PROCESS, which persists process definitions including process name, significant and standard process flags, approval and certification status, and owner identifiers. Hierarchy traversal is handled by FIND_HIERARCHY_PARENT and FIND_HIERARCHY_CHILDREN, which resolve process relationships in the denormalized hierarchy tables.

Synchronization routines SYNCH_HIERARCHY_AMW_PROCESS and ADHOC_SYNCH_HIER_AMW_PROC (note the truncated name in the header) refresh the stored hierarchy to reflect current process definitions, both as a batch and on demand.

Workflow sequencing is addressed by the function searched for: FIND_TRANSITION_ORDER, which accepts an instance identifier and returns a numeric transition order value, and FIND_TRANSITION_CHILDREN, which resolves the child transitions for a given instance.

Organization-level hierarchy is managed by FIND_ORG_HIERARCHY_PARENT and FIND_ORG_HIERARCHY_CHILDREN, POPULATE_FLATLIST, CREATE_ORG_RELATIONS, ASSOC_PROCESS_ORG_HIER, ASSOC_PROCESS_RCM_ORG_HIER, ASSOCIATE_ORG_PROCESS, DELETE_ORG_RELATION, DISASSOCIATE_PROCESS_ORG, DISASSOC_PROC_ORG_HIER, and MODIFY_ORG_RELATION. Risk and control counters are reset by RESET_PROCESS_RISK_CTRL_COUNT and the two overloaded forms of RESET_PROC_ORG_RISK_CTRL_COUNT.

Tables Accessed

The package reads and writes a set of AMW base and denormalized tables through APPS synonyms. Process definitions reside in AMW_PROCESS, AMW_PROCESS_S, and AMW_PROCESS_ORGANIZATION. Hierarchy structures are held in AMW_PROC_HIERARCHY_DENORM and AMW_ORG_HIERARCHY_DENORM, while AMW_PROCESS_ORG_RELATIONS stores organization-to-process links. Risk, control, and exception associations are captured in AMW_CONTROL_ASSOCIATIONS, AMW_RISK_ASSOCIATIONS, AMW_EXCEPTIONS_B, AMW_EXCEPTIONS_TL, and AMW_EXCEPTIONS_REASONS. AMW_OBJECTIVE_ASSOCIATIONS links processes to objectives. Oracle HR and security master data are referenced via FND_USER, HR_ORGANIZATION_INFORMATION, and PER_ORGANIZATION_STRUCTURES to resolve organizational ownership and reporting lines.

Usage Notes

AMW_WF_HIERARCHY_PKG is typically invoked indirectly rather than by end users. It is called by AMW forms and concurrent programs during process definition, hierarchy rebuild, and synchronization operations, and by Oracle Workflow components when evaluating transition order and routing. Because the hierarchy is denormalized, the synchronization procedures should be run after bulk changes to process or organization structures to keep the denormalized tables consistent. Custom code integrating with AMW should treat the package as a shared internal dependency and avoid modifying the underlying hierarchy tables directly.