Search Results cs_sr_uwq_node_pk

Overview

CS_SR_UWQ_NODES_B is a Service (CS) module table in Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It holds the non-translated ("_B" base) definitions for Universal Work Queue (UWQ) non-media nodes. UWQ is the framework that presents consolidated, role-based work queues to service agents and other users; nodes are the individual queue elements displayed within the UWQ hierarchy. This table stores the structural and behavioral definition of each non-media node, including its view association, query logic, and parent-child placement, while translated attribute text resides in a corresponding "_T" table following the standard EBS MLS pattern.

The ETRM metadata classifies this table heuristically as standalone under a Data Vault lens. In modeling terms, this suggests CS_SR_UWQ_NODES_B is best treated as a reference/definition entity rather than a transactional hub, link, or satellite. It is a configuration-style table whose rows define available queue nodes rather than record business events.

Key Information Stored

The surrogate primary key is NODE_ID, enforced through the CS_SR_UWQ_NODE_PK constraint. A unique index, CS_SR_UWQ_NODES_U1, covers (NODE_ID, ZD_EDITION_NAME), which serves as the business-key candidate and supports Oracle's editioning/online-patching model in 12.2.x. The most significant columns include:

• NODE_ID — Surrogate identifier for each non-media UWQ node definition.
• NODE_VIEW — The view or logical presentation context in which the node appears.
• DATA_SOURCE — Identifies the underlying source used to populate the node's results.
• MEDIA_TYPE_ID — Foreign key to IEU_UWQ_MEDIA_TYPES_B, linking the node to its media type classification.
• WHERE_CLAUSE — Filter condition applied when selecting records for the node.
• NODE_TYPE — Categorizes the node (for example, folder or query node) and drives display behavior.
• NODE_QUERY and CURSOR_SQL — SQL defining the data retrieval for the node.
• CURSOR_KEY_COL — Identifies the key column used by the node cursor.
• PARENT_ID and NODE_DEPTH — Establish hierarchy and nesting level among nodes.
• HIDE_IF_EMPTY and RES_CAT_ENUM_FLAG — Control visibility and resource-category enumeration behavior.
• ENABLED_FLAG — Determines whether the node is active.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant/security-group isolation.
• OBJECT_VERSION_NUMBER — Optimistic locking column maintained by the framework.
• ZD_EDITION_NAME — Editioning column supporting 12.2.x online patching.

Standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are also present.

Common Use Cases and Queries

Typical use cases involve inspecting or troubleshooting UWQ node configuration, validating hierarchy, and auditing query definitions. Representative SQL patterns include:

• List active nodes with their parent relationships:

SELECT node_id, node_view, node_type, parent_id, enabled_flag
FROM   cs_sr_uwq_nodes_b
WHERE  enabled_flag = 'Y'
AND    (zd_edition_name = 'SET1' OR zd_edition_name IS NULL);

• Trace nodes by media type:

SELECT n.node_id, n.node_query, m.media_type_id
FROM   cs_sr_uwq_nodes_b n, ieu_uwq_media_types_b m
WHERE  n.media_type_id = m.media_type_id;

• Validate hierarchy depth and orphaned nodes using PARENT_ID against NODE_ID.
• Audit WHERE_CLAUSE and CURSOR_SQL content for node performance tuning.
• Security-group-scoped reporting using SECURITY_GROUP_ID.

Related Objects

The most significant related objects, based on documented foreign keys and standard UWQ dependencies, include:

• IEU_UWQ_MEDIA_TYPES_B — Referenced via MEDIA_TYPE_ID; defines media type classification.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security isolation.
• CS_SR_UWQ_NODES_TL — Non-base translation table holding translated node text.
• CS_SR_UWQ_NODES_B.PARENT_ID — Self-referencing relationship to NODE_ID establishing node hierarchy.
• CS_SR_UWQ_NODE_PK / CS_SR_UWQ_NODES_U1 — Primary key and editioning unique index constraints.
• IEU_UWQ_MEDIA_TYPES_TL — Translation companion to the media type base table.

Together these objects support the UWQ framework's node definition, translation, security, and hierarchical presentation requirements across EBS 12.1.1 and 12.2.2.