My Oracle Support Banner

How To Run EBS Reports & Printing Analyzer Tool As A Concurrent Request (Doc ID 2012324.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Pasta - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Goal

This is an Addendum to Note 1610143.1 - Reports & Printing Analyzer script for E-Business Suite.  This Document will guide the user through the steps to register and configure the Oracle EBS Reports & Printing Analyzer Tool (named reports_printing_analyzer.sql ) to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script (reports_printing_analyzer.sql) requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (APPS) password. The creation of this Concurrent Request needs to be performed by a System Administrator; however, this will be a one time task. Once installed, end users with the proper Responsibility will have the ability to execute the Reports & Printing Analyzer Tool as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.

NOTE: This process is a customization and is not supported, but can be used as a guideline for adding the analyzer to be 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
 Follow these steps to register and run the Reports & Printing Analyzer script as a concurrent program.
 1.) Copy the latest version of reports_printing_analyzer.sql from Note 1610143.1 into the source ($FND_TOP/sql) directory.
 2.) Create a new Executable (RPT_PRT_ANALYZER_SQL)
 3.) Define a new Concurrent Program (Reports Printing Analyzer Tool)
 4.) Add the new Reports & Printing Analyzer Program to the Responsibility's Request Group.
 5.) Submit a new 'Reports Printing Analyzer Tool' Concurrent Request and Verify the output.
 6.) Schedule The Reports Printing Analyzer Tool Concurrent Request to Run Periodically
References

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