Integration Issues Error The object PK=XXX.123456 for table order_release was not found (Doc ID 1321224.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.1 to 6.2.2 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.1 when integrating an Order Release to OTM the Exception log contains the following error:


ERROR
-----------------------

2011-05-09 15:33:17.275 127047 Error Exception The object PK=LEE.3-3552852729 for table order_release was not found.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at glog.util.exception.GLException.factory(GLException.java:435)
at glog.util.exception.GLException.factory(GLException.java:411)
at glog.util.exception.GLException.factory(GLException.java:407)
at glog.util.exception.GLException.factory(GLException.java:395)
at glog.business.util.DatabaseLoader.loadDataContainer(DatabaseLoader.java:136)
at glog.business.order.TOrderRelease.getInstance(TOrderRelease.java:686)
at glog.ejb.order.OrderReleaseLineRecalcHelper.isRecalcLines(OrderReleaseLineRecalcHelper.java:84)
at glog.ejb.order.OrderReleaseLineRecalcHelper.calculate(OrderReleaseLineRecalcHelper.java:420)
at glog.server.total.OrderReleaseContainerRecalc.calculate(OrderReleaseContainerRecalc.java:38)
at glog.util.persistence.PrePersistence.executeRecalc(PrePersistence.java:192)
at glog.util.persistence.PrePersistence.execute(PrePersistence.java:69)
at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:101)
at glog.server.agent.business.order.ORProcessor.persist(ORProcessor.java:373)
at glog.server.agent.business.order.ORProcessorSessionBean.persistForInsert(ORProcessorSessionBean.java:61)
at glog.server.agent.business.order.ORProcessorSessionServerSideEJBWrapper.persistForInsert(ORProcessorSessionServerSideEJBWrapper.java:163)
at glog.server.agent.business.order.ORProcessorSessionHome_omnumb_EOImpl.persistForInsert(ORProcessorSessionHome_omnumb_EOImpl.java:278)
at glog.server.agent.business.order.ORAdd.process(ORAdd.java:83)
at glog.server.agent.business.order.ORActionTopic.persist(ORActionTopic.java:47)
at glog.server.agent.PersistActionTopic.execute(PersistActionTopic.java:34)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:49)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:134)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:146)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
at glog.util.event.EventThread.run(EventThread.java:82)
at java.lang.Thread.run(Thread.java:619)
[ORMD - 1]
2011-05-09 15:33:17.275 127047 Error Exception The object PK=LEE.3-3552852729 for table order_release was not found.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at glog.util.exception.GLException.factory(GLException.java:435)
at glog.util.exception.GLException.factory(GLException.java:411)
at glog.util.exception.GLException.factory(GLException.java:407)
at glog.util.exception.GLException.factory(GLException.java:395)
at glog.business.util.DatabaseLoader.loadDataContainer(DatabaseLoader.java:136)
at glog.business.order.TOrderRelease.getInstance(TOrderRelease.java:686)
at glog.ejb.order.OrderReleaseLineRecalcHelper.isRecalcLines(OrderReleaseLineRecalcHelper.java:84)
at glog.ejb.order.OrderReleaseLineRecalcHelper.calculate(OrderReleaseLineRecalcHelper.java:420)
at glog.server.total.OrderReleaseContainerRecalc.calculate(OrderReleaseContainerRecalc.java:38)
at glog.util.persistence.PrePersistence.executeRecalc(PrePersistence.java:192)
at glog.util.persistence.PrePersistence.execute(PrePersistence.java:69)
at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:101)
at glog.server.agent.business.order.ORProcessor.persist(ORProcessor.java:373)
at glog.server.agent.business.order.ORProcessorSessionBean.persistForInsert(ORProcessorSessionBean.java:61)
at glog.server.agent.business.order.ORProcessorSessionServerSideEJBWrapper.persistForInsert(ORProcessorSessionServerSideEJBWrapper.java:163)
at glog.server.agent.business.order.ORProcessorSessionHome_omnumb_EOImpl.persistForInsert(ORProcessorSessionHome_omnumb_EOImpl.java:278)
at glog.server.agent.business.order.ORAdd.process(ORAdd.java:83)
at glog.server.agent.business.order.ORActionTopic.persist(ORActionTopic.java:47)
at glog.server.agent.PersistActionTopic.execute(PersistActionTopic.java:34)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:49)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:134)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:146)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
at glog.util.event.EventThread.run(EventThread.java:82)
at java.lang.Thread.run(Thread.java:619)
[ORMD - 1]



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1 - Log onto an OTM 6.2 system.

2 - Navigate to: Business Process Automation > Integration > Integration Manager > Upload an XML/CSV Transmission.

3 - Navigated to the file to be uploaded.

4 - Click UPLOAD.

5 - The Order Release is created.

6 - The Exception log contains the error.

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