Skip to main content
Solved

Database task 'Release customer order' by Wanted date

  • July 31, 2024
  • 2 replies
  • 64 views

Forum|alt.badge.img+5

Hi all,

 

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.

2 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1306 replies
  • Answer
  • July 31, 2024

@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.


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 5 replies
  • July 31, 2024

Hi Marcel, figured as much but it was worth asking just in case.

 

appreciate the help.