Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Seeking Seeded Report for Active Users in Oracle Fusion
We need to generate a report that shows the number of active users in our Oracle fusion system. I came across the below link the Admin Reports navigation that provides some dashboards, but I am unable to find a specific seeded report that meets this requirement.
https://docs.oracle.com/en/cloud/saas/field-service/fasmr/t-number-of-active-users.html
Currently, I am utilizing the following SQL script to retrieve the necessary information:
CopyReplit
SELECT DISTINCT
pu.username AS USER_NAME,
papf.person_number AS EMPLOYEE_NUMBER,
ppn.first_name AS EMPLOYEE_FIRST_NAME,
ppn.last_name AS EMPLOYEE_LAST_NAME,
DECODE(pu.SUSPENDED, 'Y', 'Inactive User', 'N', 'Active User') AS USER_STATUS,
Tagged:
0