Thursday, May 9, 2013

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

No comments:

Post a Comment