My Oracle Support Banner

Release Xml, Transactioncode RC Is Not Deleting Ship_unit_line_refnum (Doc ID 387740.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.0
This problem can occur on any platform.


When attempting to upload an Order Release message with RC transaction code, that is supposed to delete the Ship Unit and Ship Unit Line, the following error occurs.

Cannot delete the SHIP_UNIT_LINE record. A SHIP_UNIT_LINE_REFNUM record references it in its [SHIP_UNIT_GID, SHIP_UNIT_LINE_NO] column

The issue can be reproduced at will with the following steps:
1.Create an Order Release with more than one ship unit and ship unit line and reference number on each of the ship unit lines
2. Upload an Order Release XML with Transaction code as RC and with just 1 ship unit and ship unit line
3. The integration message errors out with the message, unable to delete the reference number record

The issue has the following business impact:
Due to this issue, users cannot upload Release XML with RC transaction code



To view full details, 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 a vibrant support community of peers and Oracle experts.