Search Results cs_sr_uwq_nodes_tl




Overview
Explore in AI Chat

Overview

CS_SR_UWQ_NODES_TL is a translation (TL) table in the CS — Service product of Oracle E-Business Suite, holding the translated definitions for UWQ (Universal Work Queue) Non-Media nodes. In EBS, UWQ provides a unified, role-based work queue framework that aggregates work items from multiple sources and routes them to the appropriate users. Non-Media nodes represent navigational or organizational elements within the queue hierarchy — for example, container nodes, grouping folders, or functional categories — rather than actual media-based work items. Because the node labels displayed to end users must be presented in each user's session language, the base table stores the source-language definition while this table stores the same logical rows in each installed language, keyed by NODE_ID and LANGUAGE.

The table resides in the CS schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the mined heuristic classification is standalone, which suggests the table can be modeled independently, without being treated as a hub, link, or satellite tied to a parent entity. In practice, however, it functions as a language-dependent descriptive companion to the corresponding base node table, differing only in the translated NODE_LABEL value per LANGUAGE row. The table has 11 documented columns and a two-column composite primary key, CS_SR_UWQ_NODES_TL_PK, on (NODE_ID, LANGUAGE). A secondary unique index, CS_SR_UWQ_NODES_TL_U1, adds ZD_EDITION_NAME to that key.

Key Information Stored

The most significant columns of CS_SR_UWQ_NODES_TL are those that identify a node in a specific language, carry the translated label, and support standard EBS auditing and security. Only columns documented in the ETRM metadata are described below.

  • NODE_ID — Surrogate numeric identifier for the UWQ non-media node. Together with LANGUAGE it forms the composite primary key CS_SR_UWQ_NODES_TL_PK, and it is also the first column of the unique index CS_SR_UWQ_NODES_TL_U1.
  • LANGUAGE — The language code identifying the translation row for the node. It is the second component of the primary key and of the unique business-key index.
  • NODE_LABEL — The translated display label for the node, shown to the user in the corresponding language. This is the core payload of the TL table.
  • SOURCE_LANG — The source language from which the translation was derived, used by the Translation (TL) framework to track the language of the base definition.
  • ZD_EDITION_NAME — The edition name associated with the row. It is the third column of the CS_SR_UWQ_NODES_TL_U1 unique index, reflecting the Edition-Based Redefinition (EBR) model used in EBS 12.2.x, and is typically the value "ORA$BASE" in non-editioned data.
  • SECURITY_GROUP_ID — Foreign-key reference to FND_SECURITY_GROUPS, used to scope the row to a specific security group for data isolation.
  • CREATION_DATE / CREATED_BY — Who created the row and when, derived from the standard EBS WHO columns.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Who last modified the row, when, and under which login session. These columns are essential for incremental ETL and auditing.

The surrogate primary key is (NODE_ID, LANGUAGE); the broader business-key candidate identified by the unique index is (NODE_ID, LANGUAGE, ZD_EDITION_NAME).

Common Use Cases and Queries

Because UWQ node labels drive the navigation and grouping that users see, this table is consulted at runtime by the Work Queue UI to render node names in the logged-in user's language. Reporting and data-migration scenarios typically join CS_SR_UWQ_NODES_TL to its base node table on NODE_ID, and filter to a specific LANGUAGE.

A representative query returning node labels in a chosen language:

  • SELECT n.node_id, t.node_label, t.language FROM cs.cs_sr_uwq_nodes_tl t WHERE t.language = USERENV('LANG') ORDER BY t.node_label;
  • SELECT t.node_id, t.node_label, t.source_lang, t.security_group_id FROM cs.cs_sr_uwq_nodes_tl t WHERE t.node_id = :node_id AND t.language = :language;

Other common uses include: auditing which nodes lack a translation in a given language; identifying rows changed since a baseline date using LAST_UPDATE_DATE for incremental ETL; and reviewing SECURITY_GROUP_ID assignments to confirm data-visibility scoping. For EBS 12.2.x environments, include ZD_EDITION_NAME in predicates when querying editioned data.

Related Objects

The following objects are most relevant to CS_SR_UWQ_NODES_TL based on the documented FK structure and the standard EBS translation pattern:

  • CS_SR_UWQ_NODES — The base (source-language) node table; CS_SR_UWQ_NODES_TL joins to it on NODE_ID.
  • CS_SR_UWQ_NODES_TL itself, via its parent relationship, is the language-specific companion that supplies NODE_LABEL per LANGUAGE.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; join on SECURITY_GROUP_ID for security-group descriptions.
  • FND_LANGUAGES — Logical reference for the LANGUAGE code, providing language validation and NLS values.
  • CS_SR_WORK_ITEMS (and related UWQ work-item tables) — The media work items that ultimately associate with non-media nodes in the queue hierarchy.
  • FND_APPLICATION / FND_PRODUCT_GROUPS — Contextual metadata for the CS product owning these nodes.

Applications and APIs that build or maintain UWQ hierarchies should honor the TL structure, ensuring NODE_LABEL is populated for each installed LANGUAGE and that ZD_EDITION_NAME is maintained correctly in 12.2.x environments.