Hot Fix Release Notes
	Product	Selling and Fulfillment Foundation
	Date	Friday, February 05, 2010
List of Defects Addressed
Hot Fix ID	8.5-HF5
Defect ID	209340
Case ID	00128481
    Description 	Whenever a user modifies the yfsdatatypemap.xml file placed under “INSTALL_DIR/extensions/global/template/resource” directory, and on running the command deployer.cmd/deployer.sh -t resourcejar, the system does not incorporate the modified file.

Defect ID	208870 
Case ID	00126661
 Description	When a user calls the getFulfillmentOptionsForLines API, it does not honor the following scheduling rules:
•	Ship Complete
•	Line Ship Complete
•	Ship From Single Node
•	Line Ship from Single Node

Also, the findInventory API provides inconsistent results, if the “Line Ship from Single
Node” constraint is enabled in the scheduling rule. 

Defect ID	209743
Case ID	00131673
Description	When a user configures the Distribution Group with more than 500 nodes, and runs the Real-Time Availability Monitor agent, the alerts raised for the first 500 nodes contain the correct inventory picture, whereas the alerts raised for the remaining nodes contain an incorrect inventory picture. 
Defect ID	209964
Case ID	00134075
Description	The Selling and Fulfillment Foundation: Installation Guide must be updated with information that Selling and Fulfillment Foundation supports both Oracle 10g and 11g on either Single node or 2 Node RAC environment.
Solution: The requisite information has been included in Section 5.2.3, “Using an Oracle Database Server” and Section 6.5.3, “Using an Oracle Database Server (Windows)” in the Selling and Fulfillment Foundation: Installation Guide.

Hot Fix ID	8.5-HF4
Defect ID	199910,199913, 203200
Case ID	Internal
Description	A new entity API is required for the Inventory Alert table.

Solution: A new manageInventoryAlerts API has been included in the application. For more information about the manageInventoryAlerts API, refer to the corresponding section in the Sterling JavaDocs. 
In addition, the DISTRIBUTION_RULE_ID field and the IS_DEFAULT_DISTRIBUTION_GROUP field have been added to the YFS_INVENTORY_ALERTS table. The manageInventoryAlerts API will invoke the same event as the Real-Time Availability Monitor agent when a create or update operation is successful.
•	The manageInventoryAlerts API will update the IS_DEFAULT_DISTRIBUTION_GROUP field in the YFS_INVENTORY_ALERTS table to “N” instead of the Real-Time Availability Monitor updating this field to “Y”.
•	From the output of the event, the user will be able to differentiate between the event raised by the Real-Time Availability Monitor and the manageInventoryAlerts API by using the value of the “IsDefaultDistributionGroup” attribute. If the record was inserted by the manageInventoryAlert API, the value of the “IsDefaultDistributionGroup” attribute will be passed as “N”. A blank value or “Y” indicates that the record was updated or created by the Real-Time Availability Monitor.
•	DistributionRuleId is a mandatory field for all the operations that use the manageInventoryAlerts API.

Defect ID	199928
Case ID	Internal
Description	The order lines get scheduled instead of backordered, when a user creates an order in which the Requested Cancel Date (RCD) is less than the Requested Ship Date (RSD) at the order header level, and the RCD and RSD are not passed at the order line level.
Defect ID	207693
Case ID	00121788
Description	The Selling and Fulfillment Foundation: Customizing APIs Guide must be updated with information about extending an output XML files.
Solution: The requisite information has been added to the Section, “Extending an Output XML Template” in the Selling and Fulfillment Foundation: Customizing APIs Guide.

Defect ID	208218
Case ID	00126662
Description	The extended template for Rich Client Platform is not getting picked from the <INSTALL_DIR>/extensions/global/template/< pluginID >/< formID >/namespaces folder.
 
 Solution: The template extensions will be picked from the
INSTALL_DIR/extensions/global/template/<pluginID>/<formID>/namespaces/<template_name>.xml.

