Search Results updatepassword_wf

Overview

The APPS.JTF_UM_FORGOT_PASSWD package is a User Management (UM) utility within Oracle E-Business Suite that implements the "Forgot Password" self-service workflow. It enables an end user who cannot recall their Oracle EBS credentials to initiate a password recovery or reset request based on a supplied user name. The package validates the user identity, generates a temporary or replacement password, and orchestrates the notification and role-assignment steps required to complete the reset through Oracle Workflow. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema, and it resides in the APPS schema as an API-classified module. The package is documented under ETRM 12.2.2 with an API classification of OTHER.

Key Procedures and Functions

The package exposes several overloads of the core ForgotPwd procedure together with three Workflow callback procedures. The documented procedures are:

• FORGOTPWD — The primary entry point. It accepts a user name and returns a status and message data, with optional overloads permitting the caller to supply a user-approval message name and a password-reset message name. Internally it locates the user, generates a reset password, and submits the Workflow that notifies the user.
• UPDATEPASSWORD_WF — A Workflow function activity that performs the actual password change for the user identified by the workflow item. It follows the standard Workflow callback signature (itemtype, itemkey, actid, funcmode, resultout).
• CREATEROLE — A Workflow function activity that creates or assigns the role or responsibility required for the user to complete the password reset flow.
• SETPASSWORD_WF — A Workflow function activity that sets the new password value for the user within the Workflow-driven reset process.

All Workflow procedures share the standard itemtype/itemkey/actid/funcmode/resultout callback interface used by Oracle Workflow function activities.

Tables Accessed

The package reads and writes through APPS synonyms across several tables and built-ins:

• FND_USER — the core EBS user repository; queried to validate the user name and updated to store the new or temporary password.
• HZ_PARTIES — the Trading Community Architecture party record, used to resolve the user's identity and contact information associated with the person.
• JTF_UM_PSW_WF_S — a User Management password/workflow staging table that holds state for the in-flight password reset.
• WF_ITEMS and WF_ITEM_ATTRIBUTE_VALUES — Oracle Workflow item and attribute stores, used to seed and track the reset workflow instance.
• DBMS_RANDOM and DBMS_UTILITY — built-in PL/SQL packages used to generate the random temporary password and related utility values.
• DUAL — used for single-row evaluations and value computations.

Usage Notes

This package is normally invoked indirectly rather than called by custom code. The most common path is the EBS Login / Forgot Password page, where the "Forgot Password" link triggers ForgotPwd after the user supplies their user name. It also participates in Workflow-driven password-reset processes, with UpdatePassword_WF, CreateRole, and SetPassword_WF acting as function activities in the relevant item type. Concurrent programs or custom forms may call ForgotPwd directly where an administrator-driven reset is required, but callers should handle the returned x_return_status and x_message_name/x_message_data outputs. Because the package is documented as referenced by zero other packages, it is treated as a top-level entry point rather than a shared library. The presence of the AUTHID CURRENT_USER clause means effective privileges derive from the calling user, which is relevant when granting execute rights to custom schemas.