How to find Installed Modules in Oracle E-Business Suite R12 …..

First Method :-

1.. Login Oracle E-Business Suite as SYSADMIN user.

100

1.2.. Click on System Administrator responsibility and OAM Setup tab.

101.png

103

1.3.. Once you have clicked on OAM setup, click on Site Map

104.png

1.4..  Now click on Licensed Products under the tab Reports

105.png

1.5 Your screen will appear like given below with summary for licensed, Not licensed etc.

106.png

1.6..  In given below screen you can filter out products installed in your system.

107.png

Second Method :-

2.. Source the Application tier env and Navigate as given below and find and execute script adutconf.sql and under Product Database Configuration you can find installed products.

109.png

110

Third Method:-

3.. Using sql query

SELECT a.application_name,a.product_code, DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,patch_level FROM apps.fnd_application_vl a, apps.fnd_product_installations b WHERE a.application_id = b.application_id and b.status=’I’ order by product_code asc;

111.png

 

Happy Learning !!!!

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s