Search Results ieu_uwq_node_ds_u1

Overview

IEU.IEU_UWQ_NODE_DS is a seed data table in the Interaction and E-Business Unified Work Queue (IEU) module of Oracle E-Business Suite. It stores the mapping between a Universal Work Queue (UWQ) node and the datasource that supplies the records displayed on the node's SpreadTable interface. In practical terms, each row binds an enumeration type — keyed by its universally unique identifier (ENUM_TYPE_UUID) — to a registered grid datasource (DATASOURCE_NAME), allowing the UWQ runtime to determine which query or view feeds a given node presentation.

The table resides in the APPS_TS_SEED tablespace, consistent with its role as a configuration and reference object populated at installation or patch time rather than at runtime. It carries standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the hosted-environment SECURITY_GROUP_ID, and OBJECT_VERSION_NUMBER for optimistic locking under the HTML utilities framework.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. The table hangs off two foreign keys — DATASOURCE_NAME referencing JTF_GRID_DATASOURCES_B and SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS — and its unique keys combine an enumeration identifier with the datasource name rather than a purely independent identity. This is characteristic of a satellite or mapping entity subordinate to the node and datasource hubs, though it can be treated as a link table for the node-to-datasource association. The classification is a heuristic suggestion only.

Key Information Stored

NODE_DS_ID is the surrogate primary key, defined as a NUMBER(15), and forms the leading column of the unique index IEU_UWQ_NODE_DS_U1 alongside ZD_EDITION_NAME, the editioning column used by online patching in Release 12.2.

Business-key candidates are documented through unique index IEU_UWQ_NODE_DS_U2, which spans ENUM_TYPE_UUID, DATASOURCE_NAME, and ZD_EDITION_NAME. This composite uniquely identifies a node-datasource mapping by enumeration type and datasource, ensuring no duplicate assignment exists for a given edition. ENUM_TYPE_UUID is a VARCHAR2(38) holding the universally unique identifier of the enumeration type, while DATASOURCE_NAME is a VARCHAR2(64) naming the SpreadTable datasource bound to that node. The ZD_EDITION_NAME VARCHAR2(30) column participates in both unique indexes, partitioning the logical key space across editions for patching safety.

The WHO columns and OBJECT_VERSION_NUMBER provide the audit and concurrency control fields expected on IEU configuration tables. SECURITY_GROUP_ID supports multi-tenant hosting. These ancillary columns should not be treated as business keys, but they are essential to line-level diagnostics and reconciliation queries.

Common Use Cases and Queries

Typical usage centers on diagnosing UWQ node rendering problems. When a work queue node fails to display records, the analyst inspects the mapping between the node's enumeration type and its datasource:

• Resolve a node's datasource: SELECT NODE_DS_ID, DATASOURCE_NAME FROM IEU.IEU_UWQ_NODE_DS WHERE ENUM_TYPE_UUID = :uuid AND ZD_EDITION_NAME = :edition;
• Verify datasource registration by joining to JTF_GRID_DATASOURCES_B on DATASOURCE_NAME.
• Audit security assignments by joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS.
• Detect duplicate or missing mappings per edition using the IEU_UWQ_NODE_DS_U2 key columns.
• Review change history via LAST_UPDATE_DATE and LAST_UPDATED_BY before and after patch application.

Reporting queries should always filter on ZD_EDITION_NAME in Release 12.2 to avoid returning rows from multiple editions.

Related Objects

The documented dependencies identify the principal related objects:

• JTF_GRID_DATASOURCES_B — joined on DATASOURCE_NAME; the master repository of grid datasource definitions.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs hosted-access security assignment.
• IEU.IEU_UWQ_NODE_DS# — the editioned base table underlying this object in Release 12.2.
• IEU_UWQ_NODE_DS_PK, IEU_UWQ_NODE_DS_U1, IEU_UWQ_NODE_DS_U2 — primary and unique constraints and indexes enforcing row and business-key uniqueness.

Oracle restricts direct access to this object; all supported interaction occurs through standard applications programs and the HTML utilities interface.