Results for “jtf_um_psw_wf_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_UM_FORGOT_PASSWD is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It belongs to the JTF User Management (UM) framework, the component responsible for self-service user registration, profile maintenance, and credential handling. The package implements the backend logic for the "Forgot Password" workflow, allowing end users who cannot recall their password to be issued a newly generated credential and notified through the Oracle Workflow notification infrastructure. It is a supporting object of the broader JTF_UM (User Management) module rather than a public API, and the ETRM registry classifies it as API classification OTHER.

The header comment embedded in the source identifies the package as JTFVUPWB.pls, version 115.17, last amended on 2004/05/12. This revision level indicates the object has been stable since the early 11i/12.0 era and is carried forward unchanged into Oracle EBS 12.1.1 and 12.2.2. No dependent packages reference it, meaning it is invoked through the user interface and Workflow rather than programmatically by other code.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions, of which four are named:

• FORGOTPWD — The primary entry point for the forgotten-password business flow. It orchestrates the reset request, typically launching or advancing the associated Workflow process that carries the new credential to the user.
• SETPASSWORD_WF — A Workflow-callable procedure (the internal helper generate_password is defined as a private function) that sets the newly generated password against the user account when the Workflow process reaches the appropriate activity. It creates the password using the length defined by the SIGNON_PASSWORD_LENGTH profile option, mixing alphabetic and numeric characters via DBMS_RANDOM and DBMS_UTILITY.
• UPDATEPASSWORD_WF — A companion Workflow-callable procedure that persists the changed password and completes the reset transaction.
• CREATEROLE — Creates the role or responsibility association required in the user-management context during credential processing.

The internal function generate_password is private and returns a random string whose length is the greater of SIGNON_PASSWORD_LENGTH or the default of six characters. Character positions are selected alternately as numeric or alphabetic based on the parity of a random value, and character translation uses FND_GLOBAL.LOCAL_CHR for NLS compatibility.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• FND_USER — the core repository of application user accounts, where the new password hash is stored and the user_name is validated.
• HZ_PARTIES — the TCA party record associated with the user, used to resolve identity during password recovery.
• JTF_UM_PSW_WF_S — a JTF User Management sequencing or staging table specific to the password Workflow, supporting the notification lifecycle.
• WF_ITEMS and WF_ITEM_ATTRIBUTE_VALUES — Oracle Workflow runtime tables holding item attributes such as the generated username and password passed between activities.
• DBMS_RANDOM, DBMS_UTILITY, and DUAL — used for random number initialization and time retrieval.

Usage Notes

JTF_UM_FORGOT_PASSWD is invoked indirectly. End users trigger it through the Oracle Applications Login page or the User Management self-service pages, where the "Forgot Password" link initiates a Workflow process defined in the JTF User Management item type. The Workflow engine then calls SETPASSWORD_WF and UPDATEPASSWORD_WF as the process advances, using WF_ENGINE.GetItemAttrText to retrieve the generated credentials. Because the package is not referenced by any other PL/SQL package, customizations should not call it directly; extensions should instead invoke the supported User Management APIs. Administrators should note that the generated password is subject to the SIGNON_PASSWORD_LENGTH profile and to standard password complexity validation performed elsewhere in the signon stack.