In Procurement Unable to Upload Carrier Bid Response Template with 'ORA-02291: integrity constraint (GLOGOWNER.FK_PBD_EQUIPMENT_GROUP_GID) violated' Error. (Doc ID 759271.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Sourcing - Version: 5.5.04 to 5.5.04.06 - Release: 5.5 to 5.5

Symptoms

-- Problem Statement:
On 5.5.04 in Sourcing when uploading the Carrier Response Template the following error is encountered:

ERROR
<?xml version="1.0" encoding="UTF-8" ?>
- <CSVUtilServletHelper>
- <CSVUtil>
<Command>i</Command>
<DataDir>/otm55/temp/upload/</DataDir>
<DataFileName>Carrier Response Temaplate.csv</DataFileName>
<ExcludePublic>true</ExcludePublic>
- <ProcessCSV>
<xvalidate>true</xvalidate>
<DatabaseGlobalName>TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM</DatabaseGlobalName>
<TableName>P_CARRIER_RESPONSE</TableName>

<ColumnList>TRANSACTION_CODE,X_LANE_XID,TRANSPORT_MODE_XID,EQUIPMENT_GROUP_XID,SERVPROV_XID,TR
ANSIT_TIME,VAR_COST,MIN_PCT_LOADS_REQUESTED,MAX_PCT_LOADS_REQUESTED,P_BID_PACKAGE_XID,P_BID_ROUND_XI
D,DOMAIN_NAME,BID_SEQUENCE_NUM,CURRENCY_XID,NUM_VAR_COST_UNITS,UOM_VAR_COST,LANE_ATTRIBUTES,MIN_COST
,SOURCE_CITY,SOURCE_PROVINCE,SOURCE_POSTAL,SOURCE_DESC,DEST_CITY,DEST_PROVINCE,DEST_POSTAL,DEST_DESC
</ColumnList>
<sqlString>insert into P_CARRIER_RESPONSE (
TRANSACTION_CODE,X_LANE_XID,TRANSPORT_MODE_XID,EQUIPMENT_GROUP_XID,SERVPROV_XID,TRANSIT_TIME,VAR_COS
T,MIN_PCT_LOADS_REQUESTED,MAX_PCT_LOADS_REQUESTED,P_BID_PACKAGE_XID,P_BID_ROUND_XID,DOMAIN_NAME,BID_
SEQUENCE_NUM,CURRENCY_XID,NUM_VAR_COST_UNITS,UOM_VAR_COST,LANE_ATTRIBUTES,MIN_COST,SOURCE_CITY,SOURC
E_PROVINCE,SOURCE_POSTAL,SOURCE_DESC,DEST_CITY,DEST_PROVINCE,DEST_POSTAL,DEST_DESC) values
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) /* SERVPROV */</sqlString>
- <Error>
<TableName>P_CARRIER_RESPONSE</TableName>
<Exception>ORA-02291: integrity constraint (GLOGOWNER.FK_PBD_EQUIPMENT_GROUP_GID) violated
- parent key not found ORA-06512: at "GLOGOWNER.TRANSFORM", line 1874 ORA-06512: at
"GLOGOWNER.P_CARRIER_RESPONSE_INSERT", line 64 ORA-04088: error during execution of trigger
'GLOGOWNER.P_CARRIER_RESPONSE_INSERT'</Exception>
<Data>I,626,TL,53FT DRY
VAN,TEST_LSP,0,1,50,90,null,PROCURE_SHIPMENT-1,TEST,1,USD,1,MI,NONE,0,,,,"((/TEST_LOC_A(TEST_LOC_A,C
HN,null)))",,,,"((/TEST_LOC_B(TEST_LOC_B,NY,null)))"</Data>
</Error>
<ProcessCount>0</ProcessCount>
<ErrorCount>1</ErrorCount>
<SkipCount>0</SkipCount>
</ProcessCSV>
- <execJavaPostProc>

<javaPostProc>glog.procurement.web.bid.CarrierResponseTemplateUploadPostProc</javaPostProc&
gt;
<nBidInsert>null</nBidInsert>
<nBidUpdate>null</nBidUpdate>
<nBidDelete>null</nBidDelete>
</execJavaPostProc>
</CSVUtil>
</CSVUtilServletHelper>

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.Create Shipment sets.
2.Create Lane criteria
3.Build and view lane summary
4.Create bid round
5.Create Project
6.Send Bid invitation to carrier with the carrier response template.
7.Login as carrier(carrier login in OTM), upload carrier response template.

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