Search Results launch_publish_wf

Overview

MSC_X_WFNOTIFY_PKG is an Oracle Applications (APPS) schema PL/SQL package belonging to the Advanced Supply Chain Planning (ASCP) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to generate and dispatch Oracle Workflow notifications related to supply chain planning activities — most notably the distribution of planning results, exception messages, and supply/demand publishing events to planners, suppliers, and trading partners. The package acts as a bridge between ASCP planning engines (such as the Supply Chain Engine publish processes) and the Oracle Workflow notification infrastructure, ensuring that relevant users receive timely alerts when plan data or supply commitments change.

The package is documented as VALID in the ETRM repository and is classified as API type OTHER, indicating it is not a public, supported open interface but rather an internal utility invoked by other ASCP packages and concurrent programs.

Key Procedures and Functions

The ETRM metadata documents four procedures/functions within the package:

• LAUNCH_WF — The core routine responsible for initiating a Oracle Workflow notification process. It typically determines the recipient, builds the notification payload, and hands control to the Workflow engine's start mechanism.
• WFSTART — A wrapper that formalizes the Workflow start call, typically invoking the WF_NOTIFICATION or WF_ENGINE APIs supplied by the Oracle Workflow schema to instantiate the workflow process for the intended recipients.
• GETMESSAGE — A retrieval function that assembles or fetches the notification message text/body to be delivered, drawing message content from planning tables and lookup values.
• LAUNCH_PUBLISH_WF — A specialized launcher that initiates notifications specifically tied to publishing operations (e.g., supply commitment publishing), coordinating with the SCE publish packages.

Parameter lists are not documented in the ETRM excerpt and are therefore not reproduced here.

Tables Accessed

The package reads from and, where applicable, writes to a broad set of ASCP and shared reference tables accessed through APPS synonyms. Documented dependencies include:

• MSC_SUP_DEM_ENTRIES — supply/demand entry records; the sole direct table dependency explicitly listed in the ETRM excerpt.
• MSC_COMPANIES, MSC_COMPANY_RELATIONSHIPS, MSC_COMPANY_SITES — company and site master data used to resolve recipients and organizational context.
• MSC_TRADING_PARTNERS, MSC_TRADING_PARTNER_MAPS, MSC_PARTNER_CONTACTS — trading partner and contact details for supplier-facing notifications.
• MSC_PLANNERS, MSC_PLAN_ORGANIZATIONS — planner-to-organization assignments for routing alerts.
• MSC_ITEMS, MSC_SYSTEM_ITEMS — item validation and descriptive data included in messages.
• MSC_CL_REFRESH_S, MSC_EXCEPTION_PREFERENCES — refresh status and user-defined exception notification preferences.
• FND_LOOKUP_VALUES, FND_USER — reference lookups and Workflow/application user identity resolution.

Usage Notes

MSC_X_WFNOTIFY_PKG is an internal package rather than a directly callable user API. It is referenced by three other ASCP packages — MSC_SCE_PUBLISH_PKG, MSC_SCE_PUB_SUPPLY_COMMIT_PKG, and MSC_X_EX5_PKG — and it recursively references itself, confirming extensive internal reuse. In practice it is invoked during supply chain publish runs and planning exception generation, when the ASCP engine decides a Workflow notification must be sent. Because the package is classified as OTHER and not a public interface, customizations should not call it directly; instead, Oracle-supported extension points or the underlying Workflow APIs should be used. Modification of this package risks breaking the publish and exception notification flows across the ASCP module.