Query to check installed modules in Oracle EBS


The below query query gives the list of Installed/Not Installed/Shared Product Modules in Oracle E-Business Suite (EBS) application

set pages 20000;
col application_id for 9999;
col application_name for A50;
col status for A1;
col application_short_name for A10;
select fa.application_id,
fa.application_short_name,
fpi.status,
fatl.application_name
from
fnd_product_installations fpi,
fnd_application fa,
fnd_application_tl fatl
where
(
fa.application_id = fpi.application_id and
fa.application_id = fatl.application_id and
fatl.language = ‘US’
)
order by fa.application_short_name;

Check for values in Status column of the output, usually either I or N or S.

I – Installed
S – Shared
N – Not Licensed

13 thoughts on “Query to check installed modules in Oracle EBS”

  1. Thank you for every other great article. The place else may anybody get that type of info in such a perfect approach of writing? I have a presentation next week, and I’m on the look for such info.

  2. Just desire to say your article is as amazing. The clarity on your post is just cool and that i could think you’re an expert in this subject. Fine with your permission let me to grasp your feed to stay updated with coming near near post. Thanks one million and please continue the enjoyable work.

Leave a Reply

Your email address will not be published. Required fields are marked *