My Oracle Support Banner

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 AUGUST 14, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.