Search Results umx_registration_pvt




Overview
Explore in AI Chat

Overview

UMX_REGISTRATION_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite user registration framework, part of the User Management (UMX) product family. It encapsulates the low-level business logic that drives self-service registration requests, including enrichment of registration data, resolution of person and assignment identifiers, address formatting, role assignment, and event publication through the Oracle Workflow engine. The package is classified as a private (PVT) API, meaning it is intended for internal consumption by the registration flow rather than direct invocation by customers. It remains VALID in both EBS 12.1.1 and 12.2.2, and the documented metadata confirms it is not referenced by any other database object at the dependency level, although five other packages reference it at the package level. Its overarching purpose is to translate an approved registration request into concrete user provisioning actions within FND_USER and its associated HR and party records.

Key Procedures and Functions

  • UMX_PROCESS_REG_REQUEST — The primary entry point that processes a registration request, orchestrating validation and downstream actions against the registration tables and workflow events.
  • FORMAT_ADDRESS_LOV — Builds the formatted address list of values used to present party addresses for selection during registration.
  • POPULATE_REG_DATA — Populates the registration data structure with values gathered from requests, services, and party records.
  • ASSIGN_ROLE — Assigns the appropriate responsibility or role to the newly registered user as part of provisioning.
  • GET_PHONE_NUMBER — Retrieves the contact phone number associated with the person or party record, drawing from PER_PHONES.
  • GET_PERSON_ID — Resolves the HR person identifier for the registering individual, using PER_ALL_PEOPLE_F.
  • GET_MANAGER_NAME — Returns the manager name associated with the employee's assignment, sourced from PER_ALL_ASSIGNMENTS_F and related HR views.
  • GET_JOB_TITLE — Returns the job title for the registered individual, referencing PER_JOBS_VL.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. User and party data are held in FND_USER, HZ_PARTIES, and PER_ALL_PEOPLE_F, with assignment and phone details in PER_ALL_ASSIGNMENTS_F and PER_PHONES, and job attributes in PER_JOBS_VL. Registration workflow state is persisted in UMX_REG_REQUESTS, UMX_REG_REQUESTS_S, UMX_EVENTS_S, and the service definition tables UMX_REG_SERVICES_B and UMX_REG_SERVICES_VL. Workflow integration uses WF_EVENTS, WF_PARAMETER_LIST_T, and the Workflow engine APIs. Reference data for responsibilities and functions is drawn from FND_FORM_FUNCTIONS. The package also references FND_GLOBAL for session context, FND_DATE for date handling, FND_LOG for diagnostics, and DBMS_SQL and DUAL for dynamic SQL support.

Usage Notes

UMX_REGISTRATION_PVT is invoked indirectly by the standard UMX self-service registration pages, concurrently scheduled registration-related programs, and Workflow business event subscriptions that drive user provisioning. Because the procedures are private, customizations should call the public UMX registration APIs or underlying UMX_REG_REQUESTS_PKG rather than this package directly. When troubleshooting registration failures in EBS 12.1.1 or 12.2.2, enabling FND_LOG output for this package is the recommended diagnostic step, since it records the enrichment and role-assignment steps performed during request processing.