Auto Assignment Rule Causes Insert to Fail When Using Transaction Code II (Doc ID 469711.1)

Last updated on JULY 09, 2012

Applies to:

Oracle Transportation Management - Version 5.5.03.01 and later
Information in this document applies to any platform.
Checked for relevance on 02-Aug-2010


Symptoms

-- Problem Statement:
When attempting to assign an Involved Party via ADA (Auto-Data Assignment) on a stand-alone order release, the following error is observed:

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION:
glog.util.exception.CreateExceptionWrapper Cannot update the ORDER_RELEASE_INV_PARTY record.
[ORDER_RELEASE_GID] must reference a valid ORDER_RELEASE record. java.sql.SQLException: ORA-02291:
integrity constraint (GLOGOWNER.FK_ORIP_ORDER_RELEASE_GID) violated - parent key not found
java.sql.SQLException: ORA-02291: integrity constraint (GLOGOWNER.FK_ORIP_ORDER_RELEASE_GID)
violated - parent key not found 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:2905) at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644) at
weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147) at
glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.java:133) at
glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:109) at
glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:60) at
glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:793) at
glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:195) at
glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1066) at
glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:191) at
glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:460) at
glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:803) at
glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:457) at
glog.ejb.order.db.OrderReleaseInvPartyBeanDB.ejbCreate(OrderReleaseInvPartyBeanDB.java:61) at
glog.ejb.order.ejb_OrderReleaseInvParty_mrvoz2_Impl.ejbCreate(ejb_OrderReleaseInvParty_mrvoz2_Impl.j
ava:255) at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.O
bject;(Unknown Source) at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source) at weblogic.ejb20.manager.ExclusiveEntityManager.create(ExclusiveEntityManager.java:750)
at weblogic.ejb20.manager.ExclusiveEntityManager.remoteCreate(ExclusiveEntityManager.java:721) at
weblogic.ejb20.internal.EntityEJBHome.create(EntityEJBHome.java:249) at
glog.ejb.order.ejb_OrderReleaseInvParty_mrvoz2_HomeImpl.create(ejb_OrderReleaseInvParty_mrvoz2_HomeI
mpl.java:120) at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.O
bject;(Unknown Source) at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source) at glog.util.remote.BeanBaseInvoker.invoke(BeanBaseInvoker.java:50) at
glog.util.remote.EntityBeanHomeInvoker.create(EntityBeanHomeInvoker.java:86) at
glog.util.persistence.EjbPersistenceExecutor.insertNoDupPerformed(EjbPersistenceExecutor.java:131)
at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:101) at
glog.util.persistence.WaterFallInsertion.performedInsertion(WaterFallInsertion.java:291) at
glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:112) at
glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:53) at
glog.util.persistence.InsertUpdate.doPersist(InsertUpdate.java:130) at
glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:72) at
glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:121) at
glog.server.agent.business.order.ORProcessor.persist(ORProcessor.java:359) at
glog.server.agent.business.order.ORProcessorSessionBean.persistForInsert(ORProcessorSessionBean.java
:61)


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