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
Technology Geek 