Results for “alr_variables_and_outputs”

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

Overview

The ALR_VARIABLES_AND_OUTPUTS view is a dictionary object owned by the APPS schema within the Oracle E-Business Suite Alert (ALR) product. Its documented purpose is to expose the response variables and alert outputs that belong to an alert definition or an alert response set. In ETRM 12.1.1 and 12.2.2 the object is registered with a status of VALID and is classified as a VIEW, meaning it holds no data of its own and instead projects a consolidated result set drawn from two underlying Alert tables.

Functionally, the view acts as a unified name registry. Alerts in Oracle Alert can emit two categories of named entities: output values produced when an alert action executes, and response variables that capture values returned from a response set such as a periodic alert action or an action set. By presenting both categories through a single, uniformly shaped result set, the view allows forms, concurrent programs, and custom integrations to resolve the names of alert outputs and response variables without querying two separate base objects. This makes it particularly useful for metadata-driven reporting, where the name and owning alert or application must be resolved generically.

Underlying Base Objects

The ETRM metadata records the referenced base objects as ALR_ALERT_OUTPUTS and ALR_RESPONSE_VARIABLES, both exposed to the APPS schema as synonyms. The view is defined as a UNION of two queries over these objects. The first branch selects APPLICATION_ID, ALERT_ID, RESPONSE_SET_ID, and NAME from ALR_RESPONSE_VARIABLES. The second branch selects APPLICATION_ID, ALERT_ID, and NAME from ALR_ALERT_OUTPUTS, supplying a literal TO_NUMBER(NULL) in the RESPONSE_SET_ID position so that both branches return an identical four-column structure. The UNION operator additionally removes duplicate rows across the combined result set.

Key Columns

• APPLICATION_ID — Identifies the application that owns the alert definition, joining to the application registry.
• ALERT_ID — Identifies the specific alert to which the output or response variable belongs.
• RESPONSE_SET_ID — Identifies the response set for response variables. Because alert outputs are not associated with a response set, this column is populated with NULL for rows originating from ALR_ALERT_OUTPUTS. This nullability is the key discriminator between the two source categories.
• NAME — The defined name of the alert output or response variable.

Common Use Cases and Queries

A frequent use is enumerating the complete set of named entities available to a given alert, for example when building configuration reports or validating custom integrations that reference alert outputs by name.

 SELECT application_id, alert_id, response_set_id, name
   FROM apps.alr_variables_and_outputs
  WHERE alert_id = :p_alert_id
  ORDER BY name;

To isolate only alert outputs, filter on the null response set identifier; to isolate only response variables, filter for non-null values:

 SELECT name
   FROM apps.alr_variables_and_outputs
  WHERE alert_id = :p_alert_id
    AND response_set_id IS NULL;

Because RESPONSE_SET_ID is null for output rows, the view also supports name-existence checks before an alert action references an output or variable, and joins back to ALR_ALERTS on ALERT_ID to resolve alert names for cross-application reporting.