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

21 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.

  3. The following time I read a weblog, I hope that it doesnt disappoint me as much as this one. I mean, I do know it was my option to learn, however I really thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you could possibly repair if you happen to werent too busy searching for attention.

  4. This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

Leave a Reply

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