Defect ID	208315
Case ID	00116038
Description	When a user changes the header level attribute of a shipment having bundle items and if the shipment has been created for an order that has workorder, the changeShipment API throws "Either Work Order Key or Work Order Appointment Key incorrect" error message.
Defect ID	208424
Case ID	00127356
Description	In Business Center, when a user adds provided services for an item, in the “Service Search” pop-up window of the “Manage Provided Services” screen, the provided services that has the "Is Return Service" attribute checked are disabled.

Defect ID	208729
Case ID	00128581
Description	The dbverify script does not generate the SQL scripts when an extension XML is placed under the <INSTALL_DIR>/extensions/global/entities folder.

Defect ID	208903
Case ID	Internal
Description	In 18F WMS system test scenario, the outbound execution related queries on YFS_TASK table take a long time to execute.

Solution: Two new indexes have been added to the task table.

Hot Fix ID	8.5-HF3
Defect ID	203566
Case ID	Internal
Description	Attempts to use PLT_DB_COLONY result in an exception with the PLT058 error code.

Solution: A new column “STATUS” has been added to table PLT_DB_COLONY. If status of this colony is not null, any attempt to use that colony will result in exception with error code PLT058.
Defect ID	203716
Case ID	Internal
Description	The system responds slowly when a user attempts to view the inventory for a known receipt during an inbound process. This is because the database views for fetching the inventory picture are not tuned to handle Receipt as the input criteria.

Defect ID	205068
Case ID	Internal
Description	An error message "The statement is too long or too complex" error message is thrown by the system, when a user performs putaway of a preassigned task in a system or load test scenario.
Defect ID	206390
Case ID	Internal
Description	While running the 18F WMS system test scenario, most of the pick users fail with 952 errors.

Defect ID	206602
Case ID	Internal
Description	If the input XML of the manageWave API contains ComplexQuery as a child element, in such scenario the manageWave API layer throws a security exception error.
Defect ID	208054
Case ID	Internal
    Description	The security vulnerability issue with respect to online help needs to be resolved.

Hot Fix ID	8.5-HF2
Defect ID	162863
Case ID	Internal
Description	In the “Group Details” screen of the Applications Manager, the Warehouse Management Permission tab is displayed twice.
Defect ID	192457
Case ID	Internal
Description	In the “Organization Details” screen pertaining to a node in the Applications Manager, duplicate reason code values are getting populated in the “Inventory Adjustment Reason Codes” drop-down list.
Defect ID	192948
Case ID	Internal
Description	When an enterprise user manifests a container belonging to a node of a different colony, the application does not display the manifest number as the default in the “Add To Manifest” screen in the Sterling Warehouse Management System.
Defect ID	194010
Case ID	Internal
Description	An “Invalid Shipment” exception is thrown when starting a new receipt for a shipment that is in the Receipt Closed status.
Defect ID	196530
Case ID	Internal
Description	An OutOfMemoryError occurs when the createBatchForReferences API is invoked with a template in which the TaskReferences element is placed as a child to the Batch element.
Defect ID	197616
Case ID	Internal
Description	In the “Resource Planning Details” screen in the Sterling Warehouse Management System, the table column header displays "&nbsp;" for the first column. The table column header must be blank.
Defect ID	198100
Case ID	Internal
Description	When counting an existing LPN or a new LPN, a null pointer exception is thrown if a user skips the LPN scan in the “Count Criteria” screen in the Sterling Mobile Application, but scans the LPN in the “Inventory” screen.
Defect ID	199093
Case ID	Internal
Description	On clicking the “Index of all Tables and Views” link in the “Entity Relationship Diagram” homepage, a “Page Not Found” error message is displayed.
Defect ID	199191
Case ID	Internal
Description	The recovery process for the Catalog Search Index Build agent does not work. When an error occurs during the index build process, and the index trigger goes into error status, the Catalog Search Index Build agent cannot reprocess the search index trigger. 

