Reference Variable showing no records found however on backend view able to see the records

shraddhakad
Tera Contributor

Hello Everyone

 

I am receiving an issue - I have created one record producer and added one Reference variable with the table called Benefits Plan. When I impersonated the snc_internal role users they are not able to see the records in the variable.

 

I have created Read ACL on this table and added the snc_internal role however it is not working. My PDI version is in Yokohoma.

 

Your response is highly appreciated.

 

Thank you.

1 ACCEPTED SOLUTION

Shraddha Kadam
Mega Sage

Hi Shraddha,

 

There is an query_range ACL on sn_hr_core_benefit_provider.* table. Add the required role into it and change the security attribute from existing to local and your issue will be resolved.

 

Please mark my answer helpful if your answer is resolved.

 

Thank you.

If my response was helpful, please mark it as correct and helpful.
Thank you.

View solution in original post

1 REPLY 1

Shraddha Kadam
Mega Sage

Hi Shraddha,

 

There is an query_range ACL on sn_hr_core_benefit_provider.* table. Add the required role into it and change the security attribute from existing to local and your issue will be resolved.

 

Please mark my answer helpful if your answer is resolved.

 

Thank you.

If my response was helpful, please mark it as correct and helpful.
Thank you.