Shouldn't the more important verb be the last of the two? Therefore: "Wo ist das Bier das ich habe bestellt"?
For some reason, it doesn't accept "das ich bestellte". Reported.
Still not accepted, although it should have, IMHO.
Why "habe" is included?
It's the equivalent of English's "that I have ordered"
"... das ich fordern habe?"?
I believe that fordern is the wrong verb, it's more to ask for something in a kind of demanding way - which perhaps someone could better confirm... The form is wrong though: you should have "das ich gefordert habe".