Oracle APPS Warn Bounce of Environment to Recent Users Very often, we find ourselves in a need to bounce the development or test environment. This takes some developers/testers etc by surprise. Hence I developed a simple script to list the list of recent users that use the Oracle Apps instance. We can then email the people returned by this list, to inform them of the system unavailability. SELECT ppx.full_name ,fu.user_name ,nvl(ppx.email_address ,fu.email_address) AS email_address FROM per_people_x ppx, fnd_user fu, fnd_logins fl WHERE fl.start_time > SYSDATE - 2 AND fu.user_id = fl.user_id AND ppx.person_id(+) = fu.employee_id AND fu.user_name NOT IN ('INTERFACE', 'SYSADMIN', 'GUEST') AND fu.user_name != 'PASSIA' --exclude anil GROUP BY ppx.full_name ,fu.user_name ,nvl(ppx.email_address ,fu.email_address) ORDER BY 2