Order Release Not Creating Through Xml When Customer ID Already Exists. (Doc ID 1111093.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.0 to 6.0.6 - Release: 6 to 6
Information in this document applies to any platform.

Symptoms


A Customer ID is created that is assigned an Order Template with an Accessorial Code defined.
When an Order is created that references this Customer via the ORDEROWNER Involved Party, the accessorial is being attempted to be assigned to the new order prior to the order existing. Hence the following error occurs.

ERROR
-----------------------
Cannot update the ORDER_RELEASE_ACCESSORIAL record. ORDER_RELEASE_GID must reference a valid ORDER_RELEASE record.
java.sql.SQLException: ORA-02291: integrity constraint (GLOGOWNER.FK_ORA_ORGID) violated - parent key not found



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

Sample Setups:

Corporation ID:corp_xxx

Location ID:corp_xxx (corporation=corp_xxx, Role=CUSTOMER and contact ID=corp_xxx)

Location ID:loc_aaa (corporation=corp_xxx, Role=ship from/to)

customer ID:corp_xxx, with contact ID=corp_xxx, order template with one accessorial code
-------------------------------------------
Create new order release via xml. The xml has 2 glog elements:

GLOG element1:location xml - it creates corp_xxx location (insert ignore mode)

GLOG element2:order release xml - it creates order release with following details:
source location ID:slcdallas
dest loctaion ID:loc_aaa
invloved party: (corp_xxx:by contact:ORDEROWNER)

-----------------------
When the above xml is processed, system fails to create order release giving this error:

Cannot update the ORDER_RELEASE_ACCESSORIAL record. [ORDER_RELEASE_GID] must reference a valid ORDER_RELEASE record.



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