Error while using Sequential attribute of Sub Process Task Instance (Doc ID 1084153.1)

Last updated on APRIL 05, 2013

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 and later
Information in this document applies to any platform.
*** Checked for Currency on 05-APR-2013 ***

Symptoms

The following errors were received while using the Sequential attribute of a Sub Process Task Instance:

<Apr 12, 2010 4:30:03 PM IST> <Error> <oms.core> <600129> <SQL Exception 6,502 : ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
Truncated. see log file for complete stacktrace
>
<Apr 12, 2010 4:30:03 PM IST> <Error> <oms.core> <600108> <An OMS Exception has been thrown. Reason: com.mslv.oms.handler.InternalErrorException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1
: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1

com.mslv.oms.handler.InternalErrorException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1
: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1

at com.mslv.oms.handler.a.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
Truncated. see log file for complete stacktrace
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ORDERMGMT.OM_WF_API", line 748
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5309
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3864
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 417
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
Truncated. see log file for complete stacktrace
>
<12-Apr-2010 4:35:02,875 IST PM> <INFO> <jboss.CascadingLRUPolicy> <Timer-2> <Evicting order /1165 from order cache due to cache entry expiry>

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