The bad news is that H-P did not choose to develop queries on the Oracle platform that are not case sensitive. Apparently, on the MS SQL platform, you have more flexibility in this regard.
The good news, which will only partially address the issue of case sensitivity on an Oracle platform, is that any query should have a box on the second tab for case sensitivity. Make sure it is not checked before running the query.
Are you concern that because you type a service in lowercase, it does not match an existing service which is in upper case ? If that's the "case" (sorry bad pun, I couldl't resist), you can create an UI rule to populate the service field with the uppercase one whenever it detects lowercase service field or vice versa.