Vendor Location Not Integrating With OTM - Error - Time_zone_gid Must Refererence A Valid Time_zone Record (Doc ID 390846.1)

Last updated on SEPTEMBER 02, 2014

Applies to:

Oracle Transportation Management - Version: 5.0 to 5.0
This problem can occur on any platform.

Symptoms

On 5.0 in Production:
When attempting to send a location entry through OTM via xml,
the following error occurs.

ERROR
Error Exception Cannot update the LOCATION record. [TIME_ZONE_GID] must reference a valid
TIME_ZONE record.
java.sql.SQLException: ORA-02291: integrity constraint (GLOGOWNER.FK_LOC_TIME_ZONE) violated
- parent key not found

 

 
 

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