Search Results disable_recipient_ntf_pref

Overview

APPS.WF_MAIL is a core Oracle Workflow PL/SQL package responsible for the construction, routing, and delivery of e-mail notifications generated by the Oracle E-Business Suite Workflow engine. Within Oracle EBS 12.1.1 and 12.2.2, WF_MAIL bridges the Workflow Notification System and the underlying mail transport layer, assembling notification bodies, resolving recipients, embedding LOB and URL content, and handling delivery responses. Because notifications underpin approvals, alerts, and business event messaging across modules such as Purchasing, Order Management, and Alert Management, WF_MAIL is a foundational utility rather than an end-user application component. The package is owned by the APPS schema and is documented as VALID in ETRM for 12.2.2, with an API classification of OTHER. It exposes 61 documented procedures and functions and is referenced by seven other packages, confirming its central role in the notification pipeline.

Key Procedures and Functions

The documented entry points fall into several functional clusters:

• Status and error handling: UPDATESTATUS, UPDATESTATUS2, RESETFAILED, HANDLESENDERROR, and HANDLERESPONSEERROR manage notification delivery state, retry failed mail deliveries, and process errors returned by the mail subsystem.
• Content assembly and formatting: GETMESSAGE, GETSUMMARY, GETSUMMARY2, and WORDWRAP build and format the notification body text, including wrapping long lines for readability across mail clients.
• Large object handling: GETLOBMESSAGE, GETLOBMESSAGE2, GETLOBMESSAGE3, GETLOBMESSAGE4, INITFETCHLOB, FETCHLOBCONTENT, and CLOSELOB retrieve and iterate over LOB content attached to or embedded in notifications.
• Content retrieval and context: FETCHURLCONTENT retrieves content referenced by URL, while SETCONTEXT establishes the runtime environment used during message processing.
• Recipient preferences: DISABLE_RECIPIENT_NTF_PREF controls notification preference behavior for recipients, and GETWARNING surfaces warning conditions encountered during processing.

These routines are predominantly internal helpers invoked by WF_NOTIFICATION and related packages rather than being called directly by end users.

Tables Accessed

WF_MAIL reads and writes against the Workflow notification and event data model through APPS synonyms. WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES, and the related TL table store the notification record, its translatable attributes, and message text. WF_MESSAGE_ATTRIBUTES and WF_MESSAGE_ATTRIBUTES_TL supply message definition metadata. WF_EVENTS, WF_EVENT_T, and WF_EVENT_SUBSCRIPTIONS provide event context and subscription resolution. WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, and WF_ITEM_ACTIVITY_STATUSES_H give workflow item and activity state, used to determine notification routing and status. WF_AGENTS and WF_AGENT_T resolve recipient and role information. WF_COMMENTS stores notification comments, FND_TERRITORIES supports locale-specific formatting, and WF_NTF_SECURITY_POLICIES enforces notification security rules.

Usage Notes

WF_MAIL is normally invoked indirectly. The Oracle Workflow Notification Mailer relies on it when sending notifications, and packages such as WF_NOTIFICATION, WF_DIAGNOSTICS, WF_XML, WFA_HTML, ALR_MLR_PACKAGE, OKC_REPORT_PVT, and OKE_K_APPROVAL_WF call into it. Customizations that generate or extend Workflow notifications may reference WF_MAIL routines for content assembly, LOB handling, or status updates, but direct modification of this package is not supported. Diagnostic tasks, such as reviewing failed mail delivery, may surface WF_MAIL behavior through the Workflow Administrator responsibility. Because it is a seeded, VALID APPS package in both 12.1.1 and 12.2.2, its behavior is consistent across those releases, and any custom code should call the documented procedures without assuming internal parameter signatures, which are not published in the ETRM excerpt.