Search Results not_valid

Overview

The view APPS.IEU_UWQ_TASKS_NODE_V is a component of the Oracle E-Business Suite Universal Work Queue (IEU) module, which provides agents with a consolidated, role-based interface for accessing and processing work items across multiple applications. This particular view is documented as being used for the "UWQ selector SpreadTable," meaning it supplies the structured node data that the UWQ user interface renders as a spread-table selector, allowing an agent to pick a work classification, queue, or task grouping before pulling the associated work items.

The view carries a status of VALID in the ETRM registry for release 12.2.2, and it is owned by the APPS schema. Because it is a view rather than a table, it exposes no persistent data of its own; instead it derives a filtered, runtime-personalized result set from the Universal Work Queue selector infrastructure. Its role in reporting and integration is primarily functional rather than analytical — it feeds the UWQ application layer, and any custom reporting or diagnostics that reference it inherit the same runtime filtering logic exercised by the delivered product.

Underlying Base Objects

ETRM documents three referenced base objects for this view:

• IEU_UWQ_SEL_RT_NODES (referenced through a synonym) — the principal source object. This table stores the runtime selector node definitions, including node labels, depth, counts, resource identifiers, and the validity flag referenced by the view logic.
• JTF_RS_RESOURCE_EXTNS (referenced through a synonym) — the resource extension table from the JTF Resource Manager schema, used to resolve the resource identifier associated with the currently logged-in application user.
• FND_GLOBAL (a package) — the standard EBS global context package, invoked here as FND_GLOBAL.USER_ID to return the current user's identifier at query time.

The view is therefore a thin, deterministic projection over IEU_UWQ_SEL_RT_NODES, with a correlated subquery against JTF_RS_RESOURCE_EXTNS and a call to FND_GLOBAL to enforce the "current user only" constraint.

Key Columns

• NODE_LABEL — the display text of the selector node, presented to the agent in the SpreadTable.
• COUNT — the quantity of work items or tasks aggregated under the node.
• RESOURCE_ID — the resource identifier for the logged-in user, resolved from JTF_RS_RESOURCE_EXTNS.
• RESOURCE_TYPE — a literal value, 'RS_INDIVIDUAL', indicating that the node is scoped to an individual resource rather than a group or team.
• IEU_PARAM_PK_VALUE — an alias that surfaces RESOURCE_ID again, supplied as the parameter primary-key value consumed by the UWQ selector framework when drilling into a node.

Common Use Cases and Queries

The principal use case is diagnostic: confirming which selector nodes and counts the UWQ SpreadTable will present to a given user. The view is hard-coded to selector enumeration ID 10054, node depth 2, and only rows where NVL(NOT_VALID, 'N') = 'N' — that is, rows that are valid or whose validity flag is null. This corresponds closely to the user's search term "not_valid": the filter deliberately excludes rows explicitly marked NOT_VALID = 'Y'.

A representative query is:

• SELECT node_label, count, resource_id, resource_type FROM apps.ieu_uwq_tasks_node_v ORDER BY node_label;

Because the view relies on FND_GLOBAL.USER_ID, results vary by session; a DBA executing it directly will see rows for the DBA's own resource record unless the EBS session context is initialized with FND_GLOBAL.APPS_INITIALIZE. For investigations of excluded nodes, query the base object directly:

• SELECT node_label, count, resource_id, not_valid FROM apps.ieu_uwq_sel_rt_nodes WHERE sel_enum_id = 10054 AND node_depth = 2;

This comparison isolates records suppressed by the validity filter and is the standard technique for troubleshooting missing or incorrect UWQ selector entries.