My Oracle Support Banner

Advanced Features and Options Running EBS Workflow Analyzer as a Concurrent Request (Doc ID 1425053.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Workflow - Version 11.5 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

This is an Addendum to Note 1369938.1 - Workflow Analyzer script for E-Business Suite Workflow Monitoring and Maintenance. This document will guide the user through Advanced Features and Options Running EBS Workflow Analyzer as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing Workflow Analyzer script (package wrapper file workflow_analyze.sql) requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (<APPS_user>) password. Setting up the Workflow Analyzer as a Concurrent Program, as outlined in the main Workflow Analyzer Doc ID 1369938.1, allows end users with the proper Responsibility to have the ability to execute the Workflow Analyzer as a concurrent request, or schedule periodically without the need of SQL access or the Applications Owner (<APPS_user>) password.

This Note is to provide additional options when running Analyzers as a Concurrent Request.  These steps can be modified and used for any Analyzer run as a Concurrent Request.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Advanced Features and Special Upon Completion Options
 1.) Create a shell script (wfaOptions.sh) to perform multiple concurrent request post completion commands
 2.) Change the permissions on wfaOptions.sh to allow execution of the shell script.
 3.) (Optional) Email Report Output to multiple email addresses vs a single email_address
 4.) Create Custom Printer Driver
 5.) Create Custom Print Styles
 6.) Create Custom Printer Type
 7.) Register Custom Printer to use the new Custom Printer Type & Style
 8.) (Optional) Specify the default Printer Driver for the Workflow Analyzer Tool Concurrent Request
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.