Results for “return_mail_action”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.ALR_RESPONSE_ACTIONS_VIEW is a reporting and integration artifact within the Oracle Alert (ALR) module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It consolidates the set of valid response actions that may be presented to a user when an Oracle Alert fires, resolving the underlying action definitions and business-meaning lookups into a single flat result set. Its principal role is to support the Oracle Alert response-processing framework and any custom reporting, concurrent processing, or integration layer that must enumerate the response actions available to a given alert. The view is owned by the APPS schema and is exposed through the standard EBS synonym layer.
The view is of particular relevance to the RETURN_MAIL_ACTION lookup, which governs the reply actions offered to an alert recipient (for example, replying to the alert notification with a designated disposition such as "approve," "reject," or similar). Because that lookup is merged into the view via a UNION ALL, this object provides a unified catalogue covering both standard, database-level actions stored in ALR_ACTIONS and the return-mail action family defined solely in the lookup tables.
Underlying Base Objects
The view is defined over two documented base objects, both referenced through APPS synonyms: ALR_ACTIONS and ALR_LOOKUPS. The ETRM metadata for the view confirms these as the only referenced base objects. ALR_ACTIONS stores alert action definitions, including the action type, level, description, and enabled status. ALR_LOOKUPS is the standard EBS lookup repository and is joined on LOOKUP_TYPE = 'ACTION_TYPE' to translate the stored ACTION_TYPE code into a user-facing meaning.
The two branches of the UNION are structurally distinct. The first branch selects enabled actions from ALR_ACTIONS where ACTION_LEVEL_TYPE = 'D', joined to the ACTION_TYPE lookup. The second branch synthesizes return-mail action rows solely from ALR_LOOKUPS, joining LOOKUP_TYPE = 'RETURN_MAIL_ACTION' to ACTION_TYPE where LOOKUP_CODE = 'M'. This second branch supplies literal values of -2 for the identifying columns and 'Y' for ENABLED_FLAG, since there is no corresponding ALR_ACTIONS row.
Key Columns
APPLICATION_ID— owning application identifier; literal-2for return-mail action rows.ALERT_ID— alert with which the action is associated;-2for return-mail action rows.NAME— action name; for return-mail rows this carries theRETURN_MAIL_ACTIONlookup meaning.ACTION_ID— surrogate action identifier;-2for return-mail rows.ACTION_TYPE— action type code; resolves to'M'for return-mail rows.ACTION_TYPE_MEANING— decoded meaning of the action type from theACTION_TYPElookup.DESCRIPTION— descriptive text for the action or return-mail lookup.ENABLED_FLAG— enablement indicator; the view restricts standard actions to'Y'and hard-codes'Y'for return-mail rows.
Common Use Cases and Queries
Typical uses include populating LOVs on alert response forms, driving workflow or concurrent logic that branches on the selected response action, and building custom reports enumerating all response actions available to alert recipients. A representative query lists all available response actions and their decoded type meanings:
SELECT ACTION_TYPE, ACTION_TYPE_MEANING, NAME, DESCRIPTION FROM APPS.ALR_RESPONSE_ACTIONS_VIEW ORDER BY ACTION_TYPE_MEANING, NAME;- Filtering return-mail responses specifically:
SELECT NAME, DESCRIPTION FROM APPS.ALR_RESPONSE_ACTIONS_VIEW WHERE ACTION_TYPE = 'M'; - Scoping to a specific application:
SELECT * FROM APPS.ALR_RESPONSE_ACTIONS_VIEW WHERE APPLICATION_ID = :app_id;
Because the view already filters on ENABLED_FLAG = 'Y', no additional enablement predicate is required. Reporting against it does not modify alert configuration, confirming its role as a read-only reporting and integration resource.
-
All the defined action plus the pre-defined action "Return Original Mail"
APPS.ALR_RESPONSE_ACTIONS_VIEW·↳ ALR_ACTIONS·↳ ALR_LOOKUPS·Explore ALR module →
-
All the defined action plus the pre-defined action "Return Original Mail"
APPS.ALR_RESPONSE_ACTIONS_VIEW·↳ ALR_ACTIONS·↳ ALR_LOOKUPS·Explore ALR module →