Announcement

Collapse
No announcement yet.

Direct SQL Update to clear Late Delivery Date

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

  • Direct SQL Update to clear Late Delivery Date

    Hi,
    We have a situation. Our customer doesn't want to work with two Pick up and delivery dates. So we planned to have only Early Pickup and delivery Dates.

    But we have integrated with EBS. The Purchase Order in EBS populated both early delivery date and late delivery date. But we already hide the late delivery date. But there is a value in it and it causing problems in shipment creation.

    Is there anyway, we can clear the late delivery date when the order base is created and if the late delivery date is populated?

    Many Thanks in Advance.

    Thanks,
    Venkat.

  • #2
    Re: Direct SQL Update to clear Late Delivery Date

    Venkat

    Well you can't remove the fields obviously.
    Why not populate them with the same value as the early_ dates?
    You could get this to happen in the integration layer or by adding an Insert Trigger.

    Gary
    Regards
    Gary Cunningham
    www.cbmc.co.uk
    www.mavenwire.com

    Comment


    • #3
      Re: Direct SQL Update to clear Late Delivery Date

      Hi Gary,
      Actually it is coming from Oracle EBS pre package BPEL integration. We don't want to change anything in that. I could hide those two fields (Late Pickup and Late Delievery) in our manager Layout.
      But the value for Late Delivery date is populated by Oracle EBS Purchase order promise date.

      So when we make changes to early pickup or early delivery which makes late delivery date earlier than early pickup and delivery date some times

      This is why i'm looking for a direct sql update to clear late_delivery_date in ob_line.
      I tried with two automation agents. Both of them are not working. Can you please help me in correcting them. one is at order base creation event and another one is at order base line creation event.

      1. Order Base - Created
      UPDATE ob_line
      SET late_delivery_date = NULL
      WHERE order_base_gid = '$gid'

      2. Order Base Line - Created
      UPDATE ob_line
      SET late_delivery_date = NULL
      WHERE ob_line_gid = '$gid'

      Thanks,
      venkat.

      Comment


      • #4
        Re: Direct SQL Update to clear Late Delivery Date

        venkat
        the obvious mistake is the quotes around $gid.

        It should be:
        Where order_base_gid=$gid
        and
        Where ob_line_gid=$gid

        Gary
        Regards
        Gary Cunningham
        www.cbmc.co.uk
        www.mavenwire.com

        Comment


        • #5
          Re: Direct SQL Update to clear Late Delivery Date

          Hi Gary,
          Apologies for bothering you. It is still not working. Can you please check the screenshot attached and correct me if i'm wrong anywhere.

          Thanks,
          Venkat.
          Attached Files

          Comment


          • #6
            Re: Direct SQL Update to clear Late Delivery Date

            Venkat
            In the Agent Header - Agent Events ...
            Modify your event and add the Restrictions USER, INTEGRATION and INTERNAL (by shift clicking).
            The Restrictions are available bu clicking the i in a circle next to the box in edit mode.

            Gary
            Regards
            Gary Cunningham
            www.cbmc.co.uk
            www.mavenwire.com

            Comment


            • #7
              Re: Direct SQL Update to clear Late Delivery Date

              Hi Gary,
              Thank you It is working. Thanks a ton.

              Comment

              Working...
              X