In Oracle Application E-Business Suite, there was range of financial & logistic product installed at first place.

But some was not enable after installation, and you may check if the product was installed or not by using the query as below.

SELECT substr(app.application_short_name,1,10) Name ,
app.application_id ,
pi.product_version ,
pi.STATUS ,
pi.patch_level
FROM fnd_product_installations pi ,
fnd_application app
WHERE app.application_id = pi.application_id
AND app.application_short_name LIKE '%GL%'
ORDER BY app.application_short_name;
 
Note: WHERE STATUS can be I - installed, S - shared , N - NOT installed

If the status was not ‘I’, then you can update it by using the statement as below to enable the Oracle product license. Make sure you backup the fnd_product_installations before proceed to the update statement

UPDATE fnd_product_installations
SET STATUS = 'I' 
WHERE application_id = <application id>
AND STATUS = 'S'

As an alternative, you can enable the product license by login into OAM – Sitemap – License – Products if you are comfortable using the update statement as above.

Related Posts

• Enable Trace On Concurrent Program
• Oracle Application Security Hardening
• Enable ODISRV Trace For DIP Provisioning
• Oracle Application Server Shutdown Problem
• Oracle Process Locking