Compensation Eligibility EIB Fails on Cross-Tenant Load with Any-in-Selection-List Operator
The error The entered information does not meet the restrictions defined for this field. (Relational_Operator_Reference).
What it means
This happens when you extract a Compensation Eligibility Rule EIB spreadsheet from one tenant and try to load it into a different tenant. It only fails on the condition rows that use the "any in the selection list" relational operator, other operators load fine.
Troubleshooting
- Confirm the failing rows all use the "any in the selection list" relational operator, compare against a passing row that uses a different operator.
- Check whether the referenced value list (the set being selected from) exists with the same IDs in the target tenant. Cross-tenant loads often carry over Reference_ID values that only resolve in the source tenant.
- Try switching the ID type on the affected columns from Reference_ID to WID and reconfirm, this rules out an ID-type mismatch even though it did not resolve the case in the source thread.
- If the error persists regardless of ID type, treat it as a target-tenant configuration gap rather than a spreadsheet formatting issue.
⚡ Quick fix
Manually recreate the failing condition rules directly in the target tenant's Compensation Eligibility Rule UI instead of pushing them through the EIB.
✓ Permanent fix
Before any cross-tenant EIB migration involving list-based relational operators, verify the underlying value lists and their IDs already exist and match in the target tenant, not just the object being loaded.
Was this helpful?