ORA-02289: Sequence Does Not Exist Error Using Drop down Remark On GTM_TRANSACTION Manager Layout (Doc ID 1621445.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.3.4 [Release 6.3]
Information in this document applies to any platform.

Symptoms


  When attempting to create a custom GTM Manager Layout for GTM_TRANSACTION and using a remark (P) field with a drop down , the following error occurs.

 -- Error
java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:164)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:105)
at gtm.ejb.transaction.GtmTransactionRemarkBean.ejbCreate(GtmTransactionRemarkBean.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at glog.util.bean

 -- Steps
 The issue can be reproduced at will with the following steps.

1. Created a copy of Screenset GTM_TRANSACTION
2. Created a copy of Manager Layout GTM_TRANSACTION
3. Add the custom Manager Layout to the Screen Set an on the General tab (both New and Edit fields)
4. Searched for the custom Manager Layout, Click Edit and make the following changes on the Detail Tab:
     a) Click Customize Section at the top and click Add field
     b) Add a Remark Text (P).
     c) Make it a Fixed List
     d) Click Save and Ok.
     e) Click Finished.
5. Add the New Screenset Created to your menu

Steps to Replicate:

1. Click on the new Menu Item added to your menu
2. Click "New" to add a new GTM Transaction.
3. Select a value in your new field
5. Click Finished to save the record.
6. Note the following error:

glog.util.exception.CreateExceptionWrapper
java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeQuery(SqlPreparedStatement.java:35)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:164)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:105)
at gtm.ejb.transaction.GtmTransactionRemarkBean.ejbCreate(GtmTransactionRemarkBean.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at glog.util.beandata.BeanDataHelper$EjbCreate.runAndThrow(BeanDataHelper.java:360)
at glog.util.ThrowablePrivilegedAction.run(ThrowablePrivilegedAction.java:12)
at glog.util.ThrowablePrivilegedAction.doPrivileged(ThrowablePrivilegedAction.java:26)
at glog.util.beandata.BeanDataHelper$BeanCallback.call(BeanDataHelper.java:220)
at glog.util.beandata.BeanDataHelper$BeanCallback.call(BeanDataHelper.java:199)
at glog.util.beandata.BeanDataInserter.preCreate(BeanDataInserter.java:379)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:195)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:232)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:171)
at glog.util.persistence.BeanDataPersistenceExecutor.insertPerformed(BeanDataPersistenceExecutor.java:97)
at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:91)
at glog.util.persistence.WaterFallInsertion.performedInsertion(WaterFallInsertion.java:264)
at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:106)
at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:137)
at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:49)
at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:122)
at glog.server.compareengine.TopicPublisher.persist(TopicPublisher.java:161)
at glog.server.compareengine.TopicPublisher.publish(TopicPublisher.java:64)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:116)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:77)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compare(GenericContainerUtilSessionBean.java:139)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compareAndStore(GenericContainerUtilSessionBean.java:126)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:292)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(Unknown Source)
at glog.webserver.update.AbstractUpdate.callGenericContainer(AbstractUpdate.java:359)
at glog.webserver.update.GenericContainerXMLUpdate.process(GenericContainerXMLUpdate.java:131)
at glog.server.xmlupdate.XMLUpdateSessionBean.updateAndTrack(XMLUpdateSessionBean.java:244)
at glog.server.xmlupdate.XMLUpdateSessionServerSideEJBWrapper.updateAndTrack(XMLUpdateSessionServerSideEJBWrapper.java:376)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_EOImpl.updateAndTrack(Unknown Source)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


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