Results for “wf_diagnostics_apps”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WF_DIAGNOSTICS_APPS is a diagnostic utility package owned by the APPS schema in Oracle E-Business Suite. It exists to support troubleshooting and health-check activities for the Oracle Workflow (WF) infrastructure and for the broader concurrent processing and environment configuration stack on which Workflow depends. Within the EBS 12.1.1 and 12.2.2 releases, Oracle Workflow relies on a set of database services — the Workflow Configuration, the Business Event System, notification mailers, and the Java-based Notification System — whose correct operation depends on values held in FND tables, concurrent queue definitions, and environment context settings.
The package is classified by ETRM as an OTHER API, meaning it is not a public, supported business API intended for customer extension logic. Instead it is an internal diagnostic and support-facing utility, typically invoked by Oracle Support or by DBA and system-administrator staff performing root-cause analysis. Its documentation confirms a VALID status in the APPS schema and describes a small, focused set of entry points. The dependency listing shows the package body references only SYS.STANDARD and is referenced by no other application packages, which underscores its role as a terminal diagnostic aid rather than a component in a business transaction chain.
Key Procedures and Functions
- GET_GSM_SETUP_INFO — Retrieves setup and configuration information related to the Workflow / Generic Service Management (GSM) environment. It is used to inspect how the Workflow services are configured so that misconfiguration can be identified during diagnostics.
- ECXTEST — A test routine associated with the e-Commerce/ECX integration context. It allows the technician to validate whether the relevant environment and integration plumbing responds as expected, isolating faults in the Workflow-to-integration path.
- TRACE_UTIL — A tracing utility. It supports enabling, interpreting, or gathering trace-level diagnostic output so that the internal execution path of Workflow processing can be examined when standard logging is insufficient.
The documented interface does not publish parameter lists for these routines; the procedure signatures are considered internal and subject to change across release levels. Consumers must therefore treat the package as support tooling rather than a stable programmatic contract.
Tables Accessed
Through APPS synonyms the package interacts with a defined set of dictionary and environment tables. FND_APPLICATION supplies registered application identity and basepath information needed when resolving which product owns a given workflow or setup. FND_CONCURRENT_PROCESSES and FND_CONCURRENT_QUEUES provide the live concurrent manager state, allowing the diagnostics to correlate Workflow background processing with the concurrent request and queue definitions that execute it. FND_ENV_CONTEXT returns environment context values so that the diagnostic output reflects the actual runtime configuration. DBMS_LOB and UTL_FILE provide large-object and file-system access for reading and writing diagnostic output, while DUAL and PLITBLM support internal PL/SQL evaluation and index-by-table manipulation used within the routines.
Usage Notes
WF_DIAGNOSTICS_APPS is normally invoked from SQL*Plus or another PL/SQL session by an administrator or support engineer, either by calling individual procedures directly or through Oracle's Workflow diagnostics scripts. It is not surfaced as a standard concurrent program and it is not called by other product code, as confirmed by the zero inbound package references. Because it reads environment and concurrent manager state and may generate trace or file output, it should be executed by a user with the APPS schema privileges in a controlled troubleshooting session, and not embedded in custom business logic. Output should be captured and forwarded to Oracle Support as part of a Service Request when diagnosing Workflow configuration, notification mailer, or service component problems.
-
SYNONYM: PUBLIC.UTL_FILE 12.1.1
-
SYNONYM: PUBLIC.UTL_FILE 12.2.2
-
SYNONYM: PUBLIC.DBMS_LOB 12.1.1
-
SYNONYM: PUBLIC.DBMS_LOB 12.2.2
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
SYNONYM: PUBLIC.DUAL 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used