DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 14, 2016

Find whether user is active or Inactive in EBS


Query to Find whether user is active or Inactive in EBS



SQL :

SELECT 'Active', valid.*  FROM fnd_user valid WHERE valid.user_id IN 

(SELECT user_id FROM fnd_user WHERE NVL (end_date, SYSDATE) >= SYSDATE)

UNION ALLSELECT 'In Active', invalid.*  FROM fnd_user invalid 

WHERE invalid.user_id IN (SELECT user_id FROM fnd_user 

WHERE NVL (end_date, SYSDATE) < SYSDATE)ORDER BY 2;

No comments: