Search Results ieu_wp_action_params




Overview
Explore in AI Chat

Overview

The IEU_WP_ACTION_PARAMS table is a core data object within the Oracle E-Business Suite (EBS) Universal Work Queue (UWQ) module, identified by the product code IEU. It functions as a junction or mapping table that defines the relationship between UWQ actions and their associated parameters. Its primary role is to store the specific configuration details that link a parameter definition to a particular action definition, thereby enabling the dynamic and parameterized execution of work queue actions. This table is essential for the runtime resolution of action calls within the UWQ framework, ensuring that actions receive the correct contextual data when invoked by an agent or an automated process.

Key Information Stored

The table's structure is designed to manage the many-to-many relationships between actions and parameters. Its most critical columns, as indicated by the provided metadata, are the foreign keys that establish these links. The primary key, ACTION_PARAM_MAP_ID, uniquely identifies each specific action-parameter mapping record. The WP_ACTION_DEF_ID column references a specific action definition stored in the IEU_UWQ_MACTION_DEFS_B table. The PARAM_ID column references a specific parameter definition stored in the IEU_WP_PARAM_DEFS_B table. Together, these columns form the logical core of the table, defining which parameters are required or available for a given UWQ action.

Common Use Cases and Queries

A primary use case is the administrative setup and audit of UWQ actions. System administrators or implementers may query this table to understand the complete parameterization of available actions, troubleshoot missing parameters, or validate configuration setups during migrations. Common reporting queries involve joining to the related definition tables to produce human-readable lists. For example, to list all parameters for a specific action definition, a query would join IEU_WP_ACTION_PARAMS to IEU_UWQ_MACTION_DEFS_B (on WP_ACTION_DEF_ID) and to IEU_WP_PARAM_DEFS_B (on PARAM_ID). Another critical use case occurs at runtime within the UWQ application logic, where the EBS framework queries this table to retrieve the list of parameters that must be resolved (e.g., populated with a task ID, customer number, or other context) before an action can be successfully executed by an agent from the work queue interface.

Related Objects

The table maintains documented foreign key relationships with two key definition tables in the IEU schema, forming a central link in the UWQ metadata architecture.

  • IEU_UWQ_MACTION_DEFS_B: This table stores the master definitions of UWQ actions. The relationship is defined by the column IEU_WP_ACTION_PARAMS.WP_ACTION_DEF_ID, which references a primary key in IEU_UWQ_MACTION_DEFS_B.
  • IEU_WP_PARAM_DEFS_B: This table stores the master definitions of parameters available within the UWQ. The relationship is defined by the column IEU_WP_ACTION_PARAMS.PARAM_ID, which references a primary key in IEU_WP_PARAM_DEFS_B.

These relationships confirm that IEU_WP_ACTION_PARAMS is a child table to both action and parameter master definitions, serving as the configurable bridge between them.