See the number of licenses on an IFS Cloud environment

Hi @TheoB 

License metrics show details from monthly ordered report which is based on montly scheduled backgroud job task. I know this is very complex way. I do not why. Someone forgot about UX.

Currenlty we are using quick report to check current license usage. Check below query:

SELECT
(SELECT count(*) FROM fnd_licensed_role_user WHERE ROLE_SCOPE = 'FULL') "FULL",
(SELECT count(*) FROM fnd_licensed_role_user WHERE ROLE_SCOPE = 'LIMITED') "LTU",
(SELECT count(*) FROM fnd_licensed_role_user WHERE ROLE_SCOPE = 'ADDITIONAL') "ADDITIONAL",
Fnd_User_API.Get_License_Metric_LTU_Users "LTU",
Scan_It_APN.Get_Fndmob_Native_App_Users "SCAN IT - Wadaco",
Fnd_User_API.Get_License_Metric_Full_Users "Full User"
FROM DUAL;

Hi @knepiosko,

Thank you for this information, it will help me.
Is it possible to know also the number of licenses allowed? Is this information available in ORACLE view?

There is no limit. I do not know what will be if customer will consume more licenses than requested.

LTU is double defined which causes an error (easy to solve).

Security not included, so I inserted ifsapp. in front of all places where view or api is used. Security issues all over the place. Can't log in as ifsapp as I am in an IFS22R1 environment. I do have full access via the permissions sets that are set up.

What am I missing? Am I the only one with this kind of trouble?

I've used a Quick Report to run the SQL statement. Is this only available via build place?

Hi @eqbstal 

Try to reduce query like this:

SELECT
Fnd_User_API.Get_License_Metric_LTU_Users "LTU",
Fnd_User_API.Get_License_Metric_Full_Users "Full User"
FROM DUAL;

In some scenario Wadaco module might be missing.