Search Results admin_mode

Overview

The APPS.ECX_WORKFLOW_HTML package body is an Oracle E-Business Suite component that generates HTML output for the Oracle Workflow notification framework as it relates to Oracle Exchange (ECX) transactions. It resides in the APPS schema and is classified as an OTHER API, indicating it is not a public, versioned business interface but rather an internal helper package used to render the web-based user interface of administrative Workflow notifications. Specifically, this package produces the HTML pages used by database administrators to inspect and troubleshoot queued messages associated with the ECXMSG abstract datatype held on Advanced Queuing (AQ) queues.

In the 12.1.1 and 12.2.2 file systems, this is the installed EBS package version (the source header references ECXWHTMB.pls 120.9), which is the artifact relevant to both releases. Its role sits at the intersection of Oracle Workflow and Oracle Advanced Queuing: it queries queue metadata and queue table contents, then formats the results into an HTML page rendered inside the standard Workflow notification container.

Key Procedures and Functions

The package exposes two documented procedures:

• LISTECXMSGQUEUEMESSAGES — Renders an HTML listing of messages held on an ECXMSG queue. It accepts filter criteria for the queue name, ECX transaction type, ECX document number, party site ID, queue message status, and queue message ID, executes a dynamically constructed SQL statement against the queue table, and writes the resulting message rows, states, and payload information into the generated web page. This is the procedure most directly associated with the admin_mode variable that appears in its declaration section.
• LISTECX_INENGOBJQUEUEMESSAGES — Renders an analogous HTML listing for inbound engineering object queue messages, following the same presentation pattern as the ECXMSG variant.

The source of LISTECXMSGQUEUEMESSAGES declares a local variable admin_mode varchar2(1) := 'N' alongside related values such as username and admin_role. These are populated during the admin authority check performed at the start of the procedure using wfa_sec.GetSession, wf_directory.GetRoleInfo, and Wf_Directory.IsPerformer against the role returned by wf_core.translate('WF_ADMIN_ROLE'). When the current user holds the Workflow administrator role (or the role translation returns the wildcard '*'), the page is rendered in administrative mode, granting access to the full message listing. The admin_mode flag therefore controls whether sensitive queue diagnostic information is exposed to the caller.

Tables Accessed

The documented table references are:

• ALL_QUEUES — the data dictionary view used to resolve queue names and queue metadata, including the underlying queue table name (l_queue_table, l_qtable) before dynamic SQL is issued.
• HTF, HTP — the Oracle HTML generation PL/SQL packages used to emit tags, LOV images (FNDILOV.gif), and page structure for the notification display.
• OWA_UTIL — Oracle Web Agent utilities used for CGI/environment handling and URL construction within the generated HTML.

Usage Notes

This package is not intended for direct invocation by customers. It is called by the Oracle Workflow notification rendering framework when a Workflow administrator opens an ECX message queue diagnostic or queue display notification. The package performs its own authorization check each time it executes, so the administrator role check occurs at runtime rather than being cached. The admin_mode variable should be treated as an internal implementation detail; customization should avoid altering this logic, since changing it could expose queue payload contents to non-administrative users. In both 12.1.1 and 12.2.2, the same EBS patch version applies, so there is no release-specific behavior difference to account for when troubleshooting notification rendering or queue diagnostics.