Announcement

Collapse
No announcement yet.

Removing Shipment Ship Unit via integration

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Removing Shipment Ship Unit via integration

    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?

  • #2
    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.

    Comment


    • #3
      Re: Removing Shipment Ship Unit via integration

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

      Comment


      • #4
        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.

        Comment


        • #5
          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.

          Comment


          • #6
            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,
            James Foran
            Toll Global Information Services
            http://www.tollgroup.com

            Comment


            • #7
              Re: Removing Shipment Ship Unit via integration

              Another option is to use the following command to remove orphaned ship units.
              Code:
              <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.
              --
              Joseph Liang
              MavenWire APAC
              http://www.mavenwire.com/

              Comment


              • #8
                Re: Removing Shipment Ship Unit via integration

                Thanks

                Adding the DeleteOrphanedShipUnits command work perfectly.

                Comment

                Working...
                X