Search Results umx_reg_requests_pvt




Overview
Explore in AI Chat

Overview

UMX_REG_REQUESTS_PVT is a private (PVT-classified) PL/SQL package owned by APPS that implements the core processing logic behind Oracle E-Business Suite's user registration and self-service account provisioning framework. It manages the lifecycle of registration requests stored in UMX_REG_REQUESTS, the table that tracks each request to create, approve, or reject an Oracle EBS user account and its associated username. The package coordinates username reservation and availability checks, approval and rejection workflows driven by Oracle Approvals Management (AME) and Oracle Workflow, cancellation of stale or abandoned requests, and retrieval of pending account and error information. Because it is a private package, its procedures are not part of a published public contract; they are consumed by public UMX packages and by the registration user interface layers. The IS_PEND_REQUEST_ERROR API, which prompted this search, is one of the status-query functions used to determine whether a pending registration request is in an error state, so that callers can display or act on that condition. The source header indicates the file $Header: UMXVRRSS.pls 120.2 2006/09/11 ... corresponds to a long-standing component carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes sixteen documented subprograms, grouped by purpose:

Tables Accessed

All table access is performed through APPS synonyms. UMX_REG_REQUESTS is the primary table for request rows, while UMX_REG_SERVICES_B holds the registration service definitions referenced by REG_SERVICE_CODE. FND_USER is read to validate usernames and to link requests to existing accounts. AME_CALLING_APPS supports integration with Oracle Approvals Management for approver resolution. WF_EVENTS and WF_ITEMS supply and receive Workflow event and item information used in notifications and error tracking, and AK_WEB_USER_SEC_ATTR_VALUES stores web-user security attribute values associated with the registration. HZ_PARTIES provides person party data for the user the request is raised for, FND_LOOKUP_VALUES supplies the UMX_REQUEST_STATUS lookup codes, and PLITBLM is the standard PL/SQL integer-table type used for collections. The package is referenced by four other packages, reflecting its role as a shared internal service layer.

Usage Notes

UMX_REG_REQUESTS_PVT is invoked indirectly rather than directly by end users. Typical callers are the public UMX registration APIs, the EBS user-management and self-service registration forms, and the Workflow background processes that route registration requests through approval. Custom code should prefer the public UMX interfaces; direct calls into this private package are unsupported and may break across patches. When troubleshooting, IS_PEND_REQUEST_ERROR and IS_PEND_ACCOUNT_ERROR are useful to confirm whether a stuck pending request or account is in an error state, after which GET_ERROR_WF_INFO and the GET_PEND_ACCT_INFO_* functions can supply diagnostic detail. Because behavior is version-sensitive, review the packaged source in the target environment (12.1.1 or 12.2.2) before relying on any specific transition.