When The System Creates The Carrier Response Template, There Are 3 Column Headings that are (Doc ID 560545.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Sourcing - Version: 5.5.03
This problem can occur on any platform.

Symptoms

-- Problem Statement:
When uploading carrier response template, the following error will occur.

ERROR:
When uploading csv, get this error:
ORA-20001:Bid DOMAIN.DATA as invalid computed cost of 0 ORA-06512: at “GLOGOWNER.P_BID_U”, line 48 -04088: error during execution of trigger ‘GLOGOWNER_BID_IU’ ORA-06512: at “GLOGOWNER.TRANSFORM”, line 1883 ORA-06512: at “GLOGOWNER.P_CARRIERSPONSE_INSERT”, line 64 ORA-04088: error during execution trigger ‘GLOGOWNER.P_CARRIER_RESPONSE_INSERT’

There are 3 column headings that do not match the values populated below them.  The columns in question are:

X_LANE_XID
EQUIPMENT_GROUP_XID
P_BID_ROUND_XID

The values that automatically populate in these columns are actually the GID values instead of the XID values and is the source of the problem - when these are corrected, the upload is successful.

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