Oracle active users query

Oracle active users query

In this post , We will be discuss about Oracle active users query. using query will help to extract the Active users in oracle . We will be able to find out the Oracle active users using this query. This is one of the useful sql query to get the details of active users in oracle apps. Her below is the detail about Oracle active users query.

Oracle active users query

3 Important Table used by Oracle active users query

These are the below important tables helps to fetch the Oracle active users query.

1.fnd_responsibility_vl

2.fnd_user fu,

3.fnd_user_resp_groups_direct

Detail Oracle active users query

SELECT fu.user_name,

       frv.responsibility_name,

       frv.responsibility_key,

       TO_CHAR (furgd.start_date, 'DD-MON-YYYY') "START_DATE",

       TO_CHAR (furgd.end_date, 'DD-MON-YYYY') "END_DATE"

FROM fnd_user fu,

  fnd_user_resp_groups_direct furgd,

  fnd_responsibility_vl frv

WHERE fu.user_id                     = furgd.user_id

AND furgd.responsibility_id          = frv.responsibility_id

AND furgd.end_date IS NULL

AND furgd.start_date                <= sysdate

AND NVL(furgd.end_date, sysdate + 1) > sysdate

AND fu.start_date                   <= sysdate

AND NVL(fu.end_date, sysdate + 1)    > sysdate

AND frv.start_date                  <= sysdate

AND NVL(frv.end_date, sysdate + 1)   > sysdate;

SELECT frv.responsibility_name,

       frv.responsibility_key,

       TO_CHAR (frv.start_date, 'DD-MON-YYYY') "START_DATE",

       TO_CHAR (frv.end_date, 'DD-MON-YYYY') "END_DATE"

FROM fnd_responsibility_vl frv

WHERE  frv.start_date                  <= sysdate

AND NVL(frv.end_date, sysdate + 1)   > sysdate;

Oracle active users query

Oracle active users query