Search Results ieu_wp_param_props_b




Overview
Explore in AI Chat

Overview

The IEU_WP_PARAM_PROPS_B table is a core data object within the Universal Work Queue (UWQ) module of Oracle E-Business Suite (EBS). UWQ provides a centralized, role-based interface for agents to manage various work items, such as service requests, sales leads, and marketing interactions. This table functions as the base (or "B") table for storing the detailed definitions of properties associated with action parameters. It is a key component in the configuration and runtime execution of parameterized actions that agents can perform on work items within the UWQ interface, enabling dynamic and context-sensitive workflows.

Key Information Stored

As a base table, IEU_WP_PARAM_PROPS_B primarily holds the structural and relational data for parameter properties. The most critical column is the primary key, PARAM_PROPERTY_ID, which uniquely identifies each property record. The table establishes two essential foreign key relationships. The ACTION_PARAM_SET_ID column links a property to its parent parameter set defined in the IEU_WP_ACT_PARAM_SETS_B table. The PROPERTY_ID column links to a master property definition, though the specific referenced table is not fully detailed in the provided metadata. This structure allows a single parameter set to be associated with multiple configurable properties, defining the behavior, validation, or presentation of the parameter within the UWQ action.

Common Use Cases and Queries

This table is primarily accessed for system configuration, troubleshooting, and advanced reporting on UWQ action setups. Administrators or implementers may query it to understand the complete property configuration for a specific action parameter set. A common analytical query would join this table to its related base and translated tables to retrieve a full description of properties for a known parameter set.

  • Sample Query to List Properties for a Parameter Set:
    SELECT b.PARAM_PROPERTY_ID, b.ACTION_PARAM_SET_ID, b.PROPERTY_ID, tl.PROPERTY_NAME
    FROM IEU.IEU_WP_PARAM_PROPS_B b,
    IEU.IEU_WP_PARAM_PROPS_TL tl
    WHERE b.ACTION_PARAM_SET_ID = :p_param_set_id
    AND b.PARAM_PROPERTY_ID = tl.PARAM_PROPERTY_ID
    AND tl.LANGUAGE = USERENV('LANG');

Direct data manipulation (DML) on this table is not standard practice; configurations are typically performed via the Oracle EBS administrative forms or APIs to maintain data integrity.

Related Objects

The IEU_WP_PARAM_PROPS_B table is central to a small cluster of UWQ configuration tables, as defined by its documented foreign key relationships.

  • Referenced By (Child Table): The IEU_WP_PARAM_PROPS_TL table is a translation table that depends on this base table. It holds the language-specific names and descriptions for the property, joined via IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID = IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID.
  • References (Parent Tables):
    • IEU_WP_ACT_PARAM_SETS_B: This table defines the parameter set to which the property belongs. The join condition is IEU_WP_PARAM_PROPS_B.ACTION_PARAM_SET_ID = IEU_WP_ACT_PARAM_SETS_B.<key_column>.
    • An Unspecified Property Master Table: The foreign key on PROPERTY_ID indicates a relationship to a master list of available property types, which is not explicitly named in the provided metadata.