Search This Blog

Wednesday, August 17, 2016

Oracle Apps R12 Query to view users attached to Financial Modules



SELECT count(distinct FU.USER_ID)FINANCE_USERS
--select last_logon_date ,FU.USER_NAME,RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID,FNDG.DESCRIPTION
from FND_USER_RESP_GROUPS_DIRECT FNDG,
FND_USER FU
WHERE fu.user_id= FNDG.USER_ID
--and fu.user_id = 2605
and RESPONSIBILITY_APPLICATION_ID in (200,222,260,140,101)
--and last_logon_date > to_date('01-jun-2016')  --enable if you want to see only recent employees.
--Payables,Receivables,Cash Managament, Assets,General Ledger

No comments:

Post a Comment