Results for “alr_valid_responses”

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

Overview

The ALR_VALID_RESPONSES table, owned by the ALR schema, stores the response text associated with each permissible response to an Oracle Alert message. Within Oracle EBS 12.1.1 and 12.2.2, Oracle Alert (ALR) enables the definition of alerts that fire based on database events or periodic checks. When an alert is raised, recipients may be presented with a predefined set of possible responses — for example, "Approve," "Reject," or "Escalate." The ALR_VALID_RESPONSES table holds the master definition of these permissible responses, linking each response to its parent alert and response set. It sits at the intersection of alert definition and response capture, forming the reference data against which actual responses are recorded and response messages are generated.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. Because it carries descriptive attributes (response name, response text, type) keyed to a parent business key, it behaves like a satellite attached to the alert and response-set hubs rather than a pure hub or link. This classification is offered as a modeling suggestion, not a definitive architectural statement.

Key Information Stored

The table contains 14 documented columns. The composite primary key, enforced by the ALR_VALID_RESPONSES_PK constraint, comprises APPLICATION_ID, ALERT_ID, RESPONSE_SET_ID, and RESPONSE_ID. A separate unique index, ALR_VALID_RESPONSES_U1, covers APPLICATION_ID, RESPONSE_ID, and ZD_EDITION_NAME, marking a business-key candidate.

• APPLICATION_ID — Identifies the application context of the alert; part of the primary key and a foreign reference to ALR_ALERTS and ALR_RESPONSE_SETS.
• ALERT_ID — The parent alert to which this valid response belongs.
• RESPONSE_SET_ID — Groups related responses into a set associated with the alert.
• RESPONSE_ID — The individual response identifier within the set.
• RESPONSE_NAME — The short display label of the response presented to the recipient.
• RESPONSE_TEXT — The full descriptive text for the response, typically the message conveyed or instruction shown.
• TYPE — Classifies the response type, distinguishing behavioral categories.
• SECURITY_GROUP_ID — Foreign reference to FND_SECURITY_GROUPS, supporting multi-org/data security partitioning.
• ZD_EDITION_NAME — Editioning column used in 12.2 Online Patching for edition-based redefinition.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard WHO audit tracking.

Common Use Cases and Queries

Typical scenarios include listing all permissible responses for a given alert, validating configuration of alert response sets, and reporting on responses captured for audit purposes.

Listing valid responses for an alert:

• SELECT RESPONSE_ID, RESPONSE_NAME, RESPONSE_TEXT FROM ALR.ALR_VALID_RESPONSES WHERE APPLICATION_ID = :app_id AND ALERT_ID = :alert_id AND RESPONSE_SET_ID = :set_id ORDER BY RESPONSE_ID;

Joining to actual responses to compare expected versus captured outcomes:

• SELECT v.RESPONSE_NAME, a.RESPONSE_ID FROM ALR.ALR_VALID_RESPONSES v, ALR.ALR_ACTUAL_RESPONSES a WHERE v.APPLICATION_ID = a.APPLICATION_ID AND v.ALERT_ID = a.ALERT_ID AND v.RESPONSE_SET_ID = a.RESPONSE_SET_ID AND v.RESPONSE_ID = a.RESPONSE_ID;

Reporting on response message text tied to valid responses uses a similar join to ALR_RESPONSE_MESSAGES on the same four key columns.

Related Objects

The table participates in several documented relationships:

• ALR_ALERTS — Referenced via APPLICATION_ID and ALERT_ID; the parent alert definition.
• ALR_RESPONSE_SETS — Referenced via APPLICATION_ID, ALERT_ID, RESPONSE_SET_ID; the grouping of responses.
• ALR_ACTUAL_RESPONSES — Child table referencing this table on APPLICATION_ID, ALERT_ID, RESPONSE_SET_ID, and RESPONSE_ID.
• ALR_RESPONSE_MESSAGES — Child table referencing the same four columns, holding message content for responses.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for data security partitioning.