Search Results umx_password_pvt




Overview
Explore in AI Chat

Overview

UMX_PASSWORD_PVT is the private package body within the Oracle E-Business Suite APPS schema that implements the application's user password lifecycle management logic. In EBS 12.1.1 and 12.2.2, this package underpins the User Management (UMX) infrastructure, handling password validation, password resets, self-service password changes, and password-related workflow notifications. It is classified as a PVT (private) API, meaning it is intended for internal consumption by the UMX and FND layers rather than as a public integration surface. The package body is registered as VALID and depends on a broad set of foundation utilities, including FND_API, FND_CRYPTO, FND_GLOBAL, FND_LOG, FND_MESSAGE, FND_PROFILE, FND_SSO_MANAGER, FND_USER_PKG, and FND_WEB_SEC, alongside Oracle Workflow constructs (WF_CORE, WF_ENGINE, WF_DIRECTORY) and DBMS_RANDOM for random generation tasks. Its presence in the APPS schema reflects its central role in enforcing password policy and coordinating password events across the EBS security stack.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within the package body:

  • VALIDATE_PASSWORD — Evaluates a candidate password against the configured password policy, invoking FND_CRYPTO and related checks to confirm compliance.
  • RESETPWD — Performs the administrative password reset operation, typically initiated by an administrator or automated process.
  • UPDATEPASSWORD_WF — Coordinates password update activity through Oracle Workflow, raising or progressing workflow items associated with password changes.
  • CREATEROLE — Creates the role entries required in support of password and user provisioning activities.
  • SETPASSWORD_WF — Drives the password-set operation through the workflow engine, used where password events must be orchestrated as workflow items.
  • FORGOTPWD — Implements the "forgot password" self-service flow, generating and dispatching recovery information to the user.
  • CLEAN_UP_AD_HOC_ROLE — Removes temporary or ad hoc roles created during password workflows once they are no longer needed.

Tables Accessed

The package reads and writes several core EBS tables and views, accessed through APPS synonyms:

  • FND_USER — The primary user account repository, updated during password set, reset, and change operations.
  • HZ_PARTIES — Consulted to resolve party-level identity information associated with the user, using HZ_FORMAT_PUB for formatting.
  • UMX_PASSWORD_WF_S — The password workflow staging table that tracks the state of password-related workflow activities.
  • WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_TYPES — Oracle Workflow runtime tables used to create and monitor password workflow items.
  • WF_LOCAL_ROLES — Stores role definitions referenced during role creation and cleanup.
  • DBMS_RANDOM and DUAL — Used for random value generation and singleton SQL evaluation.

Usage Notes

UMX_PASSWORD_PVT is invoked indirectly through EBS security functionality rather than being called directly by end users. Typical invocation paths include the Oracle Applications login and password-change pages, the System Administrator user maintenance forms, the "forgot password" self-service application, and the Oracle User Management (UMX) administrative screens. Because it is a private package body and is not referenced by any other database object, custom code should avoid calling it directly; supported extension points are generally exposed through the public UMX APIs. Its dependencies on FND_LOG and FND_MESSAGE indicate that it participates in standard EBS logging and message resolution during execution.