Introduction:– EBS Support Analyzers are designed by Oracle Support to proactively assist with diagnosing issues and maintaining Oracle Application environments. Each analyzer is either a Java script or pl/sql package that can be run from java or SQL*Plus. The (non-java) pl/sql analyzers can be setup to run as a concurrent programs. When installed as a concurrent program, users with the proper Responsibility can run and view the analyzer html reports from Concurrent Manager, without needing the APPS password
Requirements:-
Requires Perl 5.8. Check the version with the below command.
$ perl -v
This is perl, v5.10.0 built for x86_64-linux-thread-multiSTEPS :-
First thing is to download the bundle in order to install it to any of the instances.
Make a directory directing to the Analyzer folder
mkdir -p /temp/analyzer
Move the downloaded analyzer bundle zip file to this location which is created.
$ pwd
/temp/analyzer
Unzip the bundle_2023-Jun-01.zip to the present location.
unzip bundle_2023-Jun-01.zip
Goto the MENU
Start the Analyzer Bundle Menu Tool
- Start main Analyzer Menu by executing the command “perl Menu.pl”:
Go inside the MENU folder and hit perl Menu.pl
$ cd MENU
$ perl Menu.pl
Enter the APPS Password on being asked
[L] Bulk FNDLOAD ALL Analyzers [S] Show Installed Analyzers [U] Update, AutoUpdate, UninstallSelect “L”
NOTE:- Generally When attempting to install / load Analyzers using Bundle menu tool
the following error occurs.
ERROR
———————–
Analyzer.pm: Cannot open ‘rcv_podata_analyzer_cp.sql’ No such file or directory
Cause:-
Older “Procurement Receiving Analyzer” program name resides on the instance. This was moved from “Purchasing” application to “Inventory” application.
The error may occur if for some reason the older object was not removed/ dropped.
Solution:-
- Run below script on a TEST instance to drop the program under Purchasing
Begin
fnd_program.delete_program (‘PORCVANL’, ‘Purchasing’);
fnd_program.delete_executable (‘PORCVANL’, ‘Purchasing’);
commit;
End;
/
- Install the analyzers using the Analyzer Bundle Menu tool.
Continue the segment
[L]oad | [B]ack | [H]elp | E[x]it | [N]ext Page…
Toggle Selections by Number
Selection:L
Load the Selected [+] Analyzers?
[Y]es | [N]o: YPress C to Continue
Click Yes on being asked to generate logs.
On a successful attempt, Check the logs for any errors.
CONCLUSION:– This is the most Easiest way to install and obtain all available EBS Support Analyzers and the most Convenient way for DBA/SYSADMIN to execute analyzers from a single menu.
