Search Results action_param_map_id




Overview
Explore in AI Chat

Overview

The IEU_WP_ACTION_PARAMS table is a core mapping table within the Oracle E-Business Suite (EBS) Interaction Center (IC) and Universal Work Queue (UWQ) framework, specifically in releases 12.1.1 and 12.2.2. Owned by the IEU (Interaction Center) schema, it functions as a junction table that defines the association between actionable work items (actions) and their configurable parameters. Its primary role is to support the dynamic and configurable nature of agent-facing actions in the UWQ, allowing administrators to map specific parameter definitions to specific action definitions, thereby controlling the data and behavior presented to agents when they perform work.

Key Information Stored

The table stores the linkage metadata between actions and parameters. The key columns include:

Common Use Cases and Queries

This table is central to querying the valid parameter set for a given UWQ action or auditing configuration changes. A common use case is retrieving all active parameters for a specific action definition to validate setup or for troubleshooting. The following sample query demonstrates this pattern, joining to the related definition tables for context:

SELECT map.ACTION_PARAM_MAP_ID,
       act.ACTION_NAME,
       param.PARAM_NAME,
       map.NOT_VALID_FLAG,
       map.LAST_UPDATE_DATE
FROM IEU.IEU_WP_ACTION_PARAMS map,
     IEU.IEU_UWQ_MACTION_DEFS_B act,
     IEU.IEU_WP_PARAM_DEFS_B param
WHERE map.WP_ACTION_DEF_ID = act.WP_ACTION_DEF_ID
AND map.PARAM_ID = param.PARAM_ID
AND map.NOT_VALID_FLAG = 'N'
AND act.ACTION_NAME = '<Your_Action_Name>';

Another key use is identifying all actions that utilize a particular parameter, which is essential for impact analysis before modifying a parameter definition.

Related Objects

The table's functionality is defined by its explicit foreign key relationships with two master definition tables:

  • IEU_UWQ_MACTION_DEFS_B: The table is referenced via the column IEU.IEU_WP_ACTION_PARAMS.WP_ACTION_DEF_ID. This table stores the core definition of work actions available in the UWQ.
  • IEU_WP_PARAM_DEFS_B: The table is referenced via the column IEU.IEU_WP_ACTION_PARAMS.PARAM_ID. This table stores the definition of all configurable parameters that can be associated with actions.
The primary key constraint IEU_WP_ACTION_PARAMS_PK on ACTION_PARAM_MAP_ID enforces the uniqueness of each mapping record. The table is also referenced by an APPS synonym (APPS.IEU_WP_ACTION_PARAMS), which is the standard access point for EBS application code.