select a.application_short_name, b.status
from fnd_application a
, fnd_product_installations b
where a.application_id = b.application_id
and application_short_name= 'ALR';
Oracle Alert is included in the EBS license.
Thanks, Alert isn't listed separately in the licensing guide, apart from whether additional licenses are required for modification. This document (https://docs.oracle.com/cd/E18727_01/doc.121/e12894/T202991T202996.htm) however says this:
Oracle Alert Runtime Features
If you do not have a licensed copy of the full Oracle Alert product, you may still derive benefit from major Oracle Alert features by using the predefined alerts that are packaged with your Oracle E-Business Suite product.
All Oracle E-Business Suite products are packaged with a runtime version of Oracle Alert. Although all the Oracle Alert windows are available in this runtime version, not all the features in those windows are enabled. With the runtime version of Oracle Alert, you can run only the predefined alerts that are packaged with your product; you cannot create new alerts.
which appears to suggest that whilst seeded alerts are included in the runtime version, the option to use custom alerts requires a full licensed copy. We can't find anywhere though which suggests the licenses needed, pricing, etc...