bpel-console gives SQLException: ORA-00933 with Oracle11G database

Issue

We performed the default installation of SOA Platform 5.2, and we have configured it to use the Oracle 11g database using the tools/schema util.
When we try to login in the BPEL console (http://host:port/bpel-console), it throws an exception:

org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Failed to execute query  
at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:263)  
at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:169)  
at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:146)  
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:456)  
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:418)  
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:111)  
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:217)  
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:159)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)  
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)  
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)  
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)  
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:599)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)  
at java.lang.Thread.run(Unknown Source)  
Caused by: java.lang.RuntimeException: Failed to execute query  
at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:73)  
at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.getProcessDefinitions(DefaultBPAFDataSource.java:97)  
at org.jboss.soa.bpel.console.ProcessHistoryPluginImpl.getProcessDefinitions(ProcessHistoryPluginImpl.java:114)  
at org.jboss.bpm.console.server.ProcessHistoryFacade.getProcessDefinitionKeys(ProcessHistoryFacade.java:77)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:124)  
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:247)  
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:212)  
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:202)  
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:441)  
... 29 more  
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query  
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)  
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:103)  
at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:104)  
at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:98)  
at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:68)  
... 41 more  
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query  
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)  
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)  
at org.hibernate.loader.Loader.doList(Loader.java:2458)  
at org.hibernate.loader.Loader.doList(Loader.java:2440)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2316)  
at org.hibernate.loader.Loader.list(Loader.java:2311)  
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:321)  
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1766)  
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)  
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)  
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:94)  
... 44 more  
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended  
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)  
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)  
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:184)  
at oracle.jdbc.driver.T4CPreparedStatement.execute\_for\_describe(T4CPreparedStatement.java:502)  
at oracle.jdbc.driver.OracleStatement.execute\_maybe\_describe(OracleStatement.java:964)  
at oracle.jdbc.driver.T4CPreparedStatement.execute\_maybe\_describe(T4CPreparedStatement.java:534)  
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1050)  
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2983)  
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3025)  
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)  
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:1997)  
at org.hibernate.loader.Loader.doQuery(Loader.java:840)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:298)  
at org.hibernate.loader.Loader.doList(Loader.java:2455)

After enabling SQL logging, the SQL query causing the problem was found to be:

select distinct e.PROCESS\_DEFINITION\_ID from BPAF_EVENT as e