How can we report on record producer variables in hr case using database view? It shows me Application restricted error.

[masoomsharma]

I was creating a database view between question_answer and hr case which is in Human Resources Core application but it gives me error and doesnt allow me to create it. Any idea how can we do it?

[Harsh Vardhan]

Hi Masoom,

Record producer variable store in "Question Answer (question_answer)" table.

You can use the the "table_sys_id" field to correlate the data to it's related data on the referring table.

Check the below thread. hope it will help you.

Reporting on question_answer table

Thanks,

Harshvardhan

[masoomsharma]

I already went through this. In our instance, HR Cases are in Human Resources : Core Application scope so i am not able to create database view combining question_answer which is in global scope .

Any idea how can we resolve this?

[Harsh Vardhan]

Hi Masoom,

have you tried to use "application design access" ?.and make the source scope as ur application and target scope would be ur table and columns package.

check the below screenshot.

Thanks,

Harshvardhan

[masoomsharma]

Yes, i tried after seeing your post but it didnt help