Skip to main content

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?

@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;

hi @ShawnBerk ,

no sorry i am looking for a list like

 

User A            Full

User B            Full

User C            ShopFloor

@paul harland 

Ahhh, like this then?

select * from INST1APP.fnd_licensed_role_user

great thank you Shawn, that will do the job.  

FND_FULL_USER is also a useful view

Reply


Terms & ConditionsCookie settings