Unable To Expire Rate Record From The Actions Menu In Rate Record Screen (Doc ID 454504.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.2
This problem can occur on any platform.

Symptoms

-- Problem Statement:
In CU2, when you try to expire a rate record via the actions, you get an error:

At 2007-05-23 10:50:36.882

Cannot insert the OBJECT_LOCK record. OBJECT_ID must be set.
java.sql.SQLException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."OBJECT_LOCK"."OBJECT_ID")


java.sql.SQLException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."OBJECT_LOCK"."OBJECT_ID")

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1114)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2181)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2063)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2922)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
at glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.java:133)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:111)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:60)
at glog.server.synch.object.ObjectLock.insertOwnership(ObjectLock.java:610)
at glog.server.synch.object.ObjectLock$Hold.lock(ObjectLock.java:944)
at glog.server.synch.object.ObjectLock.tryLock(ObjectLock.java:322)
at glog.server.synch.object.ObjectLock.lock(ObjectLock.java:224)
at glog.server.synch.object.ObjectLock.lock(ObjectLock.java:206)
at glog.server.synch.object.ObjectLocks$1.lock(ObjectLocks.java:85)
at glog.server.synch.object.ObjectLocks$MultiLock.retrieve(ObjectLocks.java:165)
at glog.server.synch.object.ObjectLocks.lock(ObjectLocks.java:88)
at glog.server.synch.object.ObjectLocks.lock(ObjectLocks.java:65)
at glog.server.synch.object.ObjectLocks.lock(ObjectLocks.java:53)
at glog.server.wrapper.WrapperEventInfo.getLocks(WrapperEventInfo.java:60)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:61)
at
glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapp
er.java:42)
at
glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.j
ava:46)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:477)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:108)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)

It is obviously expected that the error doesn't get thrown and the rate record is set to expired.


-- Steps To Reproduce:
1. Select a rate record
2. Press 'actions' -> Expire Rate Record
3. Enter an expiration date and press 'ok'.

-- Business Impact:
Rates cannot be set to expired.

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