Variables referencing customer_contact table is not returning any results for end-users even after allowing ACL access to this table.
There is a before query Business Rule adding an additional query to prevent users from viewing the content.
You can do one of these 2 things,
- Disable Business Rule "Contact query for customer": /sys_script.do?sys_id=47d2e4dbc3101200b12d9f2974d3aee0
- (Please Note: this BR was intended to prevent users from seeing records on this table)
- Query the sys_user table instead of the customer_contact table