Search Results ieu_wp_node_section_maps

Overview

The IEU_WP_NODE_SECTION_MAPS table, owned by the IEU schema, is a foundational configuration object within the Oracle E-Business Suite Universal Work Queue (UWK) module. It defines the relationship between Work Queue nodes and the content sections displayed within them, effectively mapping which information sections appear at each node of the work queue navigation hierarchy. In the context of Oracle EBS 12.1.1 and 12.2.2, this table supports the flexible, extensible presentation layer that allows administrators and implementers to tailor the Universal Work Queue interface to specific business roles, responsibilities, and applications.

From a data modeling perspective, the heuristic Data Vault classification derived from the foreign key structure suggests a satellite-leaning classification. This means the table functions primarily as a descriptive attribute store attached to a parent entity, capturing the mapping-specific details rather than serving as a standalone hub of business keys or a pure association link. The table is well integrated with the EBS security and responsibility model, as evidenced by its foreign key association to FND_SECURITY_GROUPS.

Key Information Stored

The table contains 14 documented columns. The most significant of these are:

WP_NODE_SECTION_MAP_ID — The surrogate primary key, enforced by the IEU_WP_NODE_SECTION_MAPS_PK constraint and also covered by the unique index IEU_WP_NODE_SECTION_MAPS_U1, making it a business-key candidate.
SECTION_ID — References the section definition being mapped to a node; part of the foreign key relationship documented for this table.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, governing data visibility across operating units and security contexts.
APPLICATION_ID — Identifies the Oracle application context for which the mapping applies.
RESPONSIBILITY_ID — Associates the mapping with a specific EBS responsibility, enabling role-based work queue customization.
ENUM_TYPE_UUID — A UUID-based identifier for the enumeration type associated with the section map, supporting the extensible lookup framework.
SECTION_MAP_SEQUENCE — Controls the display ordering of sections within a node.
NOT_VALID_FLAG — Indicates whether a mapping is active or has been logically disabled.
OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent update control.
Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who/when audit tracking.

Common Use Cases and Queries

Typical use cases center on diagnosing and reporting the work queue configuration. A common query retrieves all active section mappings for a given responsibility:

Join IEU_WP_NODE_SECTION_MAPS to section and node definition tables to reconstruct the full work queue layout.
Filter by RESPONSIBILITY_ID and APPLICATION_ID to isolate configuration for a specific business role.
Query by SECTION_MAP_SEQUENCE to verify display order expectations.
Audit NOT_VALID_FLAG to identify disabled or obsolete mappings left after upgrades.
Reconcile SECURITY_GROUP_ID against FND_SECURITY_GROUPS to diagnose visibility inconsistencies in multi-org deployments.

Because the table is relatively narrow, reporting queries typically join outward to descriptive tables rather than aggregating within this table itself.

Related Objects

The most significant related objects include:

FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID, controlling security visibility.
The section definition table referenced by SECTION_ID (the foreign key target for section mappings).
Companion IEU work queue node and section configuration tables that share the WP_ prefix.
EBS responsibility and application definition tables (FND_RESPONSIBILITY, FND_APPLICATION) indirectly referenced via RESPONSIBILITY_ID and APPLICATION_ID.
Standard EBS audit and object versioning infrastructure used by OBJECT_VERSION_NUMBER and the audit columns.

Collectively, these relationships make IEU_WP_NODE_SECTION_MAPS an essential configuration bridge in the Universal Work Queue architecture.

