Cause

You tried to change an orient constraint’s interpolation type to Flip Mode, but not all the constrained object’s rotation channels are driven by the constraint.

The orient constraint works in quaternions, so its solution involves all three rotation axes. That is why when an orient constraint drives only one or two of a constrained object’s rotation channels, the No Flip interpolation type has no effect.