Results for “node_handle”

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

Overview

The ALR.ALR_RESPONSE_VARIABLE_VALUES table is a core transactional data object within the Oracle Alert (ALR) module of Oracle E-Business Suite. It stores the actual variable values and alert output values that are returned in a response message generated by an Oracle Alert. When an alert action produces a response — for example, an email notification, a concurrent program invocation, or a formatted message containing runtime variables — this table captures the resolved value of each variable at the moment the response was produced. It therefore serves as the persistent record of "what actually fired" for a given alert response, complementing the alert definition metadata and the response set configuration.

From a data modeling perspective, the mined foreign-key structure suggests this object behaves as a link table in a Data Vault sense. It resolves many-to-many style relationships between a specific actual response (identified by NODE_HANDLE and MESSAGE_HANDLE) and the variable definitions attached to an alert and its response set. Rather than acting as a standalone hub entity, it connects response instances to their constituent variable/value pairs.

Key Information Stored

The table is documented with ten columns, of which the most operationally significant are summarized below.

• NODE_HANDLE, MESSAGE_HANDLE, VARIABLE_NAME — Together these form the composite primary key ALR_RESPONSE_VAR_VALUES_PK and the unique index ALR_RESPONSE_VAR_VALUES_U1. They are the business-key candidates that uniquely identify a single variable value within a response message. NODE_HANDLE and MESSAGE_HANDLE tie the row to a specific actual response instance, while VARIABLE_NAME identifies which variable was evaluated.
• VALUE — The resolved, runtime value of the named variable as it appeared in the response message.
• DATA_TYPE — The data type classification of the variable, indicating how the value should be interpreted.
• DETAIL_MAX_LEN — The maximum length permitted for the value detail, governing how much of the value can be stored or displayed.
• APPLICATION_ID, ALERT_ID, RESPONSE_SET_ID — Foreign-key columns linking the value back to its owning alert and the response set that defined the variables.
• SECURITY_GROUP_ID — Supports Oracle's multi-org / security group access model, referencing FND_SECURITY_GROUPS.

These columns collectively capture both the identity of the response (via the handles) and the semantic content of each returned variable.

Common Use Cases and Queries

Typical uses include auditing which values an alert actually emitted, debugging variable resolution in response templates, and building reporting on alert output history.

• Retrieve all values for a specific response:

  SELECT variable_name, value, data_type
  FROM   alr.alr_response_variable_values
  WHERE  node_handle = :node_handle
  AND    message_handle = :message_handle;

• Trace values back to an alert:

  SELECT v.variable_name, v.value, a.alert_name
  FROM   alr.alr_response_variable_values v,
         alr.alr_alerts a
  WHERE  v.application_id = a.application_id
  AND    v.alert_id       = a.alert_id;

• Filter by response set: join on APPLICATION_ID, ALERT_ID, and RESPONSE_SET_ID to isolate the variables produced by a particular response set configuration.
• Reporting: aggregate on VARIABLE_NAME to determine which variables most frequently appear in alert responses, or analyze DATA_TYPE distribution.

Related Objects

The following objects are directly referenced through the documented foreign keys and are the most relevant companions for joins and integrity analysis.

• ALR_ACTUAL_RESPONSES — Parent of the value rows via NODE_HANDLE and MESSAGE_HANDLE; represents the response instance itself.
• ALR_ALERTS — Joined on APPLICATION_ID and ALERT_ID; supplies alert definition context.
• ALR_RESPONSE_SETS — Joined on APPLICATION_ID, ALERT_ID, and RESPONSE_SET_ID; defines the response set to which variables belong.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access control and multi-org security.

Together these relationships make ALR_RESPONSE_VARIABLE_VALUES the detailed value-level companion to the alert response infrastructure, enabling traceability from an alert definition through to the exact values it returned at runtime.