IBM Support

getWorkOrderList API not querying on YFS_ORDER_HEADER_H

Technote (troubleshooting)


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>">
<Order isHistory="Y"/>

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)

Cross reference information
Segment Product Component Platform Version Edition
Commerce Sterling Selling and Fulfillment Suite AIX, HP-UX, Linux, Solaris, Windows 9.1, 9.0

Document information

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

Translate this page: