I saw a question on Oracle IT Toolbox the other day. A subject which I mentioned this earlier.
Passing special characters in Oracle BI EE is something you should avoid as much as possible. If you have to cope with these special characters, eg. in a GO-url, please refer to a site which handles HTML URL Encoding; http://www.w3schools.com/TAGS/ref_urlencode.asp
If you have a string with spaces, you could use the ‘REPLACE’-function to substitute the space with; ‘%20’. If necessary you could nest the ‘REPLACE’-function to also substitute ‘&’ with ‘%26’.
Something like; REPLACE(REPLACE(string, ‘ ‘, ‘%20’), ‘&’, ‘%26’)
Good Luck
For URL encoding, to convert URL to safe format
URL Encoding
LikeLike