Re-processing a Transmission (I_TRANSMISSION) Creates Duplicate Transaction (I_TRANSACTION) Records. (Doc ID 2215039.1)

Last updated on DECEMBER 16, 2016

Applies to:

Oracle Transportation Management - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms

Re-processing a transmission (I_TRANSMISSION) creates duplicate transaction (I_TRANSACTION) records.

While reprocessing a previously completed transmission, regardless of processing status, creates additional records in transaction (I_TRANSACTION) table.

 

NOTE: This only happens with the inbound transmissions are coming via Direct XML Insert API (GLOGOWNER.PKG_INTEGRATION_UTIL.insert_transmission)

 

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