Solved

How to query user license usage

+24

This is an apps 9 question but i think is equally valid for Apps 10 and later

Is it possible to write a sql query that pulls out a list of active users and their current IFS license usage?

Best answer by ShawnBerk

@paul harland

Ahhh, like this then?

select * from INST1APP.fnd_licensed_role_user

+28

@paul harland

Is this what you are seeking?

SELECT fnd_license_api.get_licensed_full_users FROM DUAL;

SELECT fnd_license_api.get_consumed_full_users FROM DUAL;

+24

hi @ShawnBerk ,

no sorry i am looking for a list like

User A Full

User B Full

User C ShopFloor

+28

@paul harland

Ahhh, like this then?

select * from INST1APP.fnd_licensed_role_user

+24

great thank you Shawn, that will do the job.

FND_FULL_USER is also a useful view

Sign up