Search Results wf_maintenance




Overview
Explore in AI Chat

Overview

WF_MAINTENANCE is an Oracle Workflow maintenance utility package owned by the APPS schema. Its principal responsibility within Oracle E-Business Suite Release 12.1.1 and 12.2.2 is to reconcile and synchronize the Workflow directory data that underlies routing, notification delivery, and role resolution. As the name implies, the package performs housekeeping and validation tasks that keep the WF_LOCAL_ROLES directory hierarchy consistent with the FND_USER account repository and the underlying workflow runtime tables. Because workflow notifications, approval routing, and role-based assignment depend on an accurate local directory cache, WF_MAINTENANCE plays an important supporting role whenever user information changes — for example, after a user is renamed, reassigned, or re-enabled. The package is classified as OTHER in the ETRM API registry, indicating that it is an internal maintenance utility rather than a public, supported integration API. It currently holds a VALID status and is referenced by two other packages, WF_DIRECTORY and WF_LOCAL_SYNCH, confirming its role as a shared low-level component.

Key Procedures and Functions

The documented interface exposes three procedures/functions:

  • PROPAGATECHANGEDNAME — Propagates a changed user or role name through the workflow directory. It is used to push updated naming information into WF_LOCAL_ROLES and related directory structures so that subsequent notification and routing lookups resolve to the correct display and internal name.
  • VALIDATEUSERROLES — Validates the relationship between workflow roles and assigned users, identifying inconsistencies such as orphaned role assignments or directory entries that no longer correspond to a valid FND_USER record.
  • GETUSERNAMECHANGECOUNTS — Returns counts associated with user name changes, providing a diagnostic measure of how many records may require propagation or remediation.

No parameter lists are published in the metadata, and callers should consult the package specification in the database before invoking these routines directly.

Tables Accessed

WF_MAINTENANCE references an extensive set of workflow and application tables, primarily through APPS synonyms. The core directory tables WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES are read and updated to reconcile role membership. FND_USER, FND_GRANTS, WF_DIRECTORY_PARTITIONS, and WF_COMMENTS support validation of user accounts and directory partitioning. Runtime workflow objects — WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ACTIVITY_STATUSES_H, WF_ITEM_ATTRIBUTES, WF_ITEM_ATTRIBUTE_VALUES, WF_PROCESS_ACTIVITIES, WF_MESSAGE_ATTRIBUTES, and WF_NOTIFICATIONS — are touched when validating or propagating changes that affect in-flight workflow instances. USER_TABLES is referenced for existence checks, and STANDARD/SYS objects provide standard PL/SQL runtime support.

Usage Notes

WF_MAINTENANCE is not a user-facing API. It is typically invoked indirectly by higher-level workflow components such as WF_DIRECTORY and WF_LOCAL_SYNCH, which call it during directory synchronization and user maintenance processing. Administrators may encounter it through "Synchronize WF LOCAL Tables" or user-rename workflows in the Workflow Administrator responsibility. Direct invocation from custom code is discouraged because the procedures operate on critical workflow metadata; any call should be preceded by a backup of the affected workflow tables. Because the package relies on FND_USER and WF_LOCAL_ROLES, it must be executed in an environment where the APPS schema and workflow background processes are fully configured, and it should be run only during low-activity windows to avoid contention with active notification processing.