Cannot update the GTM_TRANSACTION_LINE record. PARENT_TRANS_LINE_GID must reference a valid GTM_TRANSACTION_LINE record.

(Doc ID 2400249.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Trade Compliance - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to a GTM Trade Transaction with Parent and Child Lines via Integration, the following error occurs.

ERROR
-----------------------
Cannot update the GTM_TRANSACTION_LINE record. PARENT_TRANS_LINE_GID must reference a valid GTM_TRANSACTION_LINE record. java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_GTL_GTM_PRNT_TRNS_LN_GID) violated - parent key not found java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_GTL_GTM_PRNT_TRNS_LN_GID) violated - parent key not found at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246) at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216) at glog.util.jdbc.noserver.SqlPreparedStatement.executeBatch(SqlPreparedStatement.java:99) at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:240) at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:346) at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:261) at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:160) at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:399) at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:323) at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:207) at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:243) at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:180) at glog.util.persistence.BeanDataPersistenceExecutor.insertPerformed(BeanDataPersistenceExecutor.java:97) at glog.util.persistence.BeanDataPersistenceExecutor.insertUpdatePerformed(BeanDataPersistenceExecutor.java:116) at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:93) at glog.util.persistence.InsertUpdate.doPersist(InsertUpdate.java:100) at glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:54) 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:76) at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:177) at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34) at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(Unknown Source) at glog.integration.xmlbasewrapper.XmlBaseWrapper.persist(XmlBaseWrapper.java:292) at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistContainerSelf(XmlBaseWrapper.java:328) at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:397) at gtm.integration.application.gtmtransaction.GtmTransactionInterface.persistXML(GtmTransactionInterface.java:42) at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:195) at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:223) at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:355) at glog.server.workflow.transproc.TransProc.execute(TransProc.java:111) at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23) at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64) at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:40) at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34) at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(Unknown Source) at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:356) at glog.server.workflow.Trigger.trigger(Trigger.java:122) at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:145) at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:100) at glog.util.event.EventThread.run(EventThread.java:86) at java.lang.Thread.run(Thread.java:745)


Example
-----------------------

<GtmTransactionGid>
<Gid>
<DomainName>IBAHGAT</DomainName>
<Xid>105889643-2-PR</Xid>
</Gid>
</GtmTransactionGid>
<GtmTransactionLine>
<GtmTransactionLineGid>
<Gid>
<DomainName>IBAHGAT</DomainName>
<Xid>105889643-2-PR-1023716072</Xid>
</Gid>
</GtmTransactionLineGid>
<TransactionCode>IU</TransactionCode>
<TransLineType>TRANSACTION_LINE</TransLineType>
</GtmTransactionLine>
<GtmTransactionLine>
<GtmTransactionLineGid>
<Gid>
<DomainName>IBAHGAT</DomainName>
<Xid>105889643-2-PR-1023715134</Xid>
</Gid>
</GtmTransactionLineGid>
<TransactionCode>IU</TransactionCode>
<ParentTransactionLineGid>
<Gid>
<DomainName>IBAHGAT</DomainName>
<Xid>105889643-2-PR-1023716072</Xid>
</Gid>
</ParentTransactionLineGid>
<TransLineType>TRANSACTION_LINE</TransLineType>
</GtmTransactionLine>



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