Search Results alr_action_set_inputs




Overview
Explore in AI Chat

Overview

The ALR_ACTION_SET_INPUTS table is a core data object within the Oracle E-Business Suite Alert (ALR) module. It functions as the repository for input parameters associated with action sets, which are sequences of automated responses triggered by an alert. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is essential for the runtime execution of alert actions, as it stores the specific values or variable names that are passed to the actions defined within a set. These inputs enable the dynamic and flexible operation of alerts, allowing actions like concurrent program submissions, SQL script executions, or message deliveries to utilize data from the triggering alert event or from user-defined sources.

Key Information Stored

The table's structure is defined by a composite primary key that ensures uniqueness within the context of a specific alert and action set. The key columns, as documented in the ETRM, are APPLICATION_ID, ALERT_ID, ACTION_SET_ID, and NAME. The NAME column stores the identifier for the input parameter. While the ETRM excerpt does not list all columns, typical columns in such a table would include VALUE or a similar column to hold the actual input data, and potentially a SEQUENCE column to order multiple inputs. The foreign key relationships to ALR_ALERTS and ALR_ACTION_SETS enforce critical referential integrity, ensuring every input record is linked to a valid parent alert and a defined action set within that alert.

Common Use Cases and Queries

This table is primarily accessed during the processing of an alert. When an alert condition is met, the Alert Manager retrieves the associated action sets and their corresponding inputs from this table to execute the actions. Common administrative and diagnostic queries involve listing all inputs for a specific alert or troubleshooting why an action is failing due to missing or incorrect parameter values. A typical reporting query might be:

  • SELECT name, value FROM alr_action_set_inputs WHERE application_id = :app_id AND alert_id = :alert_id AND action_set_id = :set_id ORDER BY sequence;

This pattern is used to verify the configuration of inputs passed to a concurrent program or a shell script action, ensuring the correct substitution variables or literal values are in place.

Related Objects

As indicated by its foreign keys, ALR_ACTION_SET_INPUTS has a direct and dependent relationship with two primary Alert tables. The ALR_ALERTS table is the master definition for all alerts in the system, while the ALR_ACTION_SETS table defines the groups of actions to be performed. This table is a child of both. Furthermore, the inputs stored here are utilized by the underlying Alert processing engine and APIs. While not explicitly listed in the provided metadata, related objects often include ALR_ACTION_SET_MEMBERS (which defines the actions within a set) and the various ALR_ACTION_* tables for specific action types (e.g., ALR_ACTION_CONC_PROGS), which may consume these inputs during execution.