Solution: Create a new search index trigger. 
Defect ID	199251
Case ID	Internal
Description	Context-sensitive help is not working for the following screens in the Sterling Warehouse Management System:
•	Shipment Profile List
•	Define Standard Capacity
•	Resource Planning
Defect ID	199267
Case ID	Internal
Description	Context-sensitive help is not working for the “Print” dialog box in the “Print SKU” Labels screen in the Sterling Warehouse Management System.
Defect ID	199399
Case ID	Internal
Description	Appendix B, "Menu-Level Customization of the Mobile Application" of the Selling and Fulfillment Foundation: Mobile Application User Guide is not available in the Local Documentation Library.
Defect ID	200586
Case ID	Internal
Description	In the “Customer List” panel of the “Customer Search” dialog box in Business Center, if the records span across multiple pages, and you navigate to the next page, the list of customers displayed in the subsequent pages is always the same as that displayed on the first page.
Defect ID	200854
Case ID	Internal
Description	In the “Add Items to Price List” screen in Business Center, if you click either “Add All Items in Search Results” or “Add All Items in Category”, only the items displayed in the current page are added to the price list. 
Defect ID	200892
Case ID	Internal
Description	In the “Index List” panel of the “Item Catalog Index List” screen in Business Center, search indexes generated for seller organizations other than the one that is being administered by you are also displayed.
Defect ID	201023
Case ID	Internal
Description	If you are using Microsoft Internet Explorer, and you click “Show Price” in the “Test Pricing” screen in Business Center, the Line Charges/Discount Breakup details are not displayed under the “Pricing Results” panel.
Defect ID	201046
Case ID	Internal
Description	While viewing the “Price List Summary” screen in Business Center, an exception may be displayed if the server does not respond in time.

