Results for “tag_id”

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

Overview

WF_MAILER_TAGS is a configuration table owned by the APPLSYS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND — Application Object Library product family and serves as the repository of Workflow Mailer tag definitions. Its documented purpose is to replace the legacy wfmail.tag file, which historically stored the tag vocabulary used by the Workflow Notification Mailer to parse inbound e-mail replies and generate outbound notification messages. By moving this configuration into a database table, Oracle made the tag definitions queryable, maintainable, and transportable across environments through standard configuration and cloning mechanisms rather than through file-system edits.

From a Data Vault modeling perspective, the mined metadata classifies this object as standalone, meaning no parent-child hub/link/satellite chain is implied by its own foreign-key topology. In practice, WF_MAILER_TAGS behaves as a reference or lookup table: each row defines one mailer tag (for example, an action keyword such as APPROVE or REJECT) together with the parsing pattern that the mailer uses to recognize it. The table is therefore configuration data rather than transactional data, and it is typically seeded at installation and modified only when administrators extend or customize the Workflow Mailer's response vocabulary.

Key Information Stored

The table contains seven documented columns. The most important are:

• NAME — The business identifier of the tag. Together with TAG_ID and ZD_EDITION_NAME, it forms the unique index WF_MAILER_TAGS_U1, making it the primary business-key candidate for the row.
• TAG_ID — A numeric identifier participating in the unique index and in the foreign-key relationship to MTL_PHYSICAL_INVENTORY_TAGS.
• ACTION — Defines the workflow action the mailer should take when the tag is recognized, linking the tag vocabulary to notification processing behavior.
• PATTERN — The text or regular-expression pattern the mailer matches against inbound message content to detect the tag.
• ALLOW_RELOAD — A control flag governing whether the tag definition can be reloaded into the running mailer without a restart.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, partitioning the tag definition by the standard EBS security group (operating unit) model.
• ZD_EDITION_NAME — The editioning column introduced by the EBS online patching architecture in 12.2.x; it participates in the unique key and isolates edition-specific rows.

The surrogate primary key is TAG_ID; the business key candidate is the composite (NAME, TAG_ID, ZD_EDITION_NAME) documented in unique index WF_MAILER_TAGS_U1.

Common Use Cases and Queries

Administrators most often query this table when troubleshooting why the Workflow Notification Mailer does not respond to a particular reply keyword, or when auditing the tag vocabulary configured for a specific security group. A typical diagnostic query filters by the business key:

• SELECT name, action, pattern, allow_reload FROM applsys.wf_mailer_tags WHERE name = :tag_name;
• SELECT name, action FROM applsys.wf_mailer_tags WHERE security_group_id = :sgid ORDER BY name;
• Joining to the security group to confirm operating-unit scoping: SELECT t.name, t.action, s.security_group_key FROM applsys.wf_mailer_tags t, applsys.fnd_security_groups s WHERE t.security_group_id = s.security_group_id;

Reporting use cases include inventorying all active tags before an upgrade to confirm customizations will survive cloning, and verifying that ALLOW_RELOAD settings are consistent across environments. Because this is reference data, change control and comparison against the seeded baseline are the main governance activities.

Related Objects

• FND_SECURITY_GROUPS — Referenced by WF_MAILER_TAGS.SECURITY_GROUP_ID; defines the security group each tag belongs to.
• MTL_PHYSICAL_INVENTORY_TAGS — Referenced by WF_MAILER_TAGS.TAG_ID, the documented foreign-key source for the tag identifier.
• WF_MAILER_ATTRIBUTES — Companion Workflow Mailer configuration table holding mailer-level settings.
• WF_NOTIFICATIONS — Consumes the notification messages that the mailer builds using these tag definitions.
• WF_NOTIFICATION_ATTRIBUTES — Stores notification values acted upon when a recognized tag is processed.
• WF_MAILER_TAGS_U1 — Unique index enforcing the (NAME, TAG_ID, ZD_EDITION_NAME) business key.
• FND_LOOKUPS — Frequently consulted alongside this table for related FND-level reference values.

These relationships should be treated as modeling suggestions; the authoritative constraints are those defined in the APPLSYS schema for the specific EBS release in use.