Unable To Add The Accessorial Code In Quote While Using The Spot Rate Option. The Error is: java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_QCSC_ACCESSORIAL_CODE_GID) violated - parent key not found (Doc ID 1595237.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.3.1 [Release 6.3]
Information in this document applies to any platform.

Symptoms

On OTM version 6.3.1 when attempting to add an Accessorial to a Quote an error is encountered.

ERROR
-----------------------
java.sql.BatchUpdateException: ORA-02291 integrity constraint (GLOGOWNER.FK_QCSC_ACCESSORIAL_CODE_GID) violated - parent key not found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1- Logged onto an internal OTM 6.3.1 system.

2 - Navigated to: Brokerage and Forwarding > Quote.

3 - Clicked NEW.

4 - Entered the following:

a - Identification tab:
ID
Issue date
Expiration date
Bill to Party
Shipper
Consignee
Quote requestor

b - Quote request tab:
Orgin Location ID
Destination Location ID
Shipping Information
Transport Mode

c - In the Cost Options tab click 'Manually Add Cost Options'.

d - Under the Sell Shipping details Section, Click on the Edit Button.

e - Click on the 'Create Spot Rate Button' (top right).

f - Populated the following:
Service Provider ID
Spot Rate Offering
Contact Name
Clicked OK.

g - Enter the following:
Source Location
Destination Location ID
Amount: 1000.00 per SHIP UNIT
Accessorial Code
Accessorial Cost

h - Click Finished.

i - Click on the 'Rate' button (top right).

j - The base cost and Accessorial costs are shown.

k - Click on the Save button to save the Rates.

l - Click on the Finished button.

m - The error is shown.


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