How to check Oracle Applications products installed in R12

Query to find out license products installed.

SQL> select fa.APPLICATION_SHORT_NAME, fpi.PATCH_LEVEL, DECODE(fpi.STATUS, 'I','Installed',
'S','Shared', 'N', 'Inactive', fpi.STATUS) Status , fpi.DB_STATUS
from fnd_product_installations fpi,FND_APPLICATION fa
where fpi.APPLICATION_ID in (
select APPLICATION_ID from FND_APPLICATION)
and fa.APPLICATION_ID=fpi.APPLICATION_ID;
 
 OR Other way from Front-hand.
 
1) From OAM: Oracle Applications Manager > Site Map > License Manager > Reports 
> License Products/Shared Products

2) Use $AD_TOP/sql/adutconf.sql 

 

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...