Search Results ieu_wp_action_maps_u1

Overview

The IEU.IEU_WP_ACTION_MAPS table is a seed data table within the Interaction Center (IEU) schema of Oracle E-Business Suite. It defines action mappings that control how actions are surfaced and populated within the Universal Work Queue (UWQ) and related work-node contexts. Each row associates an Action-Parameter Set with either a work node or a UWQ login session, allowing administrators to govern which actions appear and when they are made available to agents.

The table resides in the APPS_TS_SEED tablespace, which is characteristic of reference and configuration data rather than high-volume transactional data. The columns ACTION_MAP_TYPE_CODE and ACTION_MAP_CODE distinguish between node-based mappings ('NODE') and mappings populated during UWQ session login ('UWQ'). The RESPONSIBILITY_ID column introduces responsibility-level scoping, and when it is null the mapping behaves as a default for the given combination.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as satellite-leaning. This suggests the table is best understood as descriptive attribute data attached to a parent business key rather than as an independent hub or a pure link between entities.

Key Information Stored

The surrogate primary key is WP_ACTION_MAP_ID, a NUMBER(15) that uniquely identifies each action-mapping. It is enforced by the primary key constraint IEU_WP_ACTION_MAPS_PK and by the unique index IEU_WP_ACTION_MAPS_U1.

• ACTION_MAP_TYPE_CODE — VARCHAR2(32) identifying the mapping type, such as 'NODE' for node-based action mapping and 'UWQ' for actions populated at UWQ session login.
• ACTION_MAP_CODE — VARCHAR2(64) whose interpretation depends on the map type code.
• ACTION_PARAM_SET_ID — NUMBER(15) referencing the action-parameter set mapped to the work node or other target based on type code.
• RESPONSIBILITY_ID — identifies the responsibility for which the mapping is valid; null indicates a default mapping.
• APPLICATION_ID — identifies the application owning the data.
• SECURITY_GROUP_ID — used in hosted environments and referencing FND_SECURITY_GROUPS.
• ACTION_MAP_SEQUENCE, PANEL_SEC_CAT_CODE, NOT_VALID_FLAG, and DEV_DATA_FLAG — control ordering, panel security categorization, validity, and development-data status.
• OBJECT_VERSION_NUMBER and the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide standard concurrency and audit tracking.
• ZD_EDITION_NAME — participates in the documented unique index IEU_WP_ACTION_MAPS_U1 alongside WP_ACTION_MAP_ID.

Common Use Cases and Queries

Typical usage centers on diagnosing which actions are presented to agents and why. A common query retrieves all mappings for a given map type, joining back to responsibilities and parameter sets to resolve descriptive context.

• Listing active mappings by type: SELECT wp_action_map_id, action_map_code, action_map_type_code, responsibility_id FROM ieu.ieu_wp_action_maps WHERE action_map_type_code = 'NODE' AND not_valid_flag = 'N';
• Identifying default mappings where no responsibility scope applies: filter on responsibility_id IS NULL.
• Resolving the parameter set behind an action using ACTION_PARAM_SET_ID, and resolving security scope through SECURITY_GROUP_ID against FND_SECURITY_GROUPS.
• Reviewing validity and development flags before promoting configuration between environments.

Because this object is flagged Oracle Internal Use Only, direct DML should not be performed; changes are expected through standard Oracle Applications programs.

Related Objects

The documented foreign keys and index columns establish the following significant relationships:

• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for hosted-environment security scoping.
• Action-Parameter Set objects — referenced by ACTION_PARAM_SET_ID, linking a mapping to the parameter set it activates.
• FND_RESPONSIBILITY — relevant through RESPONSIBILITY_ID when resolving which responsibility a mapping applies to.
• IEU_WP_ACTION_MAPS_N1 — supporting index on ACTION_MAP_CODE, ACTION_MAP_TYPE_CODE, RESPONSIBILITY_ID, and NOT_VALID_FLAG for query performance.
• IEU_WP_ACTION_MAPS_N2 — supporting index on ACTION_PARAM_SET_ID.

Together these objects form the configuration backbone that determines action behavior within the Interaction Center Universal Work Queue.