Hi, Thanks for your response. Ideally yes I would try to take care of this within the init block itself but i am having trouble doing so. Here is the query to generate the departments for 1 of these 5 users responsible department; select distinct department from employee_department where sup_full_id =UPPER('User1')…