getWorkOrderList API not querying on YFS_ORDER_HEADER_H
Requirement is to use getWorkOrderList API to fetch only those work Orders for
which the corresponding Sales Order in YFS_ORDER_HEADER_H.
Sample input XML for getWorkOrderList:
<WorkOrder Status="<some status>">
As per the documentation, passing WorkOrder/Order/@isHistory as Y the
api should read records from the history table.The application is still pulling records from YFS_ORDER_HEADER table.
getWorkOrderList api is not designed to retrieve data from YFS_ORDER_HEADER_H.
Diagnosing the problem
Output of the api will have orders from non_history (YFS_ORDER_HEADER) too.
Resolving the problem
getWorkOrderList api is not designed to retrieve the data from YFS_ORDER_HEADER_H.
isHistory attribute in input xml is incorrect. Product's javadoc will be fixed to remove this attribute (In higher release versions of Sterling application)
|Commerce||Sterling Selling and Fulfillment Suite||AIX, HP-UX, Linux, Solaris, Windows||9.1, 9.0|
More support for:
Sterling Order Management
Software version: 9.1, 9.2, 9.2.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1642357
Modified date: 28 June 2013