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.


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

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




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