we are looking to see if there is an ability to add a parameter into a Database task.
we have a process that looks at the order type and releases orders from planned but unfortunately there is only the option to use ORDER_CREATED_TIME_OFFSET.
I’m hoping to be able to reference Wanted Delivery date / time instead.
Is this customisable and if so, where could one reference the above?
As always, any pointers massively appreciated.
Best answer by Marcel.Ausan
@Clotted01 I believe you refer to the below Database Task:
If you need this DB task to run based on Wanted Delivery Date instead of Order_Created_Time_Offset, you would need to go for a modification. You would need to have a new PL/SQL function inside the Release_Customer_Order_Api and there you should implement the logic based on Wanted Delivery Date.
This is not something that could be just a configuration.
@Clotted01 I believe you refer to the below Database Task:
If you need this DB task to run based on Wanted Delivery Date instead of Order_Created_Time_Offset, you would need to go for a modification. You would need to have a new PL/SQL function inside the Release_Customer_Order_Api and there you should implement the logic based on Wanted Delivery Date.
This is not something that could be just a configuration.