ORA-01797 : this operator must be followed by ANY or ALL State:N/A in Designer XI R2

Sometimes this error may unexpectedly. The same thing happened with me while working on a universe. I did not change any thing in the universe except that I was working on enhancements. I never created any conditions or modified any of the existing ones.

When I started doing the check integrity, I faced this error in 22 conditions. I am totally surprised by this error:

Prompts in universe were looking like this or something similar:

TABLE1.INTERVENTION_DATE <= (SELECT DISTINCT (TABLE2.TIME_PERIOD_END_DATE) from TABLE2 WHERE TABLE2.TIME_PERIOD = @Prompt('Select Time Period (Quarter or Month)','A','Class\Object',MONO,FREE) AND TABLE2.TIME_PERIOD_TYPE='FQ') When I parse the object the following error is displayed.








Resolution:

TABLE1.INTERVENTION_DATE <= (SELECT DISTINCT (TABLE2.TIME_PERIOD_END_DATE) from TABLE2 WHERE TABLE2.TIME_PERIOD IN @Prompt('Select Time Period (Quarter or Month)','A','Class\Object',MONO,FREE) AND TABLE2.TIME_PERIOD_TYPE='FQ')

-- Removing '=' sign and adding IN in front of the prompt get rid of this error.