Hello,
I would like to know if there is a screen like on APPS10 that allows you to see the total number of licenses on an IFS Cloud environment?
I know there is the "License metrics" screen on Cloud, but I can't find the information on this screen.
Thanks in advance.
See the number of licenses on an IFS Cloud environment
Hi
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
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.
Userlevel 7
+21
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
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.