My Oracle Support Banner

Convert To Route Template Errors Out (Doc ID 553005.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Cooperative Routing - Version 5.5 and later
Information in this document applies to any platform.


-- Problem Statement:
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.