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.

Symptoms

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.

ERROR
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

STEPS
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

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



.

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