how to know the no of concurrent request run on a particular day:------------  


select count (*) from fnd_concurrent_requests where trunc(REQUEST_DATE)='29-JUNE-16';

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
in test or uat , can change all  application user password using below query:------------

new password will be ------------- oracle1234

select user_name
  into l_usr_name
  from fnd_user
  where
  employee_id = c1.person_id
  ;
 
  lb_status := FND_USER_PKG.CHANGEPASSWORD ( username => l_usr_name, newpassword => 'oracle1234' );
 
  IF lb_status THEN
    DBMS_OUTPUT.PUT_LINE('Reset Password for user = '|| l_usr_name);
  ELSE
    DBMS_OUTPUT.PUT_LINE('Error while processing the request for user = '|| l_usr_name);
  END IF;
 
  end loop;
END;
/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++