Table: IEU_WP_NODE_SECTION_MAPS 12.2.2
owner:IEU, object_type:TABLE, fnd_design_data:IEU.IEU_WP_NODE_SECTION_MAPS, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID, product: IEU - Universal Work Queue , description: Node - Section Maps. , implementation_dba_data: IEU.IEU_WP_NODE_SECTION_MAPS ,
Table: IEU_WP_NODE_SECTION_MAPS 12.1.1
owner:IEU, object_type:TABLE, fnd_design_data:IEU.IEU_WP_NODE_SECTION_MAPS, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID, product: IEU - Universal Work Queue , description: Node - Section Maps. , implementation_dba_data: IEU.IEU_WP_NODE_SECTION_MAPS ,
SYNONYM: APPS.IEU_WP_NODE_SECTION_MAPS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID,
VIEW: IEU.IEU_WP_NODE_SECTION_MAPS# 12.2.2
VIEW: IEU.IEU_WP_NODE_SECTION_MAPS# 12.2.2
owner:IEU, object_type:VIEW, object_name:IEU_WP_NODE_SECTION_MAPS#, status:VALID,
SYNONYM: APPS.IEU_WP_NODE_SECTION_MAPS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.IEU_SEED_DATA_LOADER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_SEED_DATA_LOADER_PKG, status:VALID,
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
TABLE: IEU.IEU_WP_NODE_SECTION_MAPS 12.1.1
owner:IEU, object_type:TABLE, fnd_design_data:IEU.IEU_WP_NODE_SECTION_MAPS, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID,
TABLE: IEU.IEU_WP_NODE_SECTION_MAPS 12.2.2
owner:IEU, object_type:TABLE, fnd_design_data:IEU.IEU_WP_NODE_SECTION_MAPS, object_name:IEU_WP_NODE_SECTION_MAPS, status:VALID,
PACKAGE BODY: APPS.IEU_SEED_DATA_LOADER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_SEED_DATA_LOADER_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.IEU_WORKPANEL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_WORKPANEL_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_WORK_ACTION_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_WORK_ACTION_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_WORKPANEL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_WORKPANEL_PVT, status:VALID,
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.IEU_WORK_ACTION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_WORK_ACTION_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.IEU_WORK_ACTION_PVT SQL Statements 12.1.1
APPS.IEU_WORK_ACTION_PVT SQL Statements 12.2.2
APPS.IEU_WORKPANEL_PVT SQL Statements 12.2.2
APPS.IEU_WORKPANEL_PVT SQL Statements 12.1.1
APPS.IEU_WORK_PROVIDER_PUB SQL Statements 12.2.2
APPS.IEU_WORK_PROVIDER_PUB SQL Statements 12.1.1
PACKAGE BODY: APPS.IEU_WORK_ACTION_PVT 12.2.2
PACKAGE BODY: APPS.IEU_WORK_PROVIDER_PUB 12.1.1
PACKAGE BODY: APPS.IEU_WORK_PROVIDER_PUB 12.2.2
APPS.IEU_SEED_DATA_LOADER_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.IEU_WORK_ACTION_PVT 12.1.1
APPS.IEU_SEED_DATA_LOADER_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.IEU_WORKPANEL_PVT 12.1.1
PACKAGE BODY: APPS.IEU_WORKPANEL_PVT 12.2.2
APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_NODE_SECTION_MAPS 12.2.2
APPS.IEU_SEED_DATA_LOADER_PKG dependencies on IEU_WP_NODE_SECTION_MAPS 12.1.1
APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_NODE_SECTION_MAPS 12.1.1
APPS.IEU_WORK_ACTION_PVT dependencies on IEU_WP_NODE_SECTION_MAPS 12.1.1
APPS.IEU_SEED_DATA_LOADER_PKG dependencies on IEU_WP_NODE_SECTION_MAPS 12.2.2
APPS.IEU_WORK_ACTION_PVT dependencies on IEU_WP_NODE_SECTION_MAPS 12.2.2
Foreign Keys 12.2.2
Foreign Keys 12.1.1
PACKAGE BODY: APPS.IEU_SEED_DATA_LOADER_PKG 12.1.1
PACKAGE BODY: APPS.IEU_SEED_DATA_LOADER_PKG 12.2.2
eTRM - IEU Tables and Views 12.2.2
description: UI Component-Data Types mapping ,
eTRM - IEU Tables and Views 12.1.1
description: UI Component-Data Types mapping ,