When you Refresh this LOV in BO Designer it works fine I assume?
What about the BO Document you built that is giving you the Oracle error?
Can you post that SQL?
How are you creating the prompt? Please, look the the BOB - Designer FAQ to see how to build a predefined condition which prompts the end-user and allows the value “All” as input".
Andreas 
(BOB member since 2002-06-20)