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
This was huge information for all those who need this. That was a really good blog and of course knowledgeable. Thank you for sharing this information with us. oracle fusion scm
Such a great blog, thanks for sharing the blog.
scope of automation testing
data science job opportunities
data scientist jobs for freshers
common errors in english with explanation
node js questions for interview
interview questions on pega
thank you, Also can you please tell me if you want to enable a module in 12.2, what are the steps or oracle document to follow?
This comment has been removed by the author.
Checks with missing or incorrect information may not be cashed.
Check cashing at 7-Eleven