Search Results igw_prop_maps

Overview

The IGW_PROP_MAPS table is a core data object within the Oracle E-Business Suite (EBS) Grants Proposal module (IGW). It serves as the central repository for defining and storing approval maps. An approval map is a structured workflow path that dictates the sequence of notifications and routing required for a specific grant proposal to progress through its approval lifecycle. The table's primary role is to manage the procedural framework for proposal approvals, linking a specific approval process run to its defined sequence of approval stops or stages.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical structure. The table's unique identifier is the PROP_MAP_ID column, which serves as the primary key. This ID is the fundamental link to all related approval workflow data. A second crucial column is RUN_ID, a foreign key that ties each approval map to a specific instance of an approval process execution recorded in the IGW_PROP_APPROVAL_RUNS table. This relationship ensures each map is contextual to a particular proposal's approval cycle. Other columns in the table would logically store metadata about the map itself, such as creation date, status, and potentially a map type or description.

Common Use Cases and Queries

This table is central to querying the approval workflow status and history of grant proposals. Common use cases include generating reports to track which proposals are in the approval pipeline, auditing the approval path for a specific proposal, and troubleshooting workflow issues. A typical query would join IGW_PROP_MAPS to the approval runs and proposal headers to list active maps. For example:

• Identifying the approval map for a specific proposal run:

  SELECT map.prop_map_id, run.proposal_id
  FROM igw_prop_maps map,
       igw_prop_approval_runs run
  WHERE map.run_id = run.run_id
  AND run.proposal_id = :p_proposal_id;

• Auditing all approval stops defined within a map:

  SELECT map.prop_map_id, stops.stop_sequence, stops.approver_id
  FROM igw_prop_maps map,
       igw_prop_map_stops stops
  WHERE map.prop_map_id = stops.prop_map_id
  ORDER BY map.prop_map_id, stops.stop_sequence;

Related Objects

The IGW_PROP_MAPS table sits at the center of a key relationship chain for proposal approvals, as documented by its foreign key constraints.

• References (Parent Table): IGW_PROP_APPROVAL_RUNS. The RUN_ID column in IGW_PROP_MAPS is a foreign key to IGW_PROP_APPROVAL_RUNS, linking each map to a specific approval process execution instance.
• Referenced By (Child Table): IGW_PROP_MAP_STOPS. The PROP_MAP_ID column in IGW_PROP_MAP_STOPS is a foreign key back to IGW_PROP_MAPS.PROP_MAP_ID. This one-to-many relationship defines the individual approval stages (stops) that constitute the complete map.

This structure confirms that IGW_PROP_MAPS is the master definition for an approval route, which is initiated by a run (IGW_PROP_APPROVAL_RUNS) and executed through a series of steps (IGW_PROP_MAP_STOPS).