Search Results get_users

Overview

APPS.MWA_UTL_SM_PKG is a utility package body in the Oracle E-Business Suite Utilities (MWA) module. Its documented purpose is to interface with an external server management or monitoring endpoint over HTTP. The package name suffix "SM" and the routine names Get_Users and Send_Message indicate it handles the retrieval of connected user lists and the transmission of administrative messages to a remote server agent, most likely the underlying infrastructure component associated with Oracle's Applications Technology stack utilities. The package relies on the UTL_HTTP PL/SQL built-in to issue outbound requests, and it does not read or write any application database tables.

The package is classified as OTHER in the ETRM repository, meaning it is not a public, supported extension API. It is an internal implementation detail called by a higher-level utility UI or concurrent process. The header comment identifies the source file as MWASMGRB.pls, last revised in 2005, which is consistent with the Oracle EBS 11i and 12.x technology stack.

Key Procedures and Functions

The package body exposes three documented procedures:

• GET_USERS — Retrieves the list of users currently known to the remote server. It accepts connection parameters, including server_host and server_port (the search term supplied by the user), as well as an optional proxy host and credentials. It constructs an HTTP request URL in the form http://<server_host>:<server_port>/, appends the credentials and the literal USERS command, then invokes UTL_HTTP.request. The response is parsed as a newline-delimited string; if the response contains the token FAIL, the procedure returns status E with the message text. Otherwise it iterates the response, populating an output user table and returning the user count with status S.
• SEND_MESSAGE — Transmits a message to the remote server. Its full parameter list is not reproduced in the available metadata excerpt, but by symmetry with GET_USERS it accepts connection details and message content, builds an HTTP request, and returns status and status message flags.
• TEST — A diagnostics or self-test routine used to validate connectivity and the package's ability to reach the configured server endpoint.

Tables Accessed

No application tables are accessed. The only referenced object is the PL/SQL-supplied UTL_HTTP package, which appears in the ETRM table reference list via its APPS synonym. All persistent state resides on the remote server management process outside the EBS database.

Usage Notes

MWA_UTL_SM_PKG is invoked internally rather than from standard EBS forms or concurrent program definitions. The documented ETRM metadata records zero packages referencing it, indicating it is either called dynamically, from a Java or OAF layer, or through the Oracle HTTP Server administrative interface associated with Oracle Applications Manager utilities. The server_port parameter is significant because it allows the caller to target a specific listening port on the management host, permitting deployment of the remote agent on non-default ports. Because the URL is built by simple string concatenation, callers must supply a valid host without a scheme prefix; passing a host already containing http:// will produce a malformed request. The absence of HTTPS handling in the documented source means credentials are transmitted in clear text, so the package should be restricted to trusted internal networks. Administrators invoking this package directly should wrap calls in exception handlers for UTL_HTTP errors such as network timeouts and access control failures, since the routine itself only distinguishes success from a FAIL token in the response body.