[vsevs]

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.

[cunninghamg]

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

[vsevs]

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.

[cunninghamg]

venkat
the obvious mistake is the quotes around $gid.

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

Gary

[vsevs]

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.

[cunninghamg]

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

[vsevs]

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