Search Results wf_mailer_parameters




Overview
Explore in AI Chat

Overview

WF_MAILER_PARAMETERS is a configuration table owned by the APPLSYS schema within the Oracle E-Business Suite environment. It is a member of the FND - Application Object Library product family and serves a specific, well-defined purpose: it stores the runtime parameters used by the Oracle Workflow Notification Mailer, effectively replacing the legacy file-based configuration approach that was previously managed through the wfmail.cfg text file. In earlier releases, administrators configured the mailer by editing a flat file on the application server; beginning with the introduction of this table, those same settings are persisted in the database, allowing configuration to be managed through the standard EBS administrative interfaces and to travel with the database rather than residing on an individual application tier.

In a heuristic Data Vault model, this table would be classified as standalone. The Data Vault classification mined from the foreign key structure indicates no dependent links or satellites, which is consistent with its role as a reference/configuration store rather than a transactional or historical record. Any Data Vault implementation should treat it as a standalone reference table or, at most, a simple satellite attached to a security-group hub.

Key Information Stored

The table contains seven documented columns that together define an individual mailer configuration setting:

  • NAME — Identifies the logical configuration group or named parameter set. Together with PARAMETER, it forms the documented unique business key WF_MAILER_PARAMETERS_U1.
  • PARAMETER — The specific setting name within the group (for example, a mail host, port, or processing directive). Also part of the unique index.
  • VALUE — The actual configured value assigned to the named parameter; this is the operational payload of the row.
  • REQUIRED — A flag indicating whether the parameter must be supplied for the mailer to function correctly, useful for validation and diagnostics.
  • ALLOW_RELOAD — Indicates whether the parameter may be reloaded dynamically without restarting the mailer service.
  • CB — A context/change-back control column, typically holding audit or created-by style information used by the configuration framework.
  • SECURITY_GROUP_ID — The foreign key to FND_SECURITY_GROUPS, scoping the parameter set to a particular security group or operating context.

The documented schema does not expose a separate surrogate primary key beyond the columns listed; the unique index WF_MAILER_PARAMETERS_U1 on (NAME, PARAMETER) serves as the primary business-key candidate, with SECURITY_GROUP_ID acting as the contextual discriminator.

Common Use Cases and Queries

The most frequent use of this table is administrative troubleshooting of Workflow Notification Mailer behavior. DBAs and workflow administrators query it to confirm the effective configuration when mail is not being sent, is being processed incorrectly, or after a patch or clone. A typical diagnostic query retrieves all settings for a given parameter group:

  • SELECT name, parameter, value, required FROM wf_mailer_parameters WHERE name = :group ORDER BY parameter;
  • Identify required settings that are missing or empty: SELECT parameter FROM wf_mailer_parameters WHERE required = 'Y' AND (value IS NULL OR value = '');
  • List parameters eligible for dynamic reload: SELECT name, parameter, value FROM wf_mailer_parameters WHERE allow_reload = 'Y';

Reporting use cases include auditing changes against a known-good baseline after cloning production to test, and documenting the mailer configuration as part of an environment build record. Because the table replaced a flat file, comparison queries are often used to verify that migrated settings match the original wfmail.cfg content.

Related Objects

  • FND_SECURITY_GROUPS — referenced via WF_MAILER_PARAMETERS.SECURITY_GROUP_ID; the only documented foreign key relationship.
  • WF_NOTIFICATIONS — indirectly dependent, since the mailer consumes its parameters to deliver notification e-mails.
  • WF_NOTIFICATION_ATTRIBUTES — supplies the content rendered into the e-mails that the configured mailer sends.
  • FND_SVC_COMP_PARAMETERS — conceptually related configuration store used by FND service components, useful for cross-referencing mailer service settings.
  • WF_SYSTEM_PROPERTIES — related Workflow configuration surface; the two are frequently examined together during mailer diagnostics.