HCM Groups erroring on refresh

Summary

HCM Groups erroring on refresh

Content

Dear Experts

We have HCM Groups based on Value Sets that are based on SQL queries. The reason we are using queries is that we have a complex system based on EFF's to handle Group membership exceptions. Unfortunately although the queries are working perfectly fine in BI Publisher datamodels the HCM Group Refresh is giving an error. The same query with a different Legal Entity is working in a different HCM Group. I have compared the two to the level spaces, dots and commas and they are exactly the same. Both are working on BI Publisher