Search Results ieu_uwq_node_ds_pk

Overview

The IEU.UWQ_NODE_DS table is a reference table within the Oracle E-Business Suite Universal Work Queue (UWQ) module, which is part of the Interaction Center / Telephony product family (IEU). Its documented purpose is to maintain the mapping between UWQ nodes and the data sources that populate them. In practical terms, this table defines which grid data source supplies the result set displayed at a given node of the work queue hierarchy, allowing administrators and the UWQ runtime engine to associate a node with the underlying query or dataset that drives it.

The table resides in the IEU schema and is marked VALID in the ETRM metadata for Oracle EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification, meaning the table behaves primarily as a descriptive attribute store attached to an existing business key rather than as an independent hub or a transactional link. This classification is heuristic and should be treated as a modeling suggestion rather than a definitive architectural designation.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• NODE_DS_ID — The surrogate primary key (IEU_UWQ_NODE_DS_PK) that uniquely identifies each node-to-datasource mapping record.
• ENUM_TYPE_UUID — A UUID used to identify the node or enumeration type, forming part of the second unique index and serving as a business-key candidate.
• DATASOURCE_NAME — The name of the grid data source, which is also a foreign key referencing JTF_GRID_DATASOURCES_B and part of the U2 unique index.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant or organizational data segregation.
• OBJECT_VERSION_NUMBER — Optimistic locking column used to detect concurrent updates.
• ZD_EDITION_NAME — Editioning column supporting the E-Business Suite Online Patching (ADOP) model, appearing in both unique indexes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

The unique indexes IEU_UWQ_NODE_DS_U1 (NODE_DS_ID, ZD_EDITION_NAME) and IEU_UWQ_NODE_DS_U2 (ENUM_TYPE_UUID, DATASOURCE_NAME, ZD_EDITION_NAME) represent the documented business-key candidates. The primary key is the surrogate NODE_DS_ID, while the combination of ENUM_TYPE_UUID and DATASOURCE_NAME provides the natural business identity under editioning.

Common Use Cases and Queries

Typical usage centers on diagnosing why a particular UWQ node fails to display data, or on auditing which data source feeds which node. A common query joins the mapping table to the grid datasource definition to resolve names and descriptions:

• Node-to-datasource resolution — Select DATASOURCE_NAME, ENUM_TYPE_UUID, and SECURITY_GROUP_ID from IEU_UWQ_NODE_DS filtered by NODE_DS_ID or ENUM_TYPE_UUID to identify the configured source for a node.
• Datasource validation — Join IEU_UWQ_NODE_DS to JTF_GRID_DATASOURCES_B on DATASOURCE_NAME to confirm the referenced datasource exists and is active.
• Security review — Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to verify which security group owns each mapping.
• Edition-aware reporting — Filter on ZD_EDITION_NAME when querying under ADOP to isolate the active edition of records.

Because the table functions as a reference/satellite object, reporting is generally read-only. Modifications should be performed through the UWQ administration UI or via supported concurrent programs rather than direct DML, to preserve the integrity of the surrogate key and unique indexes.

Related Objects

The most significant objects related to IEU_UWQ_NODE_DS, based on documented foreign-key relationships, include:

• JTF_GRID_DATASOURCES_B — Referenced via IEU_UWQ_NODE_DS.DATASOURCE_NAME; defines the grid data sources available to UWQ.
• FND_SECURITY_GROUPS — Referenced via IEU_UWQ_NODE_DS.SECURITY_GROUP_ID; governs organization-level data access.
• IEU_UWQ_NODE_DS_PK — The primary key constraint on NODE_DS_ID.
• IEU_UWQ_NODE_DS_U1 / IEU_UWQ_NODE_DS_U2 — Unique indexes defining business-key candidates, both including ZD_EDITION_NAME.
• Other IEU UWQ configuration tables — Sibling reference tables in the IEU schema that define nodes, queues, and routing rules, which collectively drive the Universal Work Queue runtime.

These relationships confirm the table's role as a satellite-style mapping object linking UWQ node definitions to their grid datasources within the Oracle EBS Interaction Center framework.