Using OMD- Edit Shipment Agent Action Is Removing Capacity Usage Records (Doc ID 1353570.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.1 and later   [Release: 6.2 and later ]
Information in this document applies to any platform.

Symptoms


Even thought the recalculateServiceTime is set to false on the Order Mod - Edit Shipment Agent, When updating an order, the capacity usage record is sometimes removed from the shipment.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM.
2. Search for Order.
3. Select and go to Actions --> Operational Planning --> Create Buy Shipment --> Bulk Plan Buy.
4. Click Ok.
5. Click Refresh and note 1 shipment was built to MACK_2009.
6. Note Shipment 01433 was built.
7. Run the query in sql backdoor:

Query: select * from Shipment_S_Equipment_Join where shipment_gid =
'DOMAIN.01433'

8. Note capacity usage gid is SH.20110802-0067.
9. Go to Business Process Automation --> Integration --> Integration Manager.
10. Upload original xml.
11. Rerun the query:

Query: select * from Shipment_S_Equipment_Join where shipment_gid =
'DOMAIN.01433'

12. The Capacity usage gid is now null. In the logs this is seen:

Sql update shipment_s_equipment_join set capacity_usage_gid=?,
pickup_stop_num=?, dropoff_stop_num=?, domain_name=?, s_equipment_index=?
where shipment_gid=? and s_equipment_gid=?; http://null, 1, null, SH, null,
DOMAIN.01434, SH.80821164244513 ORMD - 2

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