Results for “update_pwd_challenge”

10 results




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

Overview

PON_USER_PROFILE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that manages user profile and personal information within the Oracle Procurement (PON) module. The package body header indicates it was last revised in 2006 and is shipped as part of the base EBS installation. Its primary business function is to consolidate the create, retrieve, update, and authentication operations performed against a vendor or enterprise user's personal record — spanning name, contact information, locale, language, time zone, and password credentials. These operations are surfaced primarily through self-service Procurement user interfaces (the source comments identify PersonalInfo.jsp as a driving page) as well as through workflow-enabled vendor registration and profile maintenance flows. The package is classified as OTHER in the ETRM registry and exposes eleven documented procedures and functions, making it a moderately sized but functionally important component of supplier-side user administration.

Key Procedures and Functions

The documented program units fall into four functional groups.

Because ETRM does not publish parameter signatures here, integrators should query the package specification in the database (ALL_ARGUMENTS / ALL_PROCEDURES) before invoking any routine from custom code.

Tables Accessed

The package reads and writes through APPS synonyms across the following tables:

  • FND_USER — the core EBS application user account record; updated for profile/language fields and deleted by DELETE_USER.
  • HZ_PARTIES and HZ_PERSON_PROFILES — the TCA party and person profile records that hold name, title, and party-level identity attributes.
  • HZ_CONTACT_POINTS and PER_PHONES — contact-point records (phone, fax, email) that back UPDATE_USER_INFO's contact fields.
  • HZ_PARTY_SITES and PER_ALL_PEOPLE_F — party-site and person (HR) records used to link the user to a valid party site and person assignment.

Usage Notes

PON_USER_PROFILE_PKG is invoked from Procurement self-service JSP/HTML pages (notably PersonalInfo.jsp), from workflow-driven supplier registration and profile maintenance, and from other APPS packages — the ETRM registry notes one package dependency. It is not exposed as a concurrent program. Custom developers extending supplier user administration should call the documented procedures rather than writing directly to FND_USER or the HZ tables, since the package also coordinates workflow language settings and party linkage. Exception handling follows a status/exception-message OUT convention (status codes 'S', 'E', and 'U'), so callers must check x_status and handle rolled-back transactions after a failure.