There are are several ways to find out which products are installed, shared or
inactive for choosen product family and products. Please use any of the options
listed below.

1. Run Licence Manager

2. Run the following script in Sqlplus as apps user:

cd $AD_TOP/sql/adutconf.sql
Sqlplus> @adutconf.sql

This creates a text file adutconf.lst in the current working directory.

3. View the file $APPL_TOP/admin/applprod.txt file

4. Run the following queries in Sqlplus as apps user:

a) Find all products and statuses:

select application_id, status
from fnd_product_installations;

b) Find the status of a particular product:

E.g. Application_id:
PER (Human Resources) = 800
PAY (Payroll) = 801

select application_id, status
from fnd_product_installations;
where application_id = '%80%';

Status:
I = Installed
S = Shared
N = Not Installed

OR

1) Download patchsets.sh from
ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh
Copy all contents
And create file patchsets.sh

2) FTP this file to server the application server.

3) Change the permission of this file.

4) Logon Application User
i.e su – applmgr

5) Go to the file location and run patchsets.sh utility.
i.e cd /oracle1/patchset/
$ ls –lrt
-rwxrwxrwx 1 root root 693509 Jan 29 15:00 patchsets.sh
6) Run the Patchset Comparison Utility - patchsets.sh
./patchsets.sh connect=apps/apps
It will proceed like this …….
OUT_DIR set to: /tmp by default (set CUST_TEMP if you want to customize this)
Connecting to database with parameters passed using tool version: 4.39
Getting Appsversion Version from the Database
... DETERMINED DB VERSION: 11.5.10.2
Finished: Setup_Env
... Extracting from AD_BUGS & AD_APPLIED_PATCHES into: Patch.csv
Running query on ad_patch_driver_minipks adds all patchsets applied.
... FOUND: 2 patchset in AD_PATCH_DRIVER_MINIPKS see: Applied_Ad_Minipks.csv
... Converting Patch Names to Patch Numbers. (using XX_patchsets.txt)
... Running Applied_Patches_Report.sql 11i sql: Applied_Patches_11i.sql
... Created Patches Applied Report: Applied_Patches_11i.txt
... Appending Minipks bug numbers to Patch.csv from ad_patch_driver_minipks table
... FOUND: 88585 records in AD_BUGS & AD_APPLIED_PATCHES
... Generated csv Patch datafile from the ad_xyz tables or Database: applptch=Patch.csv
Finished: Get_Version (Next Step is slowest)
... USING DB Patch Information: Patch.csv (From Database)
Done matching 980 patchsets(aru) to patchlist(Patch.csv)
Finished: Compare_Patches (Report.txt)
Starting: Report_11i.txt

FAMILY PACK PATCHES
Product Baseline Version Running Version Latest Available, Status
------- ----------------- --------------- -----------------------
atg_pf 11i.ATG_PF.H(3438354)11i.ATG_PF.H.6(5903765), Rel- By_Metal
bis_pf 11i.BIS_PF.D.1(4054609) 11i.BIS_PF.H(5565583), Rel- By_Metal
………………..

It will take 15-30 minutes to complete.

7) In the current directory path it will create file called Report_11i.txt.

Reference :
Note : 146139.1

posted by Jaswinder Singh @ 2:08 AM

0 Comments: