Vendor Location Not Integrating With OTM - Error - Time_zone_gid Must Refererence A Valid Time_zone Record
Last updated on SEPTEMBER 02, 2014
Applies to:Oracle Transportation Management - Version: 5.0 to 5.0
This problem can occur on any platform.
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
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