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.

Symptoms

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(T4CTTIoer.java:457)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1411)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
  at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
  at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
  at com.mslv.oms.dataaccessl

Cause

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 hundreds of Community platforms