SQL for getting the active user details in Oracle HCM Cloud environment

Sample SQL Query (You can modify as required):

-----------------------------------

SELECT P.PERSON_NUMBER

,U,USERNAME

,U.ACTIVE_FLAG

,U.SUSPENDED

FROM PER_USERS U, PER_ALL_PEOPLE_F P

WHERE U.PERSON_ID = P.PERSON_ID

AND U.ACTIVE_FLAG = 'Y'

AND U.SUSPENDED = 'N'

AND TRUNC(SYSDATE) BETWEEN TRUNC(P.EFFECTIVE_START_DATE) AND TRUNC(P.EFFECTIVE_END_DATE)