Which module You installed on Apps

Sometimes you need to check which module you installed in oracle E-business suite and to do that there's more one way :

using Query / as Apps User :


SELECT a.application_name,a.product_code,
DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
patch_levelFROM 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;


Using adutconf.sql scripts which is located in $AD_TOP

This script include information about Product installation status, version and other information.

Using Oracle Application Manager ( OAM )

Site Map ---> License Manager Which licensed word means installed.


Simple


Thank you
Osama Mustafa

Comments

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET