Search Results igw_org_maps_all_u1

Overview

IGW.IGW_ORG_MAPS_ALL is a transactional configuration table within the Oracle E-Business Suite Grants and Proposal Management (IGW) application. It stores the proposal routing and notification maps defined for an organization. A map represents an ordered sequence of stops; each stop carries at least one primary approver and may optionally include one or more alternate approvers. The table therefore acts as the header or master record for the approval routing topology, while the individual stops attached to a map are held in the accompanying detail table.

The object is owned by the IGW schema, registered under FND Design Data as IGW.IGW_ORG_MAPS_ALL, and is marked VALID. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, while its unique indexes are stored in APPS_TS_TX_IDX, reflecting a standard separation of transactional data and index segments.

From a heuristic Data Vault modeling perspective, this object is classified as hub-leaning. The natural hub is the map identity carried by the MAP_ID surrogate primary key, with the organization and operating unit identifiers functioning as the principal foreign-key relationships. The effective dating columns (START_DATE_ACTIVE and END_DATE_ACTIVE) and the standard Who columns suggest the record can be treated as a satellite tracking descriptive and lifecycle attributes over time. This classification is offered as a modeling suggestion derived from the key structure, not as a documented Oracle construct.

Key Information Stored

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

• MAP_ID (NUMBER, 10) — Surrogate primary key, defined by constraint IGW_ORG_MAPS_ALL_PK and unique index IGW_ORG_MAPS_ALL_U1. It uniquely identifies each routing map and is the column propagated to all child and referencing tables.
• DESCRIPTION (VARCHAR2, 30) — The user-facing map name. It is a business-key candidate, enforced by unique index IGW_ORG_MAPS_ALL_U2.
• ORGANIZATION_ID (NUMBER, 15) — Identifies the organization for which the map is created. It is the documented foreign key to HR_ALL_ORGANIZATION_UNITS.
• ORG_ID (NUMBER, 15) — Operating unit identifier, enabling multi-organization access control and reporting segregation.
• START_DATE_ACTIVE (DATE) — First effective date on which the map becomes active.
• END_DATE_ACTIVE (DATE) — Last effective date on which the map remains active.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and concurrency information.

The distinction between the surrogate key (MAP_ID) and the business-key candidates (MAP_ID via U1 and DESCRIPTION via U2) is important when designing interfaces or data conversions, since uniqueness of the description is enforced independently of the surrogate identity.

Common Use Cases and Queries

Typical scenarios include retrieving the active map for a given organization, validating that a description is unique before insert, and joining map headers to their detail stops to reconstruct the full routing sequence.

• List active maps for an organization:
  SELECT MAP_ID, DESCRIPTION, START_DATE_ACTIVE, END_DATE_ACTIVE FROM IGW.IGW_ORG_MAPS_ALL WHERE ORGANIZATION_ID = :p_org AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND ORG_ID = :p_org_id;
• Resolve a map by business key:
  SELECT MAP_ID, ORGANIZATION_ID, ORG_ID FROM IGW.IGW_ORG_MAPS_ALL WHERE DESCRIPTION = :p_description;
• Reconstruct routing stops:
  SELECT m.MAP_ID, m.DESCRIPTION, d.STOP_ID FROM IGW.IGW_ORG_MAPS_ALL m, IGW.IGW_ORG_MAP_DETAILS d WHERE m.MAP_ID = d.MAP_ID AND m.ORG_ID = :p_org_id;
• Reporting on map coverage by operating unit, using ORG_ID as the grouping dimension, and effective-dating analysis via START_DATE_ACTIVE / END_DATE_ACTIVE.

Because the table is referenced by IGW_BUSINESS_RULES_ALL, it also serves as the anchor for business rule configuration joined on MAP_ID.

Related Objects

• IGW.IGW_ORG_MAP_DETAILS — Child table referencing MAP_ID; stores the individual approval stops that compose a routing map.
• IGW.IGW_BUSINESS_RULES_ALL — References MAP_ID; holds business rules applied at the map level.
• HR_ALL_ORGANIZATION_UNITS — Referenced by ORGANIZATION_ID; the parent organization definition for each map.
• IGW.IGW_ORG_MAPS_ALL_U1 — Unique index on MAP_ID, supporting primary key lookups.
• IGW.IGW_ORG_MAPS_ALL_U2 — Unique index on DESCRIPTION, the business-key candidate relevant to the user's search term "igw_org_maps_all_u2".
• APPS.IGW_ORG_MAPS_ALL — The APPS-layer synonym or view through which the table is normally accessed.
• IGW_ORG_MAPS_ALL_PK — Primary key constraint enforcing MAP_ID uniqueness.