Convert To Route Template Errors Out
(Doc ID 553005.1)
Last updated on FEBRUARY 03, 2019
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.
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