Results for “suppress_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The ALR.ALR_ACTION_SET_OUTPUTS table resides in the ALR (Alert) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the defined outputs associated with alert action sets — the values that an Oracle Alert can expose as results when an action set executes. In the Oracle Alert framework, action sets group one or more actions (such as concurrent program submissions, PL/SQL calls, or message deliveries) that run together in response to an alert condition. This table captures the named output elements that those action sets produce and expose to downstream consumers.
From a Data Vault modeling perspective, the mined foreign-key structure suggests a link classification, since the table's primary key is composed entirely of intersecting business keys referencing parent entities (ALR_ACTION_SETS, ALR_ALERTS) rather than holding descriptive transactional attributes on its own. This is a heuristic suggestion only; the presence of descriptive columns such as NAME, SEQUENCE, and SUPPRESS_FLAG means the table also exhibits satellite-like characteristics when viewed strictly as a physical design.
Key Information Stored
The primary key ALR_ACTION_SET_OUTPUTS_PK is a composite of APPLICATION_ID, ALERT_ID, ACTION_SET_ID, and NAME. A unique index ALR_ACTION_SET_OUTPUTS_U1 extends this business-key candidate to include ZD_EDITION_NAME, reflecting the Edition-Based Redefinition (EBR) model used in 12.2.2.
- APPLICATION_ID — identifies the owning Oracle application; participates in both the PK and both foreign keys.
- ALERT_ID — the alert that owns the parent action set.
- ACTION_SET_ID — the specific action set for which this output is defined.
- NAME — the business name of the output element; completes the primary key.
- SEQUENCE — ordering of outputs within the action set.
- SUPPRESS_FLAG — indicates whether the output is suppressed from exposure.
- SECURITY_GROUP_ID — supports multi-org / data security partitioning; referenced to
FND_SECURITY_GROUPS. - ZD_EDITION_NAME — EBR edition discriminator in 12.2.2.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle Applications WHO audit columns.
Common Use Cases and Queries
Typical queries enumerate the outputs configured for a given alert and action set, or audit which outputs are suppressed. A representative join pattern follows:
- List outputs for an alert:
SELECT o.NAME, o.SEQUENCE, o.SUPPRESS_FLAG FROM ALR.ALR_ACTION_SET_OUTPUTS o WHERE o.APPLICATION_ID = :app_id AND o.ALERT_ID = :alert_id ORDER BY o.SEQUENCE; - Trace outputs back to their action set definition by joining on
APPLICATION_IDandACTION_SET_IDtoALR_ACTION_SETS. - Filter by edition in 12.2.2:
WHERE ZD_EDITION_NAME = 'ORA$BASE'. - Reporting on suppressed versus active outputs across the alert catalog for governance reviews.
- Migration or cloning validation — verifying output rows reconcile between source and target instances.
Related Objects
- ALR_ACTION_SETS — parent; join on
APPLICATION_IDandACTION_SET_ID. - ALR_ALERTS — parent; join on
APPLICATION_IDandALERT_ID. - FND_SECURITY_GROUPS — referenced via
SECURITY_GROUP_IDfor data partitioning. - ALR_ACTION_SET_INPUTS — companion table holding action set inputs, sharing the same parent relationship.
- ALR_ACTIONS and ALR_ACTION_HISTORY — related to action set execution that produces these outputs.
-
Alert action set outputs
-
Alert action sets
-
Alert action set outputs
-
Table: FV_CFS_REP_LINES 12.2.2
-
Alert action sets
-
View: CZ_EXPLMODEL_NODES_V 12.1.1
APPS.CZ_EXPLMODEL_NODES_V·↳ CZ_DEVL_PROJECTS·↳ CZ_MODEL_REF_EXPLS·↳ CZ_PS_NODES·Explore CZ module →
-
APPS.CZ_EXPLNODES_IMAGE_EFF_V·↳ CZ_DEVELOPER_UTILS_PVT·↳ CZ_EXPLMODEL_NODES_V·↳ CZ_LOCALIZED_TEXTS_VL·Explore CZ module →
-
View: CZ_EXPLMODEL_NODES_V 12.2.2
APPS.CZ_EXPLMODEL_NODES_V·↳ CZ_DEVL_PROJECTS·↳ CZ_MODEL_REF_EXPLS·↳ CZ_PS_NODES·Explore CZ module →
-
APPS.CZ_EXPLNODES_WITHIMAGES_V·↳ CZ_DEVELOPER_UTILS_PVT·↳ CZ_EXPLMODEL_NODES_V·↳ CZ_LOCALIZED_TEXTS_VL·Explore CZ module →
-
APPS.CZ_EXPLNODES_WITHIMAGES_V·↳ CZ_DEVELOPER_UTILS_PVT·↳ CZ_EXPLMODEL_NODES_V·↳ CZ_LOCALIZED_TEXTS_VL·Explore CZ module →
-
APPS.CZ_EXPLNODES_IMAGE_EFF_V·↳ CZ_DEVELOPER_UTILS_PVT·↳ CZ_EXPLMODEL_NODES_V·↳ CZ_LOCALIZED_TEXTS_VL·Explore CZ module →
-
VIEW: FV.FV_CFS_REP_LINES# 12.2.2
-
VIEW: ALR.ALR_ACTION_SETS# 12.2.2
-
VIEW: ALR.ALR_ACTION_SETS# 12.2.2
-
VIEW: FV.FV_CFS_REP_LINES# 12.2.2
-
TABLE: ALR.ALR_ACTION_SETS 12.1.1
-
TABLE: ALR.ALR_ACTION_SETS 12.2.2
-
TABLE: FV.FV_CFS_REP_LINES 12.2.2
-
PACKAGE: APPS.QA_ALERT_PKG 12.1.1
-
PACKAGE BODY: APPS.QLTCPDFB 12.1.1