Search Results child_process_category




Overview
Explore in AI Chat

Overview

AMW_MANAG_HIER_V is a database view belonging to the Oracle E-Business Suite product AMW – Internal Controls Manager, a module that has been marked obsolete in the ETRM (E-Business Suite Technical Reference Manual) documentation for releases 12.1.1 and 12.2.2. The view exposes the Organizations Managerial hierarchy — a flattened, read-only representation of the hierarchy that links Lines of Business (LOBs) and their subordinate organizations for use within the Internal Controls Manager application.

The view is better understood as a reporting and integration artifact rather than a transactional object. It consolidates rows sourced from the Oracle General Ledger Flexfields value sets associated with AMW Audit Units, presenting each LOB and organization as a node with a parent/child relationship. Because Internal Controls Manager itself is documented as obsolete, the view should be treated as a legacy construct retained for compatibility with existing customizations, extracts, and reporting.

Underlying Base Objects

Per the ETRM metadata, no base objects are explicitly documented as referenced, and the view text is the authoritative specification of its structure. The view is a UNION of two queries, both drawing on flexfield value set data:

The first branch of the UNION emits root-level LOB rows with all parent attributes set to NULL. The second branch joins FND_FLEX_VALUE_CHILDREN_V to two aliases of the flex values view (FVLP for parent, FVLC for child) to emit child rows carrying populated parent values. This design produces a single self-referencing hierarchy result set.

Key Columns

The view projects a consistent column list across both UNION branches, permitting downstream tools to query parent and child attributes uniformly:

  • FLEX_VALUE_SET_ID — identifies the flexfield value set that owns the node.
  • PARENT_VALUE, PARENT_ID, PARENT_DISPLAY_NAME — the parent node's value, surrogate ID, and description; NULL at the root.
  • CHILD_VALUE, CHILD_ID, CHILD_DISPLAY_NAME — the current node's value, ID, and description.
  • LINE_TYPE — hard-coded to 'LOB', indicating the hierarchy is LOB-oriented.
  • CHILD_ORGANIZATION_ID — the column the user searched for; in the documented view text it is always NULL. This signals that organization-level IDs are not resolved by this view and must be sourced elsewhere if required.
  • Additional CHILD_* attributes (process, control, risk, certification, approval, and audit-project counts) are all projected as NULL, forming a placeholder schema for applications expecting a wider column set.

Common Use Cases and Queries

Because the view presents a plain parent/child listing, it is typically used for hierarchy validation, LOB-to-organization mapping reports, and extracts feeding downstream risk or audit tooling. A basic listing of the hierarchy takes the following form:

SELECT flex_value_set_id,
       parent_value,
       parent_display_name,
       child_value,
       child_display_name
  FROM amw_manag_hier_v
 ORDER BY flex_value_set_id, parent_value, child_value;

To isolate root LOBs only:

SELECT *
  FROM amw_manag_hier_v
 WHERE parent_value IS NULL;

To find all children of a specific LOB value:

SELECT child_value, child_display_name
  FROM amw_manag_hier_v
 WHERE parent_value = :lob_value;

Callers attempting to retrieve CHILD_ORGANIZATION_ID will consistently receive NULL, so organization identifiers must be resolved via HR_ALL_ORGANIZATION_UNITS or an equivalent source keyed on the LOB flex value. Given the obsolete status of the AMW module, confirm that any consuming report is still supported in the target release before relying on this view.