My Oracle Support Banner

Dead Lock And Foreign Key Violation Error While Interfacing Customer Information To GTM. (Doc ID 1351898.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Global Trade Management - Version: 6.2.1 to 6.2.7 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.1 when we interface a XML for customers for which location is not there in GTM, the system will try to create the location on the fly and then this location can be referenced in the contact. The single XML if uploaded from the GTM UI through XML upload utility, it gets processed successfully, but when running my interface program it will generate many XMLs for different contacts and locations at the same time due to which I am getting 2 types of errors.

a) Dead Lock error detected while waiting for the resource.
b) Foreign key element contact.location_gid must reference a valid location_gid in location table. ( This may happen when system is trying to create contact even before the location is created).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.