My Oracle Support Banner

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

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.2.1 and later
Information in this document applies to any platform.


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.

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 =

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 =

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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