Convert To Route Template Errors Out (Doc ID 553005.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Cooperative Routing - Version: 5.5
This problem can occur on any platform.

Symptoms

-- 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.

Cause

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