Results for “wf_mailer_parameters_u1”

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

Overview

APPLSYS.WF_MAILER_PARAMETERS is a configuration table in the Oracle E-Business Suite database that stores the runtime parameters used by the Oracle Workflow Notification Mailer. Each row represents a single named parameter for a specific Notification Mailer instance, allowing administrators to tune behavior such as mail retrieval frequency, attachment handling, and outbound message formatting without modifying application code. In EBS 12.1.1 and 12.2.2 the table resides in the APPS_TS_ARCHIVE tablespace and is registered in FND Design Data as FND.WF_MAILER_PARAMETERS, with a current status of VALID.

The ETRM metadata classifies this object as standalone for Data Vault purposes. In Data Vault modeling terms, it is best treated as a satellite (or, less commonly, a small hub) attached to the mailer instance identified by NAME; the absence of outgoing foreign keys apart from the hosting security group confirms that it does not participate in a shared link structure. This classification is a heuristic modeling suggestion rather than a documented constraint.

Key Information Stored

The table contains seven documented columns. The composite unique index WF_MAILER_PARAMETERS_U1 on (NAME, PARAMETER) is the business-key candidate and the object the user searched for; the ETRM schema does not document a separate surrogate primary key column, so the unique index effectively serves as the primary identifier.

• NAME (VARCHAR2, 12) — the instance name of the mailer; the first half of the unique business key.
• PARAMETER (VARCHAR2, 30) — the name of the parameter being configured; the second half of the unique business key.
• VALUE (VARCHAR2, 200) — the configured value for that parameter.
• REQUIRED (VARCHAR2) — flag indicating whether the parameter is mandatory.
• CB (VARCHAR2, 60) — a callback function used to validate the parameter value.
• ALLOW_RELOAD (VARCHAR2) — flag indicating whether the mailer can reload the parameter at runtime.
• SECURITY_GROUP_ID (VARCHAR2, 32) — identifier reserved for the hosting environment; this is the only column with a documented foreign key, referencing FND_SECURITY_GROUPS.

Common Use Cases and Queries

Administrators and support engineers query this table to diagnose Notification Mailer behavior, confirm which parameters are required, and determine which values can be changed without restarting the mailer. A typical pattern retrieves all parameters for a single mailer instance:

• SELECT NAME, PARAMETER, VALUE, REQUIRED, ALLOW_RELOAD FROM APPLSYS.WF_MAILER_PARAMETERS WHERE NAME = :instance_name ORDER BY PARAMETER;
• Filtering on REQUIRED = 'Y' isolates mandatory parameters that must be set for the mailer to start correctly.
• Filtering on ALLOW_RELOAD = 'Y' identifies parameters that may be adjusted at runtime without a bounce.
• Reporting by SECURITY_GROUP_ID supports multi-tenant or hosting-environment analysis.

The standard column list documented by ETRM is NAME, PARAMETER, VALUE, REQUIRED, CB, ALLOW_RELOAD, SECURITY_GROUP_ID, which can be used directly as a projection in custom queries.

Related Objects

The ETRM dependency data shows a standalone object: it references no database objects itself and is referenced only by the internal construct APPLSYS.WF_MAILER_PARAMETERS#. The significant relationships are:

• APPLSYS.FND_SECURITY_GROUPS — joined on WF_MAILER_PARAMETERS.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.
• APPLSYS.WF_MAILER_PARAMETERS# — the internal dependency object used by the Workflow Notification Mailer.
• Oracle Workflow Notification Mailer configuration screens and the Workflow Administrator responsibility, which read and write this table.
• Other WF_MAILER_* configuration tables, which together support mailer setup.