Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Cooperative Routing - Version: 5.5
This problem can occur on any platform.
When you the action "Convert to Route Template", OTM generates an error.
2007-12-17 09:56:40.293 195809 Error Exception Cannot update the ROUTE_TEMPLATE_REFNUM record.
[ROUTE_REFNUM_QUAL_GID] must reference a valid ROUTE_REFNUM_QUAL record.
java.sql.SQLException: ORA-02291: integrity constraint (GLOGOWNER.FK_RTR_ROUTE_REFNUM_QUAL_GID)
violated - parent key not found
-- Steps To Reproduce:
Asset Management -> Cooperative Routing -> CR Route
Execute an open search and select any of the returned Routes. Then select the Convert to Route Template action
-- Business Impact:
Users are unable to systematically import routes from CR into XCR.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms