oe_order_pub.process_order API slow when update schedule_ship_date
Hello
I update some information with the API oe_order_pub.process_order and I am experimenting serious issues with the performance.
The information updated is:
- customer_line_number
- cust_po_number
- schedule_ship_date
- attribute1
- attribute6
- attribute7
I've made many tests updating the information just one data at a time and I notice the problem is when the schedule_ship_date is modified.
When i change the schedule_ship_date the api is executed very slow, about 5-10 second each time, due the requirements of the system i need to execute the api once for every line that i need to update because the system do some validations before, this is a problem because some times the system updates about 80-90 lines at a time and the user have to wait about 10 minutes.