Search Results populate_reg_data




Overview
Explore in AI Chat

Overview

UMX_REGISTRATION_PVT_W is a private PL/SQL package in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2 that serves as the wrapper layer for the User Management (UMX) registration infrastructure. UMX provides the core account provisioning framework that governs self-service registration, approver-driven registration requests, and role assignment across EBS applications. The "_W" suffix identifies this as a generated wrapper package whose purpose is to expose the underlying business logic in UMX_REGISTRATION_PVT to a standardized calling convention, in this case using the Rosetta table-copy pattern built on JTF_VARCHAR2_TABLE_100 and JTF_VARCHAR2_TABLE_2000 PL/SQL collection types.

The package header is marked AUTHID CURRENT_USER and dates to release 11.5.x lineage (header reference UMXWREGS.pls 115.2), yet it continues to be deployed in the 12.1.1 and 12.2.2 file systems without signature changes. It is classified as API type OTHER, meaning it is not a formally published public API and should not be called directly by customer extensions without caution, since Oracle may change its internals between patch levels.

Key Procedures and Functions

  • ROSETTA_TABLE_COPY_IN_P1 — Converts Rosetta's column-oriented table representation into the structured UMX_REGISTRATION_DATA_TBL record table used by the private registration logic. It accepts the two JTF VARCHAR2 tables as input and produces the typed registration data table.
  • ROSETTA_TABLE_COPY_OUT_P1 — Performs the inverse transformation, taking the typed UMX_REGISTRATION_DATA_TBL and writing values back into the JTF VARCHAR2 tables so that Rosetta callers can consume the results.
  • UMX_PROCESS_REG_REQUEST — The principal entry point for processing a registration request. It drives the business workflow for creating and validating a user registration, invoking downstream procedures such as role assignment.
  • POPULATE_REG_DATA — Normalizes and populates the registration data elements prior to persistence, mapping the incoming Rosetta parameters into the fields expected by the registration tables. This is the procedure most commonly referenced in diagnostic queries and troubleshooting discussions.
  • ASSIGN_ROLE — Applies the role or responsibility assignments associated with the registration request once the user record has been created.

Tables Accessed

The documented table reference for this package is PLITBLM, an Oracle Applications internal infrastructure table used by the PL/SQL interface machinery that mediates between Java/Rosetta callers and database PL/SQL. No application-specific tables are documented as directly accessed by this wrapper; all substantive DML against UMX registration, role, and workflow tables occurs inside UMX_REGISTRATION_PVT, which this wrapper delegates to.

Usage Notes

UMX_REGISTRATION_PVT_W is not intended for direct invocation by customer code. It is called through the UMX registration Java stack, which in turn is exposed via the User Management responsibility and the self-service registration flows in Oracle Applications Manager and the EBS login pages. Administrators investigating registration failures, role assignment errors, or "populate_reg_data" errors in the application log should trace the call path down to UMX_REGISTRATION_PVT rather than attempting to patch or wrap this private package. Because the package relies on the Rosetta table-copy convention, any custom integration should call the supported public UMX APIs or the FND_USER_PKG interfaces instead. In 12.2.2 online patching environments, the package is editioned along with the rest of the UMX code tree, and its behavior is identical between 12.1.1 and 12.2.2.