Skip to main content
Question

See the number of licenses on an IFS Cloud environment

  • April 7, 2023
  • 5 replies
  • 589 views

Forum|alt.badge.img+13
  • Hero (Partner)
  • 161 replies

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.

5 replies

Forum|alt.badge.img+17
  • Superhero (Partner)
  • 514 replies
  • April 7, 2023

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;

 

 


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 161 replies
  • April 7, 2023

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?


Forum|alt.badge.img+17
  • Superhero (Partner)
  • 514 replies
  • April 7, 2023

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


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 701 replies
  • April 11, 2023

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?


Forum|alt.badge.img+17
  • Superhero (Partner)
  • 514 replies
  • April 12, 2023

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.