Search Results ieu_wp_act_param_sets_b

Overview

The IEU_WP_ACT_PARAM_SETS_B table is a core data object within the Oracle E-Business Suite (EBS) Universal Work Queue (UWQ) module. It functions as the base table for storing action parameter set definitions. In the context of UWQ, which provides a centralized interface for managing and processing work items, this table is essential for configuring the runtime parameters required by specific work actions. Each record defines a distinct set of parameters that can be associated with a UWQ action definition, enabling dynamic and configurable action behavior without hard-coding values. Its role is to act as a repository for these parameter set headers, which are then detailed in the related IEU_WP_PARAM_PROPS_B table.

Key Information Stored

The primary data stored in this table centers on the unique identification of a parameter set and its linkage to a parent action definition. The most critical column is the ACTION_PARAM_SET_ID, which serves as the primary key and uniquely identifies each parameter set within the system. Another crucial column is WP_ACTION_DEF_ID, a foreign key that establishes the relationship between a parameter set and its associated UWQ action definition in the IEU_UWQ_MACTION_DEFS_B table. This structure allows multiple parameter sets to be defined for a single action, supporting different use cases or contexts. While the provided metadata does not list all columns, typical supporting columns would include creation date, created by, last update date, and last updated by for auditing purposes.

Common Use Cases and Queries

A primary use case involves administrative setup or troubleshooting of UWQ actions, where understanding the configured parameter sets is necessary. For instance, a developer or administrator may need to identify all parameter sets linked to a specific action definition to validate configuration or diagnose an issue. Common SQL queries include joining to the action definitions table to get a readable list of actions with their associated parameter sets.

• Listing Parameter Sets for an Action: SELECT aps.ACTION_PARAM_SET_ID, mad.DISPLAY_NAME FROM IEU_WP_ACT_PARAM_SETS_B aps JOIN IEU_UWQ_MACTION_DEFS_B mad ON aps.WP_ACTION_DEF_ID = mad.WP_ACTION_DEF_ID WHERE mad.NAME = '<Action_Name>';
• Identifying Orphaned Parameter Sets: SELECT aps.* FROM IEU_WP_ACT_PARAM_SETS_B aps LEFT JOIN IEU_UWQ_MACTION_DEFS_B mad ON aps.WP_ACTION_DEF_ID = mad.WP_ACTION_DEF_ID WHERE mad.WP_ACTION_DEF_ID IS NULL;

Related Objects

The IEU_WP_ACT_PARAM_SETS_B table is centrally positioned within a small hierarchy of UWQ configuration tables, as defined by its documented foreign key relationships.

• Parent Table (Referenced Foreign Key): The table references IEU_UWQ_MACTION_DEFS_B via the WP_ACTION_DEF_ID column. This is the master definition table for UWQ actions.
• Child Table (Referencing Foreign Key): The table is referenced by IEU_WP_PARAM_PROPS_B via its ACTION_PARAM_SET_ID column. This table stores the individual parameter properties (name, value, type) that constitute a set defined in IEU_WP_ACT_PARAM_SETS_B.

Therefore, a complete view of a parameter set requires joining IEU_WP_ACT_PARAM_SETS_B (the header) with IEU_WP_PARAM_PROPS_B (the lines) and IEU_UWQ_MACTION_DEFS_B (the parent action).