Search Results alr_response_variable_values




Overview
Explore in AI Chat

Overview

The ALR_RESPONSE_VARIABLE_VALUES table is a core data repository within the Oracle E-Business Suite Alert module (ALR). It functions as the definitive store for the actual data values returned by an alert when it is executed. When an alert's periodic or event-driven logic is triggered, it generates a response message containing specific output values from the database. This table captures those dynamic, runtime values, linking them to the specific alert instance and the recipient's response. Its role is critical for audit trails, response processing, and historical analysis of alert executions across both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a specific variable value within a specific alert response instance. Its primary key is a composite of NODE_HANDLE, MESSAGE_HANDLE, and VARIABLE_NAME. The NODE_HANDLE and MESSAGE_HANDLE columns act as foreign keys to the ALR_ACTUAL_RESPONSES table, pinpointing the exact execution and recipient. The VARIABLE_NAME column stores the identifier of the alert variable or output column. While the provided metadata does not list all columns, the table's description implies the presence of at least one column (e.g., VARIABLE_VALUE) to hold the actual returned data. Other key foreign key columns include APPLICATION_ID, ALERT_ID, and RESPONSE_SET_ID, which link the data back to the master alert definition (ALR_ALERTS) and its response options (ALR_RESPONSE_SETS).

Common Use Cases and Queries

A primary use case is auditing and troubleshooting alert executions. Administrators can query this table to verify what data was sent to a recipient, which is essential for diagnosing missing or incorrect alert notifications. Another scenario is generating historical reports on alert outputs for business analysis. A typical query pattern involves joining to ALR_ALERTS and ALR_ACTUAL_RESPONSES to provide context.

  • Sample Query: To retrieve all variable values for a specific alert execution node:
    SELECT arvv.variable_name, arvv.variable_value
    FROM alr_response_variable_values arvv
    WHERE arvv.node_handle = '<specific_node_handle>'
    ORDER BY arvv.variable_name;
  • Reporting Use Case: Correlating alert outputs with user responses to analyze trends or compliance, often by joining ALR_RESPONSE_VARIABLE_VALUES with ALR_ACTUAL_RESPONSES and FND_USER.

Related Objects

The table maintains defined foreign key relationships with several key Alert tables, as documented in the provided metadata:

  • ALR_ALERTS: Links via APPLICATION_ID and ALERT_ID. This relationship ties the runtime variable values to the master definition of the alert.
  • ALR_RESPONSE_SETS: Links via APPLICATION_ID, ALERT_ID, and RESPONSE_SET_ID. This connects the output values to the set of possible actions a recipient could take.
  • ALR_ACTUAL_RESPONSES: Links via NODE_HANDLE and MESSAGE_HANDLE. This is the most direct relationship, anchoring each variable value to a specific instance of an alert message sent to a specific user.