Search Results umx_proxy_ntf_wf




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.UMX_PROXY_NTF_WF is a User Management (UMX) component in Oracle E-Business Suite that integrates the proxy notification subsystem with Oracle Workflow. Its purpose is to launch a workflow process associated with proxy notifications, thereby driving the routing, delivery, and lifecycle of notifications generated when users configure proxy assignments in EBS. The UMX_ prefix, combined with the WF suffix, indicates that this package acts as the Workflow-facing bridge for the proxy notification feature rather than holding the notification data itself. Its documented status is VALID in both 12.1.1 and 12.2.2, and its API classification in ETRM is recorded as OTHER, reflecting that it is an internal supporting package rather than a public developer API.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function for this package body:

  • LAUNCH_WORKFLOW — The sole documented entry point. As its name implies, this routine initiates a Workflow process related to a proxy notification. It is responsible for assembling the workflow item, supplying the necessary item attributes (such as the notification identifier and user context), and delegating execution to the Workflow engine so that the notification is processed and delivered according to the configured workflow definition. No parameter list is documented in the ETRM metadata, so the exact signature is not reproduced here; the procedure is described only by purpose.

Because only one procedure is documented and the object is internally oriented, the majority of its logic is presumed to reside within this single entry point, invoking supporting database objects such as sequence values, user lookups, and formatting utilities rather than exposing additional public routines.

Tables Accessed

The ETRM metadata lists the following tables referenced through APPS synonyms:

  • FND_USER — The core EBS applications user table. It is read to resolve the identity, credentials, and attributes of the user (and, in proxy scenarios, the principal and proxy users) whose notification is being launched. User-related context is essential for addressing the workflow correctly.
  • UMX_PROXY_NOTIFICATIONS_S — The proxy notification sequence object associated with the UMX proxy notification data. It is referenced to obtain unique identifiers used when creating or launching a notification record or workflow item.

The package also references standard infrastructure elements documented in the dependency section, including FND_GLOBAL, HZ_FORMAT_PUB, and WF_ENGINE. In 12.2.2 the dependency list additionally shows UMX_PROXY_NTF_WF itself, indicating internal or recursive references within the package. Notably, the package is not referenced by any other database object.

Usage Notes

UMX_PROXY_NTF_WF is an internal, event-driven utility. It is not exposed through a standard EBS form or concurrent program and is not referenced by other packages, which means it is invoked indirectly by the UMX proxy notification framework when a proxy notification requires workflow processing. Typical callers are therefore sibling UMX packages or triggers within the proxy notification flow that detect a notification event and delegate to LAUNCH_WORKFLOW to start the associated Workflow process.

Customizations should not call this package directly, as its interface is not a supported public API and its single documented routine depends on Workflow configuration and lookup data that are maintained internally. Developers investigating proxy notification delivery should treat this package as the Workflow launch point and consult the UMX proxy notification configuration and the WF_ENGINE-based workflow definition it targets. The absence of dependent references confirms it is a leaf-level integration component whose behavior is governed entirely by the UMX and Workflow frameworks in Oracle EBS 12.1.1 and 12.2.2.