Check EBS Installed Modules and versions

Check EBS Installed Modules and versions 

How to check if certain Oracle Applications modules/products are installed, and their versions?

 Application tier, 

Method 1

cd $AD_TOP/sql/

 Execute:

sqlplus apps/<password> @adutconf.sql

File adutconf.ls will be created in directory $AD_TOP/sql

Check product name by searching for “Product” in list file

 Reference document : - 443699.1

Method 2

Use Oracle Applications Manager (OAM).

Connect to http://<hostname>.<domain>:<PORT>/servlets/weboam/oam/oamLogin

a. Click 'Site Map'.
b. Under 'System Configuration' choose 'License Manager'.
c. Go to 'Products' link.
d. Click ' Licensed Products' under 'Reports' section.

You can use filter for certain product.

Filter: Product Abbreviation is AR

The value in status column shows product installation status.


Method 3

Use sql query.

select fa.APPLICATION_SHORT_NAME, fpi.PATCH_LEVEL, DECODE(fpi.STATUS, 'I','Installed',
'S','Shared', 'N', 'Inactive', fpi.STATUS) Status , fpi.DB_STATUS
from fnd_product_installations fpi,FND_APPLICATION fa
where fpi.APPLICATION_ID in (
select APPLICATION_ID from FND_APPLICATION where APPLICATION_SHORT_NAME like '<PRODUCT_SHORT_NAME>')
and fa.APPLICATION_ID=fpi.APPLICATION_ID;

where  <PRODUCT_SHORT_NAME> is your product short name

Example 1

How to check if Knowledge Management (CSK), iSupport (IBU), Business Intelligence(BIS) are
implemented?

sqlplus <apps_user>/<apps_password>

sql> select fa.APPLICATION_SHORT_NAME, fpi.PATCH_LEVEL, DECODE(fpi.STATUS, 'I','Installed',
'S','Shared', 'N', 'Inactive', fpi.STATUS) Status , fpi.DB_STATUS
from fnd_product_installations fpi,FND_APPLICATION fa
where fpi.APPLICATION_ID in (
select APPLICATION_ID from FND_APPLICATION where APPLICATION_SHORT_NAME in ('CSK','IBU','BIS'))
and fa.APPLICATION_ID=fpi.APPLICATION_ID;

if any of the products is implemented status should be Installed.

Method 4

Use script patchsets.sh which is documented in NOTE:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh.

If you have any errors when running script patchsets.sh please refer to the following note to resolve the issue:
NOTE:314442.1 Cannot run Patchsets.Sh Script