select fa.application_name, fpi.product_version, fpi.patch_level, decode(fpi.status, 'I', 'Installed', 'S', 'Shared', 'N', 'Inactive', fpi.status) status from fnd_product_installations fpi, fnd_application_vl fa where fa.application_id = fpi.application_id order by fa.application_name;
Why is that we have licensed on for Financials GL, AR, AP, CM, FA but the scripts returns more that 40 licensed products?
Does Oracle will sue us for this?
The script doesn't show licensed products - it shows installed products. Some you might not be using, and there's also not a 1-1 mapping between the products and licencing. But it should give you an idea as to the footprint of your installation.