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

Last updated on JULY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.