Hiring manager and recruiter's full names not displayed in anaylsis

Question

Hello experts,

we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear front end in the system, but not in the analysis, theire field are empty for all the job requisitions. Does anyone know why and how can we fix this issue? Thanks in advance. Best regards. Oriana

RVohra · Answer

Hi @Sophie Haller , Welcome to the Oracle Analytics Community!

This forum was last updated more than 18 months back. I would suggest starting a new thread with as much details as possible. It will help the community to understand the issue with new perspective and making it easier to step in and help.

Sophie Haller · Answer

Hello @Oriana L. ,

has there been a solution for this? I'm experiencing the same issue but only for a few requisitions for the hiring manager's name.

Best,

Sophie

Oriana L. · Answer

Hello @Nathan CCC , I attach here the sql query available in the Advanced tab. Being honest, I don't think is a matter of security, because I'm creating this report with a superuser account, who has no restrictions. Thanks again for your suggestions. Regards. Oriana

AdvancedTab.txt