Search Results ieu_uwqm_work_sources_b




Overview
Explore in AI Chat

Overview

The IEU_UWQM_WORK_SOURCES_B table resides in the IEU schema and belongs to the Universal Work Queue (UWQ) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the base definitions of "work sources" — logical groupings that identify where work items originate within the UWQ framework. Each row describes a distinct source of assignable work, such as a specific application, module, or business process, and provides the metadata the work queue uses to route, distribute, and present those items to end users.

The ETRM metadata classifies this object heuristically as a Data Vault hub, since it holds the unique business entity (the work source) keyed by a surrogate identifier and referenced by multiple dependent tables. This classification is a modeling suggestion rather than a physical Data Vault implementation. The table is one of several UWQ configuration tables, and its contents govern which work items appear in a given queue context.

Key Information Stored

The primary key is IEU_UWQM_WORK_SOURCES_B_PK, defined on the WS_ID column, a system-generated surrogate identifier. The unique index IEU_UWQM_WORK_SOURCES_B_U1 covers (WS_ID, ZD_EDITION_NAME), reflecting the editioning column used in 12.2.x multi-tenant and edition-based redefinition scenarios. Most important columns include:

Common Use Cases and Queries

Reporting typically joins this table to its dependents to list configured work sources and their associated items. A common query enumerates active sources:

  • SELECT ws_id, ws_code, ws_type, application_id FROM ieu_uwqm_work_sources_b WHERE active_flag = 'Y';
  • Joining to IEU_UWQM_ITEMS on WS_ID to inspect items produced by each source.
  • Joining to IEU_UWQM_WS_ASSCT_PROPS on WS_ID to retrieve source-level properties.
  • Joining to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to resolve security context.

Related Objects

Several UWQ tables depend on this hub through WS_ID foreign keys:

  • IEU_UWQM_ITEMS — work items belonging to each source.
  • IEU_UWQM_ITEMS_GTT — global temporary counterpart for item processing.
  • IEU_UWQM_WS_ASSCT_PROPS — associated properties per work source.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.

These relationships make IEU_UWQM_WORK_SOURCES_B a foundational configuration hub for the Universal Work Queue.