Results for “refresh_view_sum_col”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IEU_UWQ_SEL_RT_NODES table is a core data dictionary object within the Oracle E-Business Suite Universal Work Queue (IEU) module. Its documented description is "UWQ Selector Run-Time Nodes," indicating that it stores the run-time definition of selector nodes used to build and render work queue result sets. Selectors in UWQ are the query-building constructs that determine which work items appear in an agent's queue; the run-time node records persist the resolved node metadata that the selector engine evaluates at execution time.

From a Data Vault modeling perspective, the ETRM-supplied heuristic classification is satellite-leaning. This suggests the table functions primarily as a descriptive, attribute-bearing satellite surrounding a central business key, rather than as an independent hub or a pure link. The recorded unique indexes — IEU_UWQ_SEL_RT_NODES_U1 (RESOURCE_ID, SEL_ENUM_ID, NODE_ID, NODE_TYPE), U2 (RESOURCE_ID, NODE_ID, NOT_VALID), and U3 (SEL_RT_NODE_ID) — reinforce the interpretation that the natural business identity is a composite of resource, enumerator, and node descriptors, while SEL_RT_NODE_ID serves as the surrogate primary key.

Key Information Stored

The table contains 27 documented columns in the 12.2.2 physical schema. The most operationally significant are:

• SEL_RT_NODE_ID — the surrogate primary key defined by IEU_UWQ_SEL_RT_NODES_PK, uniquely identifying each run-time node row.
• RESOURCE_ID — identifies the UWQ resource (agent or resource context) to which the node belongs; participates in unique indexes U1 and U2.
• SEL_ENUM_ID — the selector enumerator reference; foreign key to IEU_UWQ_SEL_ENUMERATORS and part of U1.
• NODE_ID and NODE_TYPE — the node identifier and its category within the selector tree; both appear in U1.
• NODE_LABEL — the display label presented for the node in the work queue UI.
• COUNT — the item count resolved for the node at run time.
• DATA_SOURCE and VIEW_NAME — the source and database view backing the selector node.
• MEDIA_TYPE_ID — foreign key to IEU_UWQ_MEDIA_TYPES_B, indicating the media channel for the node.
• SEL_ENUM_PID and NODE_PID — persistent identifiers linking run-time nodes back to design-time definitions.
• WHERE_CLAUSE — the filter predicate applied to the underlying data source.
• HIDE_IF_EMPTY and NOT_VALID — display and validity control flags; NOT_VALID is part of unique index U2.
• NODE_WEIGHT and NODE_DEPTH — ordering and hierarchy attributes used to render the selector tree.
• REFRESH_VIEW_NAME, REFRESH_VIEW_SUM_COL, and RES_CAT_ENUM_FLAG — refresh and resource-category enumerator controls.
• SECURITY_GROUP_ID — the multi-tenant security grouping (FK to FND_SECURITY_GROUPS); standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) are also present.

Common Use Cases and Queries

Typical usage centers on diagnosing why work items do or do not surface in an agent's queue. A common diagnostic joins nodes to their enumerators and media types:

• Queue content triage — query nodes for a specific resource and enumerator to inspect WHERE_CLAUSE, VIEW_NAME, and COUNT. Example: SELECT node_id, node_label, count, view_name, where_clause FROM ieu.ieu_uwq_sel_rt_nodes WHERE resource_id = :p_resource AND sel_enum_id = :p_enum AND not_valid = 'N';
• Hierarchy reconstruction — ordering by NODE_DEPTH and NODE_WEIGHT reproduces the selector tree as displayed to the agent.
• Empty-node suppression analysis — filtering on HIDE_IF_EMPTY distinguishes nodes intentionally hidden when COUNT is zero from those always rendered.
• Refresh monitoring — reviewing REFRESH_VIEW_NAME and REFRESH_VIEW_SUM_COL supports tuning of refresh jobs and detection of stale summaries.
• Design-to-runtime reconciliation — joining NODE_PID and SEL_ENUM_PID back to design-time selector definitions verifies that runtime state matches configuration.

Related Objects

• IEU_UWQ_MEDIA_TYPES_B — referenced via IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID, supplying media type definitions for each node.
• IEU_UWQ_SEL_ENUMERATORS — referenced via SEL_ENUM_ID, providing enumerator metadata that scopes the selector.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, enforcing multi-org security isolation.
• IEU_UWQ_RTNODE_BIND_VALS — child table whose SEL_RT_NODE_ID references this table's primary key, holding bind variable values applied to the node's WHERE_CLAUSE at execution.
• IEU_UWQ_SEL_RT_NODES_PK / _U1 / _U2 / _U3 — the primary key constraint and the three unique indexes that define business-key candidates and enforce uniqueness of run-time node definitions.