Oracle EBS: SQL to find currently running jobs in application with start date and time details

The following query find the currently running jobs/concurrent programs in the application along with the date and time details. It's a very useful query which provide the  Request ID, Program name and provided the start date and time in the required format.

Output will be in one column under CURRENTLY_RUNNING_PROGRAMS with results like - 

Request_ID 7746467 (Program Name) has been running since 2015-04-08 14:20:31

Oracle EBS: Query to find application responsibilities assigned to a user

Following SQL query help to find all the application responsibilities assigned to a specific user or users with start date and end dates, provided a user name.
Query can be further tweaked to suit to your needs and fetch additional information life user names in detail, responsibility ID other responsibility details.