IBM Support

Suppress queries to YFS_CALENDAR* tables at the time of createOrder transaction

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.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Performance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.2;9.2.1;9.3;9.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
10 May 2022

UID

swg21983770

Page Feedback