My Oracle Support Banner

OSM Task UI Is Giving An Oracle Exception ORA-00936 While Displaying The Worklist (Doc ID 1932474.1)

Last updated on OCTOBER 08, 2014

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 and later
Information in this document applies to any platform.


When a user creates a new worklist preference and sets a filter on one of the field and saves the worklist preference and comes back to Worklist screen, OSM displays on Oracle exception ORA-00936: missing expression

<ExecuteThread: '19' for queue: 'oms.web'> >
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError( oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
  at oracle.jdbc.driver.OraclePreparedStatement.execute(
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
  at weblogic.jdbc.wrapper.PreparedStatement.execute(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
  at weblogic.jdbc.wrapper.PreparedStatement.execute(
  at com.mslv.oms.dataaccessl


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.