Search Results ieu_uwq_nonmedia_actions




Overview
Explore in AI Chat

Overview

The IEU_UWQ_NONMEDIA_ACTIONS table is a core data object within the Oracle E-Business Suite (EBS) Universal Work Queue (UWQ) module, specifically for releases 12.1.1 and 12.2.2. UWQ provides a unified interface for agents to manage work items from various channels, such as phone calls, emails, and service requests. This table stores procedural definitions for non-media actions, which are programmatic tasks or workflows that can be initiated from the UWQ interface but are not directly tied to a specific communication medium (e.g., a phone call or email). These actions enable agents to execute predefined business logic, such as updating a record, launching a concurrent program, or navigating to a specific form, directly from their work queue, thereby streamlining operational processes.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the documented primary and foreign keys reveal the essential structural components of the table. The primary identifier for each non-media action procedure is the NONMEDIA_ACTION_ID column. A critical relational column is MACTION_DEF_ID, which serves as a foreign key linking each action record to its master definition in the IEU_UWQ_MACTION_DEFS_B table. This relationship implies that the table likely stores instance-specific or parameterized data for actions defined at a master level. Other columns, not detailed in the excerpt, would typically store information such as action parameters, execution status, target object references, and contextual data required for the action's procedural logic.

Common Use Cases and Queries

This table is primarily accessed by the UWQ framework to retrieve and execute the business logic associated with agent-initiated actions. Common use cases include querying all available non-media actions for a specific work item type or agent responsibility, or retrieving the specific parameters needed to run an action. A typical query would join this table to its master definition to get a comprehensible list of actions.

  • Sample Query to List Actions:
    SELECT nm.action_id, md.action_name, md.description
    FROM ieu_uwq_nonmedia_actions nm, ieu_uwq_maction_defs_b md
    WHERE nm.maction_def_id = md.maction_def_id
    AND md.enabled_flag = 'Y';
  • Reporting Use Case: System administrators may generate reports to audit the configuration and usage of non-media actions across different agent groups or to ensure consistency in action definitions deployed across instances.

Related Objects

The table maintains a direct foreign key relationship with a master definitions table, as documented in the ETRM metadata.

  • IEU_UWQ_MACTION_DEFS_B: This is the primary related table. The column IEU_UWQ_NONMEDIA_ACTIONS.MACTION_DEF_ID references the primary key of IEU_UWQ_MACTION_DEFS_B. This relationship ensures that every non-media action instance is based on a centrally defined and controlled action template, which manages common properties like the name, PL/SQL procedure call, and security attributes.

Given its role, the IEU_UWQ_NONMEDIA_ACTIONS table may also be referenced by various UWQ application programming interfaces (APIs) and seed data scripts responsible for populating the initial set of available agent actions during module implementation.