Removing Shipment Ship Unit via integration

[jradey]

I tried to create an integration which will delete a Shipment Ship Unit. I'm using an ActualShipment with the Transaction Code of RC and a ManagedChild of ShipmentStop and ShipUnit. The integration processes successfully. The ShipUnit is no longer associated with the Shipment (entries in shipment_stop_d are deleted), but the entry in the s_ship_unit and s_ship_unit_line for the ship unit is still in the table. This prevents the associated Release Line and Release Ship Unit from being deleted.

Is there anyway to get the entry in the s_ship_unit and s_ship_unit_line tables to be deleted via integration?

[LourensGlog]

Re: Removing Shipment Ship Unit via integration

What do you want to achieve? Do you want to remove this ship unit from the shipment, so the order release will become partially planned and you can plan this ship unit to another shipment? Or do you want this ship unit to be removed from the order release and from the related shipment as well.

[jradey]

Re: Removing Shipment Ship Unit via integration

The goal is to remove the ship unit from the shipment and the release.

[LourensGlog]

Re: Removing Shipment Ship Unit via integration

Then you'd better remove it at the source: the release.
Then propagate the changes with one of the standard agent actions.

[jradey]

Re: Removing Shipment Ship Unit via integration

Thanks. Wanted to avoid that. Seems OTM should delete these entries rather than leaving orphaned rows in the tables.

[james_foran]

Re: Removing Shipment Ship Unit via integration

There is another way to do this.

First, issue the DR,

After this, send through a D transaction, this will delete the S_SHIP_UNIT...

<GLogXMLElement>
<ActualShipment>
<Shipment>
<ShipmentHeader>
<ShipmentGid>
<Gid>
<DomainName>DOMAIN</DomainName>
<Xid>123</Xid>
</Gid>
</ShipmentGid>
<TransactionCode>U</TransactionCode>
<IntCommand>
<IntCommandName>DetermineShipUnitDropoff</IntCommandName>
</IntCommand>
<IntCommand>
<IntCommandName>PropagateShipUnitChanges</IntCommandName>
</IntCommand>
</ShipmentHeader>
<ShipUnit>
<ShipUnitGid>
<Gid>
<DomainName>DOMAIN</DomainName>
<Xid>345</Xid>
</Gid>
</ShipUnitGid>
<TransactionCode>DR</TransactionCode>
</ShipUnit>
</Shipment>
</ActualShipment>
</GLogXMLElement>
<GLogXMLElement>
<ActualShipment>
<Shipment>
<ShipmentHeader>
<ShipmentGid>
<Gid>
<DomainName>DOMAIN</DomainName>
<Xid>123</Xid>
</Gid>
</ShipmentGid>
<TransactionCode>U</TransactionCode>
<IntCommand>
<IntCommandName>DetermineShipUnitDropoff</IntCommandName>
</IntCommand>
<IntCommand>
<IntCommandName>PropagateShipUnitChanges</IntCommandName>
</IntCommand>
</ShipmentHeader>
<ShipUnit>
<ShipUnitGid>
<Gid>
<DomainName>DOMAIN</DomainName>
<Xid>345</Xid>
</Gid>
</ShipUnitGid>
<TransactionCode>D</TransactionCode>
</ShipUnit>
</Shipment>
</ActualShipment>
</GLogXMLElement>
</TransmissionBody>
</Transmission>

Hope this helps,

Regards,

[josephliang]

Re: Removing Shipment Ship Unit via integration

Another option is to use the following command to remove orphaned ship units.

<IntCommand>
 <IntCommandName>DeleteOrphanedShipUnits</IntCommandName>
</IntCommand>

Startig from 5.5, OTM has enhanced some integration functions to handle Shipment Actuals. You may refer to Integration Guide - Actual Shipments scetion.

[jradey]

Re: Removing Shipment Ship Unit via integration

Thanks

Adding the DeleteOrphanedShipUnits command work perfectly.