Solution: Reload the Price List Summary screen.
Defect ID	201069
Case ID	Internal
Description	When building an EAR file with Web services on IBM WebSphere 6.1, the system throws a “NoClassDefFoundError”.
Defect ID	201079
Case ID	Internal
Description	The copyPricelist throws an “ORA-12899: value too large for column” error when trying to copy price lines, and the managePricelistHeader throws an “ORA-12899: value too large for column” error when adding price list lines for the items in the catalog. These  errors are caused only when the length of the primary key exceeds 24 characters.
Defect ID	201092
Case ID	Internal
Description	The “Wave Summary” screen in the Sterling Warehouse Management System blanks out during a high concurrency scenario in a warehouse because the query on the database times out.
Defect ID	201170
Case ID	Internal
Description	When calling the syncLoadedInventory API with InsertInventoryItem set to “Y”, the system may throw an error because the generated InventoryItemKey may exceed 24 characters.
Defect ID	201171
Case ID	Internal
Description	When assigning attributes and attribute values to a category, the system may throw an error for child categories and items if the generated primary keys exceed 24 characters. 
Defect ID	 201547
Case ID	Internal
Description	On releasing a wave, when some outbound tasks already exist from the same source for the same item, multiple inventory records get created with different inventory statuses, one of which has blank inventory status. This will show incorrect pend out quantity in the “Location Inventory” screen in the Sterling Warehouse Management System.
Defect ID	201574
Case ID	Internal
Description	When the adjustment reason code has location preference (adjustment sequence of locations) associated to it, and one of the locations in the sequence does not have the inventory, negative adjustment causes inventory picture mismatch between the Warehouse Management System and the Order Management System because the Order Management System-side inventory picture gets updated wrongly. Inventory audits are also wrong.
Defect ID	201648
Case ID	Internal
Description	An error message is displayed if you enter a description containing more than 100 characters in the following boxes in Business Center:
•	In the “Coupon Description” box in the “Coupon Summary” screen.
•	In the “Pricing Rule Description” box in the “Pricing Rule Summary” screen.
•	In the “Long Description” box in the “Primary Information” screen of an item.
•	In the “Long Description” box in the “Add Asset” dialog box.
•	In the “Long Description” box in the “Asset Detail” area of the “Assets” screen.
Defect ID	201651
Case ID	Internal
Description	After a service is created with an effective end date, you cannot use a calendar to select a new effective end date beyond the original effective end date. 
Defect ID	201745
Case ID	Internal
Description	A node user cannot view the alerts pertaining to any other node even if the user has access to those nodes.
Defect ID	202025
Case ID	Internal
Description	You cannot deploy two EAR files of Selling and Fulfillment Foundation, Release 8.5 on one application server.
Defect ID	202599
Case ID	Internal
Description	When running on DB2, the Person Info Purge agent may throw a SQL exception.
Defect ID	202796
Case ID	Internal
Description	When the new Data Access Policy is enabled in the Applications Manager, a node user cannot perform the following tasks:
•	Manual count using the Sterling Mobile Application.
•	Create count request across enterprises in the Sterling Warehouse Management System.
Defect ID	203118
Case ID	Internal
Description	When running on DB2, the Shipment Purge agent throws an SQL exception.
Defect ID	203145
Case ID	Internal
Description	When the getUserHierarchy API is called for a user with a team, the server goes into an infinite loop.
Defect ID	203270
Case ID	Internal
Description	Section 2.1, “Technical Stack Matrix” and Table 2-3, “Supported Database Tier” of the Selling and Fulfillment Foundation: Installation Guide state that Oracle is supported on 2-node and 3-node configurations. This is incorrect. Oracle is supported only on 2-node configurations.
Defect ID	204064
Case ID	Internal
Description	The system responds slowly when a user attempts to view serial-tracked inventory. This is because the getNodeInventory API fetches records for both serial-tracked inventory and non-serial-tracked inventory by firing a complex database query and cropping the results to display only the serial-tracked items.
Defect ID	204126
Case ID	Internal
Description	Table 2-9, “Supported Operating Systems” of the Selling and Fulfillment Foundation: Installation Guide lists Windows 2008 and Windows Vista as the supported operating systems for installing the Rich Client Platform (RCP). This is incorrect. Windows XP and Windows Vista are the supported operating systems.
Defect ID	204386
Case ID	Internal
Description	When the receiving task is performed using the Sterling Mobile Application, and a user receives a case, the system throws an "Invalid XML Returned from Host" error message because the Sterling Mobile Application sends a malformed request to the server.
Defect ID	204902
Case ID	Internal
Description	The Sterling Warehouse Management System: Configuration Guide must be updated with information about the tasks that an Enterprise user cannot perform.
Solution: The requisite information has been added to Section 15.3, "Configuring Users" of the Sterling Warehouse Management System: Configuration Guide.
Defect ID	205066
Case ID	Internal
Description	When an enterprise consumes inventory from vendors, on releasing a wave containing shipments belonging to the enterprise, the same LPN is suggested for tasks of type Replenishment or Outbound Pick.
Defect ID	205087
Case ID	Internal
Description	When the new Data Access Policy is not enabled, in the Sterling Warehouse Management System, a node user is able to select another node and view the transactions in it.
Hot Fix ID	8.5-HF1
Defect ID	203626
Case ID	Internal
Description	The Web UI Framework’s backend must be enhanced with the capability to support requests from an iPhone client.
Solution: The Web UI Framework's back-end logic has been enhanced to handle requests from an iPhone client. To enable requests from an iPhone client, utility methods such as getPlistFromXML and getXMLFromPlist have been provided in the "SCPlistXmlUtils" class for converting property list (Plist) files to XML and XML to Plist. 
For Apache Struts action, the SCUIPlistXAPIMashupAction class and the SCUIPlistXAPIAggregatorMashupAction class are provided to invoke XAPIs for handling Plist input from iPhone clients.