When I try to run "My Direct Reports" query, I m not getting any results. I have analized the whole query and found that ODP_ODP_MAS_ORGRELATION table has no data in it. If we remove this table(along with its joins) and run the query then I m getting the desired output. Please refer the following attachments for further details. Can anyone help me out in solving this issue. Any help would be appreciated.
Thanks & Regards,