Question & Answer
Question
How do you avoid or suppress the queries to YFS_CALENDAR* tables at the time of createOrder transaction in IBM Sterling Order Management?
Cause
This is impacting createOrder API performance.
Answer
Product fires queries to YFS_CALENDAR* tables, in order to calculate the estimated shipping/delivery dates. These dates are calculated as per calendar configuration of shipnode. When input of createOrder API contains the shipnode for orderlines and Calendar is configured for that shipnode, there are multiple queries which are fired for YFS_CALENDAR* tables within createOrder transaction/API.
If you want to reduce the queries to YFS_CALENDAR* tables at the time of createOrder transaction/API call, then you can pass the ReqDeliveryDate and ReqShipDate on order line element. This will reduce the number of queries significantly as the calculation of estimated shipping/delivery dates will be performed using the ReqDeliveryDate and ReqShipDate on order line element.
Was this topic helpful?
Document Information
Modified date:
10 May 2022
UID
swg21983770