How to check if a product is implemented / installed in Oracle Applications
SELECT fa.application_short_name,
fat.application_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,
fnd_application_tl fat
WHERE fa.application_id = fpi.application_id
--AND fa.application_short_name LIKE '<APPL SHORT NAME>' /* Replace Application Short Name with a product to restrict the query for a specific product. Ex: AR for Receivables */
AND fa.application_id = fat.application_id
AND fat.language = USERENV ('LANG')
ORDER BY fa.application_short_name
Details on Status Column from the Query:
Installed - Implemented
Shared - Not fully Implemented
Inactive --> Not fully implemented and not used
L --> Custom
L --> Custom
***Please leave a comment***
SELECT 'Financial Module' "EBS Module"
ReplyDelete, a.application_id
, s.application_name
, substr(APPLICATION_SHORT_NAME,1,8) Application_Short_Name
, substr(PRODUCT_VERSION,1,14) version
, substr(PATCH_LEVEL,1,11) patch_level
, DECODE (p.status,'I', 'Installed','S', 'Shared','N', 'Inactive', p.status) Status_Name
FROM fnd_application a, fnd_product_installations p , fnd_application_TL s
WHERE a.application_id = p.application_id
AND a.application_id = s.application_id
AND substr(APPLICATION_SHORT_NAME,1,8) IN ('SQLGL' , 'AR' , 'SQLAP' , 'OFA')
ORDER BY 4 desc