WebSphere Commerce Version 7.0.0.1 or later

APARs fixed in WebSphere Commerce fix packs

Each WebSphere Commerce fix pack contains fixes for multiple APARs to correct issues with the WebSphere Commerce product.

The following tables list the fixes that are included in the latest WebSphere Commerce fix pack. For the latest fix pack information, see Fix packs for WebSphere Commerce.
Note: When the fix pack is installed, it uninstalls any previously installed interim fixes. If you installed interim fixes that are not listed in these tables, you must obtain versions that can be applied to your new fix pack level and reinstall them. First search IBM Fix Central to see whether an interim fix is available for the particular APAR on your fix pack level. If not, then contact IBM Support to review your APAR requirements and obtain interim fixes that you require.
The list of APAR fixes are separated into the following sections:

For recommended fixes, see Recommended fixes and settings for WebSphere Commerce Version 7.

WebSphere Commerce fix packs

The following tables list the interim fixes that are contained in each WebSphere Commerce fix pack. WebSphere Commerce fix packs are cumulative. In these tables, fixes are listed in the table for the fix pack in which they were first included.

WebSphere Commerce Version 7.0.0.9

Fix Pack 9 fixes

The following fixes are included in Fix Pack 9.
Note: The fixes that are included in Fix Pack 9 are displayed in a single table that sorts the fixes by category.
Category APAR Description
WebSphere Commerce Version 7.0.0.9Analytics
WebSphere Commerce Version 7.0.0.9Authoring and Staging JR49347 Fixes an issue where Quick Publish fails with a ResourceException when publishing a delete statement.
JR49653 Improves caching of the meta data for tables to avoid Quick Publish timeouts when publishing a large amount of data.
JR51279 Fixes an SQL error that occurs during approval processing of foreign key violations.
JR51608

Security fix:

Enables specification of a file on the command line that stores encrypted passwords that are required by the stagingprop and stagingcopy utilities.
JR50514 Fixes an issue where an SQL file generated by the StagingCopy utility might not invoke successfully (with the sqlplus command) if the WebSphere Commerce database it was generated against is an Oracle database.
JR49715 Improves Oracle JDBC-batch error handling so that StagingProp utility can better identify the failing records in an executed JDBC-batch.
WebSphere Commerce Version 7.0.0.9Catalog, Assets, Contracts, and Pricing JR49782 Enhances Create, Update, Delete, and Read services to manage the data for the columns FIELD1, FIELD2, FIELD3, FIELD4 of the ATCHTGT table.
JR51556 Resolves an issue where the Management Center Catalogs tool fails to display any merchandising associations which contain a product that is marked for delete.
JR50546 Resolves an error that occurs in the Management Center when attempting to modify catalog entry attributes with assigned values that are shared between two catalog entries.
JR51679 Resolves contract price calculation errors that occurs due to installing JR51142.
JR51306 Fixes an issue where an error occurs when checkEntitlement is enabled and you attempt to use Store Preview in a B2B store model.
JR51142 Improves performance of contract entitled price calculation.
JR49762 Reduces memory footprint of Price Rule object cache and implements the Sizeable interface.
JR49725 Updates ResolveSkuNewCmdImpl to allow a PackageBean with no defining attributes to be added to the cart.
JR51278 Addresses an issue where you cannot use Data Load to load an XML file that contains both catalog entry and attributes.
JR51428 Fixes an issue where updating an attribute value might change the store to which the value belongs.
JR51427 Resolves an IndexOutOfBoundsException that occurs when changing sequence of defining attributes.
JR51140 Updates the Management Center to allow you to change FIELD1, FIELD2 and FIELD3 of the FACET table.
JR50548 Updated the CatalogComponentHelper.isAttributeValueUsedByOtherCatalogEntries() method in the IBM Knowledge Center documentation.
JR50913 Fixes an issue where the Change History records for an attribute value is not correctly recorded when assigning catalog entry attributes.
JR50613 Fixes an issue in Management Center that prevented UTF-8 predefined Attribute Values longer than 255 bytes could not be saved.
JR49826 Improves the coordinator price rule implementation to avoid unnecessary queries to the database.
JR50348 Improved performance of the SaveAccountCmdImpl command to limit the number of invalidations.
JR50509 Fixes an issue where the Data Load utility and catalog upload may incorrectly delete existing assigned attribute attrval_id=0 records.
JR50628 Updates FetchContractByIdentifierCmdImpl.fetchContracts() method to use an equivalent SQL that allows for caching.
WebSphere Commerce Version 7.0.0.9Data Load and other loading tools JR49546 Increases performance of the Data Load utility when loading attribute values into workspaces.
JR49228 Improved Data Loady utility to support Swedish locale sv_SE.
JR49551 Improves exception handling to avoid duplicate key exceptions when using the Data Load utility to generate URL keywords for categories. Data Load does not fail anymore. The duplicate key will not be entered.
JR51280 Addresses catalog upload error DSRA9110E : Statement is closed.
JR51605

Security fix:

Enables specification of a file on the command line that stores encrypted passwords that are required by the dbclean utility.
JR50748 Resolves issues that occur when loading attribute dictionary attribute values in multiple languages using Data Load.
JR51034 Updates Data Load SEO mediators to not create an SEOURL entry when the corresponding SEOURLKEYWORD entry cannot be created.
JR51265 Enhances the Data Load utility to generate an alternate URL keyword for a category when the utility encounters a duplicate category name.
JR50043 Introduces changes to the way Data Load, Catalog Upload, and Management Center handle attribute dictionary assigned attribute values to allow for sharing of attribute data.
JR49916 Fixes the output file when performing file difference preprocessing using Data Load.
JR49710 Fixes an issue where double-byte characters added to the database using the Data Load utility show up as question marks (????).
JR49819 Corrects the XML handler to resume at the proper spot in the XML file when an error is encountered while using the Data Load utility.
JR50195 Catalog entries with SEO properties in multiple languages can now be loaded using the Data Load utility.
JR50437 Fixes an issue where incorrect parent-child relationship might be added for a catalog entry, which causes the catalog entry to not appear in the correct location on the storefront.
JR50455 Disables the auto-commit option in the Data Load utility so that rollback can be performed when an error occurs during catalog upload.
JR50552 Fixes an issue on Oracle databases where the ID resolver cache does not handle the decimal type properly.
WebSphere Commerce Version 7.0.0.9Installation, Configuration, Deployment and Migration JR49296 Fixes an issue where WCBD Delta Deployment fails to copy delta changes for static content when whitespaces are present in the file names.
JR49747 Fixes an issue where the UpdateDB task fails during a fixpack installation if DBAPwd or dbaName is not populated in the instance.xml file.
JR51668 Fixes an issue where WASProfileStartingPort in the createInstance.properties is changed back to default value after feature enablement.
JR51416 Fixes an issue where the JNDI name is set to NULL when transport threads are updated from Configuration Manager.
JR50832 Fixes an error where Workspace approval with approveUniqueViolationAction enabled causes an Index out of bounds exception.
JR49792 For iSeries environments, updates the UpdateDB script to ensure that the script is retrieving the instance related files from the UserData directory instead of the ProdData directory.
JR50547 Updated WebSphere Commerce API documentation in the IBM Knowledge Center for various methods.
WebSphere Commerce Version 7.0.0.9Marketing and Promotions JR49825 Corrected e-Marketing Spot dynamic caching code so that the JSP fragment is properly consumed when its parent page is cached
JR48394 Fixes an issue that occurs after a promotion is approved and in the base schema. De-activating, re-activating, and re-approving the promotion might cause entries from the PX_CDPOOL table to be removed.
JR49905 Fixes an issue where Quick Publish does not publish new promotion codes and does not update the live database after approving the task group.
JR51650 Fixes an issue where eMarketing Spots REST cache entries are not being invalidated.
JR49103 Corrects an issue where the LASTUPDATEBY and LASTUPDATE fields within PX_PROMOTION are not updated when elements of PX_ELEMENTNVP are modified.
JR49283 Resolves BatchUpdateException errors that appear when marketing activities that track user behavior are run, leading to incorrect results from web and dialog activities.
JR50507 Adds new capability to enable the main promotion list view to be limited to only promotions that are not in folders.
JR51458 Adds cache invalidation to FinalizeDiscountCalculationUsagenoPromoargCmdImpl to avoid storing old coupon states in the cache.
JR51579 Changes calculation logic of orders to ensure that the discount distributed to each order item has a more precise calculation and avoids unnecessary rounding.
JR51059 Adds a new public method PromotionContainer.processPostPublishData() to broadcast a scheduled refresh-local-registry job to all other WebSphere Commerce instances.
JR51272 FIxes an issue where an unexpected promotion discount is given when multiple promotions are used.
JR51141 Fixes an issue where Marketing statistics are not updated correctly.
JR50130 Extends promotion logic to allow for the pairing of the most expensive items with the least expensive items in the cart that qualifies for the promotion, and applies the promotion on the least expensive item.
JR50098 Fixes an issue where promotions are not being applied consistently when used with custom filters.
JR50191 Fixes an error where a null pointer exception might occur when transferring an order to an external OMS system.
JR50158 Fixes an issue where category-level promotions are applied even though the targeted categories have been marked for delete.
JR50684 When an e-Marketing Spot is renamed, entries in the marketing cache need to be removed for both the old e-Marketing Spot name and the new e-Marketing Spot name.
JR50747 Added support of invalidation policies in the cachespec.xml file to invalidate base cache JSP pages when a new e-Marketing Spot is created.
JR50727 Fixes an error message when customers try using coupons that have not reached their activation date.
WebSphere Commerce Version 7.0.0.9Member and Session Management JR50350 Changed behavior so that users can continue to shop as guest users after their session has expired and not redirected from the current page.
JR50689 Addresses an issue when punch-out is configured in an environment with more than one server. The following error might occur when trying to retrieve the SupplierCookie: _ERR_PROCUREMENT_INVALID_SUPPLIER_COOKIE
JR51602 Prevents a cookie error from occuring when using an AES merchant key.
JR49545 Corrects an issue where guest sessions are not being properly authenticated through the Process Person service.
JR50763 Improves performance of organization search in the Organization Administration Console.
WebSphere Commerce Version 7.0.0.9Messaging and Integration (including Sterling integration) JR49911 Performs validation on predefined dynamic kits when added to the cart (Sterling configurator integration).
JR49346 Enhances dynamic kits to allow for duplicate SKUs to be configured within dynamic kits.
JR49362 Corrects an issue where all products are displayed with Sterling Configurator when launched from Management Center, irrespective of entitlement.
WebSphere Commerce Version 7.0.0.9Orders, Payments, and Inventory JR49513 Fixes an issue where the order items in a re-order are not displayed in the same sequence as the original order.
JR49612 Fixes an issue where billing addresses are shown in the Shipping Address dropdown menu on the Shipping and Billing page.
JR50104 Extends support of ATPInventoryPerformance lockitemSpecEnabled to other database types besides Oracle.
JR49247 Fixes an issue where calling ProductInventoryUpdateCmdImpl under heavy shopping load can cause optimistic update failure exceptions.
JR50683

Security fix:

Fixes an issue where after customization, PIEditCmd does not remove existing sensitive payment data and personal information.
JR51610 Modifies the GetInventoryAvailability BOD service to respect the noCheck optioin in the INVENTORY table.
JR51413 Ensures that when PARMTYPE is set to 1 in CALADJUST table, a fixed shipping adjustment is provided.
JR51133 Fixes an error where the Order Summary page displays an incorrect order status when the piAmount is less then the order total.
JR51048 Fixes an issue where you cannot process refunds on orders where customers selet partial shipment method.
JR51007 Fixes an issue where a user cannot view a shared a requisition list.
JR50740 Fixes an issue where payments cannot be processed during the change in time due to daylight savings.
JR50712 Adds an NPE check in com.ibm.commerce.contract.util.ContractCmdUtil.class.
JR49881

Security fix:

Removes a potential vulnerability in the Orders web services.
JR49748 Extends the PaymentEventListenerImpl for customizing payments.
JR49781 Updates the OrderItemDisplayCmd properly add all out of stock item to the errorOrderItemId array.
JR50024 Changes the OrderCloseCmdImpl.processOrder method from private to protected to allow for customization.
JR50254 Provides access to the Messaging configData object in the order notification process. This enables access to email properties such as CC, sender and recipients for the order notification emails.
JR50310 Fixes an issue where finalization of payments does not deposit the full amount of the payment.
JR50349 Fixes an issue where customers might not be able to access correct pending orders.
JR50501 Fixes an issue where you cannot process refunds when customers use partial shipment method.
JR51086 Modifies ResolveIdHelper method to resolve customer access control issues.
JR51290 Changes shipping adjustment to fixed adjustment instead of percentage adjustment.
WebSphere Commerce Version 7.0.0.9Programming Framework JR49998 Reduces memory footprint and improves performance when evaluating member relationships for organizations that have a large number of descendant organizations.
JR50041 Makes Tickler objects cacheable.
WebSphere Commerce Version 7.0.0.9Runtime JR49558 The double-click handling code was corrected to prevent a NullPointerException in MultiClickRequestHandler.
JR49568 Special characters can now be used when service logger is enabled.
JR51053 Resolves an issue which was introduced by upgrading to IBM Java SDK 1.6 SR16.
JR48985 Resolves an issue in Management Center where some SKUs are not displayed for products that contain more than 1000 SKUs.
JR50677 Improves performance of administration tools such as the Organization Administration Console.
JR51479 Fixes an issue where sessions never timed out when working with REST requests.
JR50713 Provides an option of configuring the timeout of REST requests made via the RESTTag tag.
JR51324

Security fix:

Removes potential security vulnerability regarding temporary redirects.
JR51102 Resolves an issue where unexpected results occur because non-SEO URLs use the shortened context root.
JR49685 Modifies the DataServiceFacade class to avoid Java deadlock conditions during server start up.
JR49842

Security fix:

Updated error.jsp, GenericApplicationError.jsp, and GenericSystemError.jsp so that detailed error messages are not displayed in non-Developer environments.
JR50691 Adds support for different persistent cookie expiry times for guest shoppers and registered shoppers.
JR49922

Security fix:

Enabled Cross-site Request Forgery protection for some commands in the Organization Administration Console.
JR49897

Security fix:

Patches a potential vulnerability related to XML processing.
JR49925 Fixes an issue where during Dynacache clearing, the baseCache is cleared before the object caches, which causes incorrect results to be displayed.
JR49999 Updates the Administration Console to correctly display the actual state of jobs after a Refresh action.
JR50083

Security fix:

Provides the ability to mask certain Component Services exceptions with a generic message before the error message is embedded into the service response.
JR50131 Improved DynaCacheInvalidation job to improve the performance of clearall calls.
JR50206 Fixes an error where enabling Cross-site Request Forgery protection might cause Cross-site Request Forgery errors after log on.
SE59015 Fixes an issue where some STAGLOG entries remain unprocessed after Quick Publish.
JR50373 Prevents recursion when attempting to log request parameter exceptions.
JR50438 Addresses an issue where DSL two-step queries fail when the 'usePrimaryKeyValues' flag is set to false.
JR50674 The automatic caching feature has been changed to remove from the hard coded list of disqualifying table names, table names explicitly configured in the CrossTransactionCache/autoCacheableTableNames Search Server setting in the com.ibm.commerce.foundation/wc-component.xml configuration file.
JR50754

Security fix:

Resolves cross-site scripting issues in the Organization Administration Console.
JR50967

Security fix:

Resolves cross-site scripting issues in the Organization Administration Console.
WebSphere Commerce Version 7.0.0.9Search JR49587 Fixes an issue where shoppers might see empty categories on the storefront. The FastFlowForEntitlement configurable parameter was created to allow users to decide if they want to leverage the new entitlement flow
JR49944 Provides support for exact match synonym cases where one synonym value is a subset of another larger synonym.
JR50161 Install APAR JR50161 to fix an issue where WebSphere Commerce Search is disabled if you install Fix Pack 8 without installing the latest Feature Pack.
JR51723 Updates search logic for the store to support double-byte character keyword searches.
JR51262 Provides logic to support the enabling of B2B contracted price indexing
JR50682 Enhances auto-suggest to allow users to use Sales Catalog specific auto-suggest.
JR50448 Updates enablement code for integrating IndexLoad into the WebSphere Commerce Search server.
JR50749 Provides a new DynaCacheInvalidationCaptureHelper class that can be used to determine the cache invalidation IDs that would be issued by the DynacacheInvalidation scheduler job when it processes rows in the CACHEIVL table.
JR49920 Improves performance of Search server cache invalidation.
JR49835 Enhances search server to support multiple eligible contracts.
JR49784 Sets Locale as an optional parameter available on the search server if a langId is not specified. Search server attempts to retrieve a locale and match the locale to a langId.
JR49888 Improves performance of delta indexing by removing deep category cache invalidation upon updating any catalog entry.
JR50762 Fixes an issue where running the dataextract utility with trace enabled results in a java.lang.StackOverflowError exception.
JR50755

Security fix:

Provides the ability to specify a custom password file and store encrypted passwords for the di-buildindex and di-preprocess utilities.
WebSphere Commerce Version 7.0.0.9Stores and Mobile JR49311 Updates Store Preview to properly handle store preview situations where the context root has been shortened to /.
JR49600 Corrects the Sorting option for gift registry results to be able to sort by EVENTDATE in descending order.
JR51276 Fixes an issue that occurs where pressing Back on the Checkout pages can cause blank entries in the PPCEXTDATA table and an amount of 0.
JR49902 Fixes an issue where launching Store Preview directs to a 404 page when the shortened context root is a substring of the store context path.
WebSphere Commerce Version 7.0.0.8

Fix Pack 8 fixes

The following fixes are included in Fix Pack 8.
Note: The fixes that are included in Fix Pack 8 are displayed in a single table that sorts the fixes by category.
Category APAR Description
WebSphere Commerce Version 7.0.0.8Analytics JR43805 (also includes JR45105 JR44687 JR42938) Adds the ability to support multiple analytics providers.
JR45105 Corrects an issue where conflicting category information is sent to the analytics engine for the same product and order.
JR48930 Resolves a null pointer exception that occurs after APAR JR42537 is installed and an Event Component is disabled, encountered during the EventProcessor scheduled job.
JR46280 Fixes the getFooter() method in BiConfigRegistry.java. No longer returns null values.
JR49259 Enhances the analytics configuration available in biConfig.xml to allow for the modification of the URL that is used by Management Center to open the Coremetrics portal.
JR48917 Fixes an issue where some information about the shopper may not be available through WebSphere Commerce when paying with non-traditional methods (such as the PayPal customization).
WebSphere Commerce Version 7.0.0.8Authoring and Staging JR44368 Corrects an issue with an error that is being displayed upon reloading the task list after a workspace task group is approved.
JR47784 Corrects an issue with stagingprop where it fails during queries to invalidate cache for marketing and promotion tables.
JR50237 Fixes an issue where a task group fails to COMMIT due to potential conflicts such as duplicate keys or foreign key violations. Tables with String or other non-numeric types were not updated.
JR48564 Updates Quick Publish to fail when Quick Publish tries to update data that does not exist in the Production database.
JR50002 Improves publishing performance by addressing a SqlIntegrity Violation Exception with the ATTRVALDESC table.
JR49856 Enhances StagingProp utility to avoid performing unnecessary consolidation.
JR49876 includes JR49958 Enhances the StagingProp utility diagnostics messages that are displayed when a DELETE RESTRICT foreign-key relationship is violated.
JR49965 Updates the StagingProp, StagingCopy, and FileProp utilities to use the common database connection acquisition infrastructure.
JR49857 Enhances the StagingProp utility to avoid performing unnecessary consolidation.
JR49472 Modifies Quick Publish configuration files hto support multiple Java Virtual Machine connection strings.
JR49872 Enables validation of configuration information for database and instance creation.
JR49874 Enables usage of common connection infrastructure for utilities
JR49875 Enables usage of common connection infrastructure in StagingProp, StagingCopy and FileProp utilities
JR48772 Updates Quick Publish to avoid executing updates on target tables with no data columns.
JR47985 Avoids java.sql.SQLSyntaxErrorException: ORA-00904: "KEY": invalid identifier error during quick publish.
JR47901 Allows for the ability for INVCNFREL and INVCNF to be available in the staging database.
JR45335 superceded by JR49190 After approving a workspace task group, the task group returns in the 'Commit Failed' state with a foreign key violation exception in the log during the approval process. If all data that is referenced by the offending table in the exception exists in the workspace and task group being approved, then this may be caused by a problem with the order in which resources are processed during the workspace approval.

For example, a child table such as FACET is processed before its parent table ATTR and thus the foreign key is committed to the production ready schema before its parent primary key table is inserted.

JR45484 Allows specific instances or cluster members to be used for scheduled quick publish jobs.
JR45726 Fixes a SqlIntegrity Violation Exception with the table ATTRVALDESC and improves publishing performance.
JR46056 Recommended fix:

Ensures that relevant records in the STAGLOG table have their STGPROCESSED columns updated correctly after propagation completes.
JR46351 Removes unnecessary queries to CMMETADATA in the regular storefront, which potentially impact performance.
JR46354 Ensures that records not found on the Staging database during invocation of the StagingProp utility are no longer left as-is. Instead, they are marked with a value of -5 in the STGPROCESSED column of the STAGLOG table.
JR46824 Resolves an issue with approving a task group in Management Center failing with a ContentApplicationException.
JR47858 Improved StagingProp utility to aid in diagnosing propagation issues that are not seen in logs.
JR47235 Resolves an issue with StagingProp where a lengthy consolidation phase leads to timeout errors.
JR48809 Resolves an issue where quick publish cannot publish more than one attachment in an authoring environment.
JR46699 Resolves database deadlock during the cleanup phase in TaskGroupCleanupCmd.
WebSphere Commerce Version 7.0.0.8Catalog, Assets, Contracts, and Pricing JR44369 Prevents an ORA-01795 exception in GetCatalogEntryAttributesCmdImpl.
JR45871 Allows users to upload a managed file again after it is marked for deletion.
JR48952 Allows for customization of the AbstractCatalogEntryMediator.getNames() method.
JR48185 Enhances the catalog mediator to allow an update of an entry rather than insertion in the CATENTDESC table to avoid DuplicateKeyExceptionmessages during data load.
JR48819 Modifies the Management Center upload code to prevent upload errors when using Mozilla Firefox browser.
JR47491 Fixes an issue where Catalog Entry web services fail when multiple attribute values of more than one type are specified in the request.
JR48661 Changes the constructor for setSalesCatalogId from private to protected.
JR48141 Enables the ability to map catentries from a master catalog store to a sales catalog category through a CSV file upload with catalog upload.
JR45890 Resolves an issue where UNIX or Linux based WebSphere Commerce application nodes fail to upload files to a Microsoft Internet Services V7.5 FTP server.
JR48903 Resolves a performance issue with heavy validation SQL executions that are repeating if an extended site store does not have a default catalog.
JR46030 Resolves high CPU load issue with RetrievePricesCmdImpl.retrieveParentCatalogEntryIds().
JR46048 Resolves slow query performance when deleting workspace (non-approved) attributes.
JR46616 Corrects an issue where the first asset in a set is not transferred when moved through FTP or file system copy.
JR47806 Corrects an issue with the short and long description fields for an item that is created in Management Center not populating their respective entries in the BASEITMDSC database table.
JR46640 Resolves an issue where unlinking an uncommitted category in a workspace does not unlink the CATGPENREL entries.
JR46678 Resolves an issue with the ChangePriceList service updating only one price list when it is called to modify multiple prices in multiple lists.
JR46748 Adds a lightweight debug trace for category linking.
JR47321 Corrects an issue with the Catalog Filter tool in WebSphere Commerce Accelerator where SKUs are not displayed if their CATENTDESC.NAME=null.
JR47552 Resolves an issue where unlinking a category in Management Center takes an extended amount of time or times out.
WebSphere Commerce Version 7.0.0.8Data Load and other loading tools JR44531 Fixes an error that occurs loading data into the SEARCHABLE and FACETABLE columns of ATTR, causing Dataload to fail.
JR45483 Adds support to map category entries from a master catalog store to a sales catalog category from a CSV file upload.
JR50058 Introduces a class to centralize acquisition of database connections for utilities.
JR50093 Introduces a class to centralize acquisition of database connections for utilities.
JR50467 Updates the Data Load utility to use the common database connection acquisition infrastructure.
JR50112 Updates the StagingCopy utility to prevent output of separators for digit-groupings in numeric literals when the -script_file option is used.
JR50103 Enables the ability to diagnose database and instance configuration information during:
  • Instance creation
  • UpdateDB execution
JR50097 Provides a updateua utility for seamlessly updating database-user authorizations. Additionally, this APAR improves consumption of database resources used by an internal utility to perform schema-related operations.
JR51724 Enables infrastructure for specifying command-line parameters and their values as key and value pairs from a file. This APAR includes support for specifying values for keys in encrypted form where necessary.
JR51732 Provides the ability to turn off error logging when running the Data Load utility by by passing -D.level=OFF as a parameter.
JR47023 Fixes an issue where Data Load utility does not load ATTRVALDESC table in an update operation if the assigned value was not changed.
JR48578 Introduces the ability to Dataload the MetaDescription column while also allowing for the PageTitle column to be left blank.
JR47999 Fixes an issue where the idresgen utility does not output records with existing Primary Keys, or fails to consider some Foreign Keys.
JR45560 Corrects the Dataload behavior when the attribute value description (ATTRVALDESC) is deleted for the default language.
JR45579 Resolves a Dataload out of memory exception caused by setting the ldresolver cache to require more memory than what is allocated in the Dataload JVM heap.
JR46729 Adds additional SEO mediators to Dataload that were introduced in older feature packs.
JR47637 Dataload fails to load a product with attribute values if the product was previously deleted and its attributes orphaned.
JR45717 Resolves a performance issue when using catalog upload or Dataload with an Oracle database.
JR45763 Resolves validation errors that are caused by uploading relationships in sales catalogs that exist in the master catalog.
JR45887 Improves Dataload performance.
JR45906 Corrects an issue with loading CatalogEntryCalculationCode data with Catalog Upload clearing existing entries in the CALFLAGS column of CATENCALCD table.
JR46050 When the DataLoad utility is used to load ATP inventory data, this fix ensures that the operation mode is "I" when there is no record found in the database, so that the ITEMFFMCTR table can be populated properly.
JR46524 Resolves an issue where Dataload terminates with an error when it encounters a null character in the input data, regardless of if maxError is set to 0.
JR46732 Resolves an issue when using StagingProp with Oracle databases.
JR46827 Corrects issue with Dataload when loading calculation code information for multiple categories.
JR47127 (includes JR46050) Resolves an issue where upon loading ITEMSPC data without using the associated catentry_id, some ITEMSPC records appear to be missing.
SE54757 (includes JR40823 JR41495 JR41930 JR42037 JR42047 JR42158 JR42303 JR42755 JR42900 JR44840 JR45210 JR45856) Resolves an issue where the idresgen utility appears to hang when invoked against Oracle databases.
JR47564 Resolves an SQL exception that is encountered with Dataload when the preFetchJDBCConnection setting is set to true.
JR48805 Corrects an issue in the FeedRetriever parser, which truncates any parameters incorrectly when they contain the "=" symbol.
JR48951

Security fix:

Corrects a possible Cross-site scripting (XSS) vulnerability in the WebSphere Commerce administration tools.
WebSphere Commerce Version 7.0.0.8Installation, Configuration, Deployment, and Migration JR45589 Resolves an issue with Content-Version enablement. Enablement fails if certain custom table space is in use on a DB2 database for Linux, UNIX, or Windows.
JR46373 Updates permissions within the extracted WebSphere Commerce Build And Deployment (WCBD) build file, so they are not required to be manually changed.
SI44390 Introduces an optional instance configuration in the InstanceProperties tag of the wc-server.xml file. This configuration provides troubleshooting information for issues about why database transactions are not committed.
JR50175 In a PureScale environment, the Fileloader utility hangs with a hung database transaction error because more properties need to be specified for the database connection to allow for better use of the PureScale architecture.
JR48209 Improves the consistency of file transfers that are performed by the ScheduledContentManagedFileEARUpdate job.
JR47608 Adds support for DB2 10.1.
JR47850 Resolves an issue publishing MadisonsMobileEnhancements.sar and incorrect file permissions.
WebSphere Commerce Version 7.0.0.8Marketing and Promotions JR44673 Resolves issues that are related to rendering images that are encountered by Microsoft Outlook users in relation to e-marketing email templates.
JR48904 Removes unnecessary shopper entitlement checks for catalog entry display and product recommendation e-Marketing Spots, improving performance.
JR44880 Prevents multiple reloads of the marketing registry after a refresh.
JR48556 Enhances marketing activity performance by minimizing the number of SQL queries executed by marketing activities.
JR48611 Improves performance when invalidating marketing behavior rule cache entries.
JR48703 Improves marketing activity performance by minimizing the number of SQL queries executed by marketing activities.
JR48936 Methods in WCSOrderItemFactory and WCSOrderFactory are changed from private to protected to allow for customization.
JR49323 Prevents multiple reloads of the marketing registry after a refresh action.
JR49398 Fixes an issue where an anonymous user can use a "one time use" promotion code multiple times.
JR48246 Fixes an issue where a unique promotion code can be used multiple times.
JR47002 Fixes an issue where multiple promotions might not be applied correctly to an order when best deal is enabled.
JR48528 Corrects Management Center Store Preview function to be able to preview promotions that are set for a future date.
JR49116 / JR50546 Enhances the Management Center Marketing tool to allow a promotion with a Coupon promotion redemption method to be used in a web activity's Recommend Promotion action with a marketing content that has Add to shopping cart and apply promotion as the click action.
JR49493 Fixes an issue where emails are not sent by the Customer Abandons Shopping Cart dialog activity.
JR44939 (includes JR40823 JR41022 JR41551 JR41545 JR41832 JR42158 JR42507 JR43804 JR44880 JR44999 Provides improved invalidation of the marketing object cache as part of running the stagingprop utility.
JR45304 Corrects an issue with CheckUserInMemberGroupCmd not returning the correct customer segment that the shopper belongs to.
JR48241 Resolves an issue where e-Marketing Spots generated for email templates are not displayed in the email when tracking is enabled.
JR48519 Resolves a performance degradation that is experienced when a promotion list with many public promotion codes is loaded.
JR48232 Resolves an issue were creating a large activity (50+ paths) in Management Center results in slow performance or browser hanging when a user opens it.
JR45376 Increases the maximum number of characters that are allowed in the URL field on Marketing Content in Management Center from 254 to 1024.
JR45705 Enables the use of the Marketing catalog entry filter 'removeIfNoInventory' to work with non-ATP shared inventory.
JR45719 In the Management Center Marketing tool, enables you to set up a different custom click action URL depending on the customer's language when you create content.
JR45774 Resolves an issue where overriding the default promotion type configuration through the WC_eardir/xml/config/com.ibm.commerce.promotion-ext/ extension directory does not work.
JR45820 Prevents the marketing cache from caching errors.
JR45888 Corrects Product Recommendation marketing activity display count if one or more selected products are filtered out due to their inventory level.
JR45940 Corrects an issue with the "Merchandising Association Recommendation" marketing activity that is displaying products that belong to a different extended site store.
JR45985 Fixes an issue that allowed for expired promotion details to be displayed on the storefront.
JR46001 Corrects the order of displayed merchandising association product recommendations in an e-Marketing Spot to reflect the order that is defined within Management Center.
JR46007 Fixes the CheckForBouncedEmail scheduled job to properly read bounced email messages from the SMTP server, and to record the information in the EMLBOUNCED and EMLBADADDR database tables.
JR46142 Enhances promotion evaluation performance by changing customer segment validation logic.
JR46153 Resolves an issue where recommendation limit is not being respected in an e-Marketing Spot when the DM_ActivityOrder parameter is set to true.
JR46230 Splits access control policy keys between the staging and production environment. This is needed for V7 Fix Pack 6 and Fix Pack 7 users who wants to publish a store on the staging server and might load access control policy directly to the production server.
JR46349 Convert promotion schedule to UTC for correct evaluation on different servers with different time zones.
JR46449 Allows for consideration of promotion details when displaying proximity messages on e-Marketing Spots.
JR46500 Increases cache hit rates for ShopcartDrivenAgendaBuilder, improving site performance.
JR46633 Resolves an exception that is encountered by deleting records from the MBRGRP table after a marketing email is sent.
JR46643 Resolves a performance issue that is encountered when a large volume of marketing email with unique promotion codes is generated.
JR46769 The SendMarketintTrigger scheduled job is modified to process Time Based triggers in batches to avoid high memory usage and out of memory exceptions.
JR47069 Implements caching for repeated SQL queries within the same dialog activity, improving performance.
JR47239 (Includes JR46349 JR43510 JR44881 JR44904) Stops promotions from being deactivated while promotion codes are being generated.
JR47383 Enables the ability for the CampaignInitiativeRegistry not to be cleared on web activity changes done in Accelerator.
JR47603 Resolves a rare condition that can lead to a JVM hang during initialization of the MarketingMetadata class.
JR47791 Extends e-Marketing Spot names from 64 characters to 256 characters.
LI77507 Resolves duplicate key exception that is encountered when a workspace is published.
SE54253 (includes JR40823 JR41022 JR41551 JR41545 JR41832 JR42158 JR42507 JR43804 JR44880 JR44999 JR44939) Prevents an issue that causes dialog activities to intermittently stop working so that additional customers cannot participate in the dialog activity.
WebSphere Commerce Version 7.0.0.8Member and Session Management JR45300 Fixes the CheckUserInMemberGroupCmdImpl command to properly handle the scenario in which an asset store customer segment definition includes conditions that refer to another customer segment.
JR45302 Resolves a security issue with web services authentication that could allow access to another user's session.
JR49981

Security fix:

Added cross-site request forgery protection to the MemberGroupMemberUpdateCmd command.
JR48875 Adds an error code for easier troubleshooting of a specific warning message.
JR48873 Corrects the handling of session expiry on CSRF protected pages.
JR45670 Provides a method of allowing users to log on to the same store from different channels at the same time.
JR45876 Addresses an issue for users who use the quick checkout profile that causes the shipping and billing addresses to both be shown in shipping address list and billing address list.
JR45949 Resolves an error that occurs during user registration when WCS is configured with LDAP.
JR45992 Corrects an issue when the LDAP password is created and then updated with the same password during user registration on the store front, or within the WebSphere Commerce Organization Administration Console. This update causes an error to be logged.
JR46008 Address an issue that caused Customer Segment conditions on the Account page in a B2B store to not work properly.
JR47290 Corrects an issue where large member groups cause an out of memory condition.
JR47640 Changes the AddressDo.isEmailAddressValid method from private to protected, so email address validation can be bypassed to avoid errors for users with no entered email addresses.
WebSphere Commerce Version 7.0.0.8Messaging and Integration (including Sterling integration) JR45119 (also includes JR43852) Resolves an issue that causes nouns of messages created by the Person and Orders services to not conform to their schemas.
JR46588 Resolves a failure to send multi-part messages, resulting in error CMN8216E: An error invalid stream header occurred.
JR48922 Corrects an issue with dynamic kit pricing changes that are not being applied in the carts of customers who have already added them.
JR46862 Resolves an issue with SyncInvetoryAvailabilityCmd failing an entitlement check when certain items are excluded from the default contract.
JR47189 Removes hard coding of MSGTYPE_ID 126.
JR49101 Improves performance of remote widgets by avoiding frequent queries to the STORETRANS database table.
WebSphere Commerce Version 7.0.0.8Orders, Payments, and Inventory JR45586 Makes the checkOrderPaymentAmountRemaining method protected.
JR46964 Changes the getOrder service to avoid certain unnecessary database queries to the TERMCOND, SHIPINFO, and STLFFMREL tables.
JR47487 Improves promotions performance by caching frequent queries to the PX_USAGE and PX_COUPON tables.
JR47986 Fixes an issue where a promotion short description displays on the storefront product display page irrespective of promotion schedule that is defined in Management Center.
JR48765 Fixes an error where shipping charges are displayed incorrectly in store but shipping adjustment is applied correctly when 2 or more promotions are enabled.
JR48932 Removed a potential DoS vulnerability related to Order web services.
JR49530 Changed various payment methods from private to protected to allow for customization.
JR45843 Corrects an issue where the RMAAUTHLOG table is not populated after an RMA is manually approved.
JR45873 Resolves an issue that causes an incorrect shipping address to be displayed during checkout.
JR48992 Replaces a deprecated math Java class that is being used with a supported one on the Solaris platform.
JR48648 Eliminates unnecessary queries to the ORDIADJUST table when an order is being prepared.
JR46223 Prevents excessive GetInventoryAvailability calls when the available inventory quantity is below threshold.
JR46900 Reduces the number of ORDITPRMOCD table queries to improve performance for shoppers with large carts.
JR46596 Removes unnecessary updates that are found in InitializeSalesTaxCmdImpl.performExecute().
JR49010 Makes variables within ProductInventoryUpdateCmdImpl public, to be used in potential customization.
JR46768 Modified payment framework so payment parameters that were set to not persist are set to persist temporarily within the context of a custom payment system.
JR47560 Reduces duplicate concurrent inventory calls if multiple shoppers browse a product with a cached inventory value that is expired, increasing performance and reducing the load on the inventory server.
JR46816 Allows for scheduled and recurring orders with Sterling Order Management enabled.
JR46890 Allows for the reduction of heavy database queries for large carts.
JR46984 (includes JR46890, JR41269) Improves order processing performance by reducing SQL executions in CalculationHelper.java.
JR47107 Adds support for using no inventory system.
JR47162 (includes JR45008 JR44392) Removes unnecessary updates to the ORDERITEMS table during the add to cart and checkout flow.
JR47195 Corrects MemberAttributeValueListDataBean so that it returns the DATETIME attribute type.
JR47256 Corrects an issue for customers who use the order approval flow in a B2B store model where purchase order numbers are not populated in the Organization Administration Console.
JR47349 Improves the logic that is used for large tax category database queries, improving performance.
JR47632 Allows override of the CheckInventoryAvailabilityCmdImpl.checkInventory method.
JR48189 Resolves an issue with services not recognizing DoInventory and DoPrice flags during requests.
JR48189 Resolves an issue where quantity is not correctly calculated when an item is added to the cart due to rounding.
JR48718 Resolves an issue where customers might not be notified by email of scheduled or recurring orders.
JR47397 Improves shopper experience by allowing partial inventory reservations for environments with the DOM inventory model.
JR47492 Adds a reduceMemory option and two new configuration parameters for the CalculationRegistry RangeCache, allowing for improved performance through fine-tuning of the memory footprint.
JR47546 Improves performance by implementing caching of catalog entry inventory configuration in the INVCNF table.
WebSphere Commerce Version 7.0.0.8Programming Framework JR45225 Allows custom code to add request attributes for servlet caching.
JR46046 Resolves an issue with wcf:url not constructing the full URL based on the HTTPS flag set in struts when customized HTTP and HTTPS ports are set in wc-server.xml.
JR51494 Fixes an issue where Management Center Store preview stops working if a custom port number is used.
JR48782 Fixes an issue where users cannot complete JUnit test cases because exceptions related to cache configuration are thrown.
JR48163 Recommended fix:

Addresses an issue where refreshing the URL or View registry while it is being used by a shopper request can occasionally lead to a Java Virtual Machine deadlock and hung threads.
JR50045 Modifies the samples/dynacache/cacheinstances.properties file so that unnecessary error messages are not sent to the SystemOut.log file.
JR50100 Updates the FileLoader utility to use the common database connection acquisition infrastructure
JR47827 Allows override of the FetchExternalPriceEntryCmdImpl.callExternalPriceService method for use with external pricing services.
JR47100 Reduces TERMCOND database queries to improve response times to shopping cart operations.
JR46590 Enables SOI overlay support on REST.
WebSphere Commerce Version 7.0.0.8Runtime JR44371 Enhances the SendTransactedMsg scheduler job with the maxSeconds parameter to help control concurrency.
JR42714 Offers additional options to content administrators to resolve some data conflicts created across multiple workspaces.
JR50765 Added more cache to reduce queries to the STORETRANS table from the ModelHelper constructor.
JR50322 Updates maintenance utilities to prevent the changing of names or object definitions to upper case characters when creating or updating workspaces or content-versioning features.
JR47933 Fixes an issue where a Workspace Task Group appears in Commit Failed state after approval because of validation errors in promotions.
JR48865 Removes the possibility of a security vulnerability with XML injection.
JR48892 Allows users to write custom code to handle cache invalidation.
JR49088 Fixes an issue that prevent shopperes from seeing specific data associated with group to which they were added.
LI77564 / JR47989 Corrects an OutOfMemory exception due to OptCounter, if TransactionManager is not called to create a transaction.
JR44594 Enables the ability for previewing content changes in BOD and REST service clients.
JR48874 Provides extra trace information to help troubleshoot DuplicateKeyException errors in the CTXMGMT table.
JR44694 Improves the performance of cascaded deletes on some WebSphere Commerce database tables. Specifically, CATENTRYATTR, ATTRDESC, and ATTRVALDESC.
JR47978 Introduces caching for the OFFERDESC table.
JR47916 Corrects an issue with the langId parameter is lost when an ajax action redirects to a login form view.
JR44840 Allows for database users other than the schema owner to connect to and work against the WebSphere Commerce application and utilities.
JR44869 Corrects compilation errors due to difference in element names between some XSDs.
JR44882 Improves performance by avoiding placing user-related data into the baseCache servlet cache instance.
JR45547 Prevents multiple attributes from being returned by IBM_CatalogEntryAttributesWithoutEntitlementCheck.
JR45865 Provides new attributes that you can use to configure timeout values for the HTTP or HTTP-WS connectors.
JR46081 Allow migration of a 16 character Merchant Key to a 32 character Merchant Key using KLF.
JR46096 Resolves an unnecessary database lock with no active transaction.
JR46160 Fixes an issue where the Data Service Layer wizard does not generate UserData mappings for custom tables.
JR46203 Allows for service framework requests to be logged to the ACCLOGMAIN and ACCLOGSUB log tables.
JR46386

Security fix:

Resolves a security vulnerability with a crypto URL parameter, which could lead to the disclosure of sensitive user data.
JR46776

Security fix:

Resolves a security vulnerability in tooling pages that could allow for a cross-site scripting (XSS) attack.
JR46963 Resolves an issue where retrieved CreationDateTime time stamps from web services are truncated.
JR46985 Applies narrower tracing at the class level, and reduces overhead of tracing at the component level.
JR47365 Resolves an issue with WeakHashMap causing locking and blocked threads with multiple requests to ThreadLocalFoundationProxy.
JR47490 Allows for the schedule work managers configuration to be located on the local WAS node, rather than needing DMGR to be active in order to retrieve it.
JR47553 Resolves an issue with user cookies that occurs after applying APAR JR46386.
JR47803 Resolves an error that is encountered when approving a quick publish to production, causing DynaCache not to be invalidated.
SE56069 Enables the ability for WebSphere Commerce to identify WebSphere Application Server credentials that are passed in LTPA Tokens.
JR48579 Adds a new logical data cache for the getCatalogEntriesByMAssoc.TypeAndStore() method, leading to improved performance.
WebSphere Commerce Version 7.0.0.8Sales Center JR46255 Prevents a ClassCastException while activating the TickerReasonDataBean via JSP.
JR47275 Implements caching for repeated queries to the MBRATTR and MBRATTRVAL tables for improved performance.
WebSphere Commerce Version 7.0.0.8Search JR45569 Implements caching of some frequently executed SQL queries to improve performance of search display pages.
JR45727 Resolves a search database issue during feature enablement, which causes feature enablement to fail.
JR47425 Replaces the synonym expansion for the AND case with a compact form.
JR50129 Introduces sharding to the di-preprocess and di-buildindex utilities, to allow for multiple parallel processes. This enhances performance of the utilities.
JR47295 Recommended fix:

Includes a number of performance fixes for facet management.
JR46603 A cumulative group of old fixes that resolve issues with search.
JR47001 Resolves an issue with di-preprocess where it always reports completing successfully when the multithread parameter is set to true.
JR47090 Corrects the sequence of displayed facets in search results after one is defined on the Attributes List page within Management Center.
JR47565 Corrects an issue with searching for attribute dictionary attributes throwing an AttributeDictionaryAttributeException, due to configuration file merging.
JR48850 Contains a number of search-related fixes.
JR45647 Old SEO-URLs do not redirect to the newly defined SEO-URLs.
JR47295 Contains a number of search-related fixes.
JR47568 Improves performance for stores that use large amounts of facets and facet values.
WebSphere Commerce Version 7.0.0.8Stores and Mobile IV41166 Updates SiteMapGenerate so it respects the maxURLNumber parameter.
JR46108 Addresses a problem with SEO URLs for sales catalog when catalogId is not present. This problem affects WebSphere Commerce users on Feature Pack 3 or Feature Pack 4 who have applied the SEO Workspace APAR JR41596.
JR48832 Fixes an issue where the wcf:url tag is not constructing the proper Ajax URLs when inSSLAcceleratorPort and the inNonSSLAcceleratorPort are set to the same port.
JR48332 Ensures that old SEO URLs redirect to new SEO URLs.
JR46271 Improves TaxCategoryAccessBeans and StoreCopy memory usage.
JR46447 Resolves an issue with the billing address dropdown for the B2B Elite store being populated incorrectly.
JR46450 Resolves an issue with some SEO URLs being incorrectly generated after upgrading from pre-Feature Pack 3 to Feature Pack 3 or later, leading to inaccessible pages.
JR46635 Resolves an issue with adding items to a wishlist that occurs when the unused DISPENTREL table is not populated.
JR46967 Resolves a finder exception that occurs during the checkout flow for a free gift when a shopper changes their mailing address details.
JR47131 Resolves an issue with WebSphere Commerce Accelerator store creation wizard displaying a blank page when using the Advance Store Publish link to publish extended sites.
JR47250 Resolves an issue where UserData fields from the STLOCDS table become inaccessible when PhysicalStoreType is used.
JR47356 (includes JR43062 APAR JR42569 JR47364) Enables the ability for SitemapGenerate to create multiple files for multi-language sites.
JR47456 Resolves a SQL exception that is caused by publishing ExtendedSitesCatalogAssetStore-FEP.sar with sample data.
JR47972 Resolves an issue with wcf:url causing a NullPointer exception with URLs with no context path.
JR48186 Adds a parameter to SiteMapGenerate to make EAR updating optional.
JR47888 Resolves an issue where SEO URLs with prohibited characters are not redirected properly when WhitelistProtection is enabled.
JR46920 Adds a data cache configuration option to delay requests after cache invalidations to ensure that stale data is not served incorrectly.
JR48477 Corrects an issue where the SitemapGenerate scheduler job times out when there are a thousand products or more under a single category, leading to incomplete site maps.
WebSphere Commerce Version 7.0.0.7

Fix Pack 7 fixes

The following fixes are included in Fix Pack 7.
Note: The fixes that are included in Fix Pack 7 are not divided into separate tables for critical fixes and additional fixes. Instead, they are contained in a single table that sorts the fixes by category. The Description column indicates if a particular fix is recommended, if it improves performance and stability, or if it improves security.
Category APAR Description
WebSphere Commerce Version 7.0.0.7Analytics JR42938 Allows JavaScript variables to be passed into extraParam attributes in WebSphere Commerce Feature Pack 3 and later.
JR43643 Security fix:

Changes the code so that an encrypted password must be entered in wc-server.xml.
JR44687 Fixes a problem that is related to the cmOrder tag not respecting promotion codes properly.
WebSphere Commerce Version 7.0.0.7Authoring and Staging IV27768 Prevents CMSMALLFILE and CMLARGEFILE entries from being incorrectly deleted when a task group is canceled in a workspace. Also prevents CMSMALLFILE and CMLARGEFILE entries from being incorrectly approved when a task group is approved in a workspace.
JR41596 This fix is to allow Feature Pack 3 SEO URLs to be used with workspace preview.
JR50138 Ensures records in the STAGLOG have their respective STGPROCESSED column entries updated upon completion of propagation.
JR42808 Recommended performance and stability fix:

Improves Search performance by reducing the number of queries to the database that are related to contracts.
JR43881 Addresses a problem in which updating the attribute dictionary attribute value of a product can cause the stagingprop utility to fail. This fix updates one of the primary columns of the table.
JR44368 Fixes an issue where, after a workspace task group is approved, reloading the last list displays an error message that says the task is no longer valid.
JR44693 Prevents a foreign key violation error from being encountered when you approve a task group within a workspace on an authoring server. The foreign key violation error causes the task group to enter Approve Failed state.
WebSphere Commerce Version 7.0.0.7Catalog, Assets, Contracts, and Pricing JR40579 Prevents the Management Center from timing out when you link categories between catalogs and the category has a large number of catalog entries.
JR42311 Ensures that the product Quick Info dialog shows properly when WebSphere Commerce is using an Oracle database and the shopper belongs to more than 1000 member groups.
JR44343 Ensures that the ProductDataBean displays the Maximum and Minimum prices of entitled products only.
JR42569 Recommended fix:

Resolves a ClassCastException that occurs when you run SitemapGenerate with the catalogId parameter when FEP3 or FEP4 Search Engine Optimization is enabled.
JR42640 Changes the composeListPrice method of the ComposeCatalogEntrySummaryTaskCmdImpl class from private to protected so that it can be overridden by customer.
JR42644 Enables WebSphere Commerce to support importing a contract with and XML file that contains multiple catalog filter level participants.
JR42667 Addresses a problem in which new Attribute Dictionary values fail to load when the file contains duplicate entries and the loading is batched.
JR42757 Resolves an error that can occur when you use Oracle and there are over 1000 top categories in the catalog. When you try to retrieve a description from the CATGROUP table, you receive this error: 
ORA-01795: maximum number of expressions in a list is 1000
JR43640 Recommended fix

Fixes an issue that causes catalog upload to fail after you upgrade to WebSphere Commerce Fix Pack 6.
JR43826 Prevents a problem where users are unable to save changes to a product description in the Management Center after you upgrade to Fix Pack 6. They receive an error that says that the catalog passed in is not a master catalog.
JR43830 Ensures that product attributes are displayed in the expected sequence in WebSphere Commerce V7 reference starter stores product comparison pages.
JR43881 Addresses a problem in which updating the attribute dictionary attribute value of a product can cause the stagingprop utility to fail. This fix updates one of the primary columns of the table.
JR44776 Sets the selected organization into the command context so that the eligible contracts can be retrieved in the entitlement context.
SE50648 Prevents the sales catalog from changing to the master catalog after promotion refresh. This issue occurs after sales catalog categories are specified in the category exclusion list during promotion creation in the Management Center.
WebSphere Commerce Version 7.0.0.7Data Load and other loading tools IV27234 Updates the scheduler command for promoting the managed file into the WebSphere Commerce EAR. If the scheduler detects managed files with missing content, it records information about the files into trace, ignores them, and continues. This fix ensures that all the remaining managed files are processed.
JR42047 Enhances the Data Load utility so that you can configure it to not flag errors that are unimportant, such as the deletion of an entity that does not exist.
JR45210 Address a problem that occurs if you have a firewall between their WebSphere Commerce server and the database. In such a circumstance, concurrent catalog uploads fail, since one holds the database connection longer than the firewall timeout.
JR43335 (includes JR42122) Addresses an issue in which product data that is loaded using MassLoad that has offers that have conflicting or overlapping quantity ranges or date ranges cannot be viewed and edited in the Management Center.
JR42122 (co-requisite fix: JR42073) Addresses an issue in which product data that is loaded using MassLoad that has offers that have conflicting or overlapping quantity ranges or date ranges cannot be viewed and edited in the Management Center.
JR43673 (also includes JR43645, JR43090) Enhances the data load framework to support the custom batch service, so that data can be sent to somewhere other than the WebSphere Commerce database.
JR45059 Addresses an issue that occurs when a .csv file that contains both deletes, and inserts or updates is loaded. A cascade delete effect in the Classic attributes mediator causes several attribute values to be deleted.
SI45620 (has dependencies on JR44788, JR44784, JR44789, JR44796, JR44791, JR43794, JR44531, JR44790, JR44797, JR43409, JR44799, JR44800, JR43509) Enables data loader to set the LANGUAGE_ID on the WebSphere Commerce ATTRVALDESC table.
JR42305 Updates the idresgen utility so that it provides more logging and tracing information.
JR42570 Fixes a problem that causes the data load of classic descriptive attributes with an integer value or float value to fail with a NullPointerException.
JR42663 Adds mediator logic to optionally ignore the soft error on deletion of a non-existent record and continue processing.
JR42755 Improves performance of the Data Load utility by reducing unnecessary static string comparisons throughout the utility.
JR42768 Ensures that data load is able to load the catalog entry and sales category relationship data when the catalog entry is already associated with another sales category.
JR42900 Fixes a problem that occurs when you use IDResolver with an Oracle database and the -schema option is specified. IDResolver fails to retrieve the list of unique indexes. This can lead to DuplicateKeyExceptions when you run the massload utility to load the IDResolved data.
JR42911 Prevents duplicate exclusion product set IDs from being generated through CatalogImport utility.
JR43409 Enables you to move an SKU to the new parent product using just one row in a .csv file.
JR43471 Fixes an issue that causes the massload utility to run unnecessary SQL against the obsolete LONGKEYS table.
JR43640 Recommended fix:

Fixes an issue that causes catalog upload to fail after you upgrade to WebSphere Commerce Fix Pack 6.
JR43672 Enhances variable substitution for the ContextData element in the data load configuration XML files.
JR43275 Fixes a problem that causes the WebSphere Commerce Data Load utility to fail with a StringIndexOutOfBoundsException when it loads special characters.
JR43509 Provides optional data load parameters to support a data load custom log file path. You can use these parameters, if you load more than one instance, to prevent the output from all instances from going to a single file.
JR44002 Makes the ATTRVAL value optional when you load product data with the Data Load utility.
JR44057 Disables caching of the ColumnExclusionList configuration when the catalog upload tool is used to prevent incorrect database changes.
LI76602 Ensures that the catalog import summary report shows the details of the error if the catalog import fails.
WebSphere Commerce Version 7.0.0.7Installation, Configuration, Deployment, and Migration JR41628 Updates the updateEAR script so that it does not overwrite certain metadata files if they exist in the Social Commerce EAR.
JR43793 Resolves 'Loading directory is wrong' exception that occurs during database migration on WebSphere Commerce Developer.
JR42698 Addresses an SQL error that occurs when the migration script fails to migrate the gift center because of an unclosed result set.
JR44308 Fixes the dos2unix Ant task so that it properly handles all characters in a file so that it does not incorrectly interpret the end of the file.
JR42741 Updates the WebSphere Application Server library to a newer version to address a SAXParseException that occurs when you run the versionInfo command with the -maintenancePackages option.
JR43827 Improves the technique that is used to detect whether a profile exists and is suitable for a new instance
JR44758 Fixes a problem that causes empty compressed files to be created in the temp directory of the host where the WebSphere Commerce application is run.
JR44920 Prevents a schema upgrade failure that can occur on DB2 pureScale databases.
JR45450 Prevents an updatedb failure that can occur if the largest value in the STGRFNBR column of the STAGLOG table is greater than the maximum value for a signed 32-bit int value.
WebSphere Commerce Version 7.0.0.7Marketing and Promotions IV18135 Ensures that if you set up Display Recently Viewed e-Marketing Spot, any recently viewed catalog entries are displayed.
JR43510 Makes it more difficult for users of Management Center to accidentally create site-wide promotions when no product or category is specified.
IZ55356 Allows the best promotional price to be retrieved for display on the WebSphere Commerce store front.
JR41894 Recommended fix:

Prevents the application server from crashing when a marketing email is sent to many recipients.
JR44847 (has dependency on JR43510 IV13932) Addresses an issue in which a business user is unable to save a promotion with many public promotion codes. This issue occurs because the combined length of promotion codes exceeds the 128 character limit of the PX_PROMOTION.CODE column.
JR45008 Fixes an issue where multiple "free gift" promotions do not behave as expected when one of the free gift items is out of stock.
JR44625 Fixes an issue where the task command LookupCategoriesForCatalogEntryTaskCmd does not find all parent categories of the catalog entry.
JR45182 (has dependency on JR41894, JR44130, JR41022, and JR42202) Provides a new method so that you can set the Sender email address for marketing email.
JR44997 Recommended fix

Addresses an issue in which a database exception occurs in the Add To or Remove From Customer Segment action. This issue occurs when the customer is already in the segment.
JR43902 Ensures that custom email template JSPs registered in the EMLMSG database table are displayed in the Management Center Marketing tool email templates list and in the utility pane Browse tab email templates list.
JR44539 Recommended fix: Performance and Stability

Makes a number of changes to improve the performance and configurability of the Best Deal logic.
JR42223 Ensures that free gift promotions using an AddStrategy of 0 (Add if needed) or 2 (Never add), correctly calculate the order total.
JR42507 Enables a customization to access an activity object when checking if an activity is active on an e-Marketing Spot.
JR42636 When calculating a discount adjustment, adjustments should become truncated at a zero if they cross the zero boundary line. In cases where custom calculation usages are used, they are not considered as part of the zero boundary correction.
JR42637 Ensures that when the promotion engine is started, it is able to calculate the running total of an order even when one of the order items has a quantity of 0.
JR42906 Resolves a NumberFormatException is logged when evaluating a customer segment that uses the Language condition to target a marketing activity that is based on a customer's preferred language.
JR43377 Ensures that when the Use marketing activities to add or remove customers check box is selected on the General properties tab of the Marketing tool, the task command returns only those customers who were added to the segment explicitly with their personalization ID.
JR43400 Resolves a problem with SKUs with commas to coupons in WebSphere Commerce Accelerator.
JR43741 Recommended fix:

Prevents an issue that causes OrderShippingModeListDataBean to calculate an incorrect adjustment when an order qualifies for a shipping promotion.
JR43806 Adds new function in Management Center Marketing tool that can target a customer the first time that customer enters the site.
JR44161 Enhances the WebSphere Commerce Accelerator Marketing code to ensure that it ignores orders that are owned by the generic user when it evaluates shopping cart and purchase history conditions.
JR44165 Prevents OrderAdjustmentDataBean from throwing an ObjectNotFoundException for promotions without a description.
JR44259 Prevents a blank storefront web page from being served when a user clicks a product link in a marketing email. This fix updates the ProductDisplayCmdImpl class to properly set the productId.
JR44392 Prevents incorrect shipping charges from accumulating with each shopping cart page refresh for a free gift item.
JR44305 Removes the redemption limit that is set on an order when a customer service representative edits the order.
JR44438 Modifies the marketing engine logic to not output an exception to the logs files when an unencoded parameter is passed to the marketing engine.
JR44695 Fixes a problem that causes a SendMarketingTriggers scheduled job to fail with a transaction timeout.
JR44754 Adds tracing to the DependencyInstantiationException class to help diagnose the situation when this exception occurs. This exception is thrown by the promotion run time.
JR44881 Corrects an issue that prevented promotions which contain long public promotion codes, or a large number of public promotion codes, from being saved.
JR44839 Addresses an issue that occurs when a marketing email template includes a link to display a category. The email sent to the customer displays "null" for the category link and the category image is not displayed.
JR44891 Addresses an issue that causes product images to be "null" in marketing emails sent by WebSphere Commerce when extended sites are used.
JR44904 Prevents the promotion registry from becoming corrupted with a bad start or end date.
JR44936 Updates the shopping cart display order totals section to accurately show totals without considering shipping.
JR44999 Adds a configuration that allows customers to remove invalid unicode characters from their marketing content.
SE50648 Prevents the sales catalog from changing to the master catalog after promotion refresh. This issue occurs after sales catalog categories are specified in the category exclusion list during promotion creation in the Management Center.
JR45152 Improves the performance of generating and publishing large batches of promotion codes (in the millions), especially in workspaces.
WebSphere Commerce Version 7.0.0.7Member and Session Management JR39011 Fixes an issue that causes shoppers to encounter blank pages after the merchant key is changed. When this problem occurs, logs show a NullPointerException associated with WCCookieUserSession.decipherTokens.
JR44801 (has dependencies on JR42439, JR43430, JR43306, and JR41596) Prevents an issue that occurs when a customer service representative wants to run subsequent commands in the same session under a specified customer's identity. The interim fix addresses an issue that causes the identity to be lost in subsequent commands.
JR42159 Prevents the UserRegistrationAdd command from creating unnecessary records in database.
JR42281 Improves performance of the ListUsersInMemberGroupCmd command when there are many records in the MEMBER database table.
JR42771 Security fix:

Fixes vulnerability in WebSphere Commerce related to personalization IDs.

JR43882 Ensures that the OrgEntityAddCmdImpl class calls preOrgEntityAddCmd instead of preOrgEntityUpdateCmd so that different customizations can be applied whether you perform OrgEntityAddCmdImpl or OrgEntityUpdateCmdImpl.
JR43889 (also includes JR43806) Resolves a problem that causes a generic user's personalization ID to persist after logon.
JR44373 Resolves a null pointer exception that is thrown during session timeout.
JR44011 Addresses a content parsing exception that occurs when the WC_USERACTIVITY cookie is incomplete in the user request.
JR44427 Allows the WC_PERSISTENT cookie to be cleared when a user logs off or ends their browser session.
JR45513 Improve the handling of Ajax requests so that the "rememberMe" status is respected and customers can avoid unnecessary logons.
LI77112 Resolves an invalid cookie error on Firefox that occurs when a user selects the Show my windows and tabs from last time option.
WebSphere Commerce Version 7.0.0.7Messaging and Integration (including Sterling integration) JR36472 Addresses a problem that causes WebSphere Commerce V7 to not send emails (for example, a password reset email) in a web 2.0 enabled sample store (such as Madisons) after a WebSphere Application Server upgrade to 7.0.0.9.
JR44499 Fixes an issue in which the inventory cache expiry threshold does not work as expected because of int overflow.
JR45040 (has dependency on JR43703) Prevents an InventoryApplicationException when you use the GetInventoryAvailability service with DM inventory.
JR42202 Prevents image requests that are used to track the opening of an email from being rendered as "missing image" icons in some email clients.
JR43703 Provides fixes and enhancements to the WebSphere Commerce integration with Sterling Order Management solution.
JR43430 Recommended fix:

Prevents transactions from becoming corrupted if the genericapplicationerrorxml.jsp file is missing.
JR43900 Fixes an issue where ComposeOrderCmdImpl does not check for null AddressLine before it composes an order transfer message.
JR44301 Fixes an issue where the ShowPerson component service does not return profile type.
JR44891 Addresses an issue that causes product images to be "null" in marketing emails that are sent by WebSphere Commerce when extended sites are used.
JR45182 (has dependency on JR41894, JR44130, JR41022, and JR42202) Provides a new method so that you can set the Sender email address for marketing email.
LI76698 Addresses a NoSuchElementException that is received randomly during the handling of a web service response message
WebSphere Commerce Version 7.0.0.7Orders, Payments, and Inventory IV24358 Security fix:

On WebSphere Commerce Accelerator, if the customer clicks List Extended Data for an order, then search for an order, check the order, click the "Extended Data" tab or "Change Extended Data", account number is not masked.

JR48834 Response time degradation when the same item is purchased concurrently by many shoppers.
JR42074 Ensures that extra parameters added to the order tag are generated after they are added to the order page
JR45040 (has dependency on JR43703) Prevents an InventoryApplicationException when using the GetInventoryAvailability service with DOM inventory
JR43642 Makes the getRMAAB() method public instead of private so that you can extend it.
JR45188 Enables you to configure the custom access profile so that you can get a catalog entry when you call InventorySync service.
JR45220 (includes JR43804, JR43703, JR44391, JR43900, and JR42809) Ensures that XML generated by order services is mapped correctly.
JR44499 Fixes an issue in which the inventory cache expiry threshold does not work as expected because of int overflow.
JR44630 (has dependency on JR42285 JR41404 and JR41229) Recommended fix: Performance and Stability

Addresses an issue that causes unnecessary attribute values to be retrieved to display catalog entries in the shopping cart. If there are many attribute values, this issue affects the performance of OrderItemDisplay.
JR42902 Prevents a java.lang.NullPointerException from being thrown in PaymentEventListenerImpl.java during a refund.
JR42939 (also includes APAR LI76593) Restores a coupon for an order when a customer service representative cancels the order.
JR43972 Fixes an issue that causes a coupon that is applied to an order to go missing after a customer service representative edits the order from WebSphere Commerce Accelerator and clicks the Adjustment tab or the Payment tab. This issue causes the order amount to be incorrect.
JR44165 Prevents OrderAdjustmentDataBean from throwing an ObjectNotFoundException for promotions without a description.
JR44391 Introduces two new logical data caches to address an issue that causes the shipping mode and calculation usage information to be repeatedly queried from the database, even though this information rarely changes.
JR45555 Ensures that stackable shipping promotions are applied from highest priority to lowest priority.
JR45645 Ensures that the active organization ID is set correctly in the entitlement context so that the correct contracts are retrieved during order processing.
JR47098 Improves response time for shoppers who are concurrently purchasing the same item.
WebSphere Commerce Version 7.0.0.7Runtime IV11834 Improves performance by allowing SQL queries that are related to generic users to be cached.
IV31206 Enhances the WebSphere Commerce runtime framework to respect the storeId when the runtime framework looks up a BOD command to run.
JR45856 Optimizes the DBClean utility DELETE statement for DB2 databases.
JR43775 Prevents database connection deadlock issues that occur when blocked threads hold all the JDBC connections available.
JR44694 Recommended fix: Performance and Stability

Improves performance of cascaded deletes on some WebSphere Commerce tables.
JR44882 (has dependency on LI76488 JR38740 JR38932 JR39312 JR39838 JR39857 JR40248 JR41545 JR42142 and JR44935) Recommended fix: Performance and Stability

Improves performance by keeping user-related data from being placed in the baseCache servlet cache instance.
IV27234 Updates the scheduler command for promoting the managed file into the WebSphere Commerce EAR. If the scheduler detects managed files with missing content, it records information about the files into trace, ignores them, and continues. This fix ensures that all the remaining managed files are processed.
JR44801 (has dependencies on JR42439, JR43430, JR43306, and JR41596) Prevents an issue that occurs when a customer service representative wants to run subsequent commands in the same session under a specified customer's identity. The interim fix addresses an issue that causes the identity to be lost in subsequent commands.
JR41953 Performance and Stability fix:

Refreshing the registry causes the registry size to become unlimited, which can cause a higher than expected memory usage and potentially slower response times wh

en you use the registry.

JR42286 Prevents a java.util.regex.PatternSyntaxException that can occur in the com.ibm.commerce.server.HttpRequestWrapper#getRequestUrl() method when the URL contains brackets.
JR42557 Performance and Stability fix:

Avoid high memory usage for GET service requests that return large result sets.

JR42770 Corrects a REST service security vulnerability where the shopper account login retry limit is not respected.
JR43306 Updates code for handling transactions to ensure that, during rollback, the global transaction is rolled back even if TransactionCache.transactionNotify fails with an exception.
JR43375 (includes JR43306) Addresses a problem in which WebSphere Commerce application server threads might hang or time out if the JDBC connection pool is empty.
JR43804 (includes JR42809, JR42507, JR41832, JR41551, and JR41545) Performance and Stability fix:

Fixes an issue in which you try to implement the memoryCacheSizeInMB for data cache, but you see a -1 cache monitor instead of expected 5.
JR44528 Security fix:

Fixes a security vulnerability in the web Services framework that makes WebSphere Commerce users susceptible to a potential Denial of Service attack.

JR46641 Resolves an issue with the wcf:url tag failing to add the HTTPS protocol prefix to the URL for Struts actions with the https property set to true.
JR44785 Ensures that the StateProvinceAccessBean is cached in the StateProvinceCache data cache if retrieved by findByLanguageIdAndState.
JR44833 Enables you to send a marketing email for an abandoned shopping cart to a guest user.
JR45509 Fixes an issue that causes a NullPointerException to be thrown when a BOD response has a null Description element.
SE53160 Security fix:

Fixes a security vulnerability in WebSphere Commerce that might allow disclosure of user personal data.
WebSphere Commerce Version 7.0.0.7Sales Center JR43729 Addresses performance issues when you view order item details in the Sales Center.
WebSphere Commerce Version 7.0.0.7Search JR42126
Note: The fixes for APAR JR41935 and APAR JR41270 must both be installed for the fixes to work. The fix for JR41935 is included in Feature Pack 5.
 Addresses an SEO dependency on Solr. Prevents requests that contain the search profile from being routed to the search mediator framework when search based navigation is disabled.
JR42808 Recommended performance and stability fix:

Improves search results by reducing the number of queries to the database that are related to contracts.
JR43641 Ensures that single quotation marks are properly escaped in the search expression and do not cause the XPath parser to fail.
JR44287 Modifies the search filter so that it can find a product name or description in the store default language when the catalog entry name or description for the product is missing for the language ID in the current context.
LI77047 Recommended fix:

Fixes an issue in which CategoryDataBean prefetching of item catalog entries can result in an out of memory condition.
JR54959 Fixes an error where the store's total product count is displayed when the search term or manufacturer name is empty in the store's URL.
WebSphere Commerce Version 7.0.0.7Stores and Mobile JR42480 Defines the maxSKUs variable in several JSPs because the missing variable definitions prevented orders from being checked out in Elite extended site stores on a WebSphere Commerce 7.0.0.5 environment.
JR42569 Recommended fix:

Resolves a ClassCastException that occurs when you run SitemapGenerate with the catalogId parameter when FEP3 or FEP4 Search Engine Optimization is enabled.
JR43062 Enables the SitemapGenerate scheduler command implementation to accept the input parameter host name and for the generated URLs to contain the specified value of the host name.
JR43338 Corrects an issue where the wcf:out tag does not output the correct values if it is used with escape="false".
JR43404 Modifies the wcf:url tag to work the same as the c:url with regards to the var and scope attributes.
JR43817 (also includes JR43457) Enhances the URLMapper class to handle cases where the context root path was altered from the default.
JR43977 Allows store preview of the starter stores to work properly on environments where SSL Accelerator is set up to use regular 80 and 443 ports for the tools.
JR44349 Resolves quick publish failure that is caused by an OracleXAException exception.
JR44872 (has dependencies on JR44801 and JR43430) Recommended fix

Ensures that SEO URLs correctly populate the catalog Id in the context variables after you upgrade to Fix Pack 6.
JR45075 Allows you to customize the configuration registry file without updating the default file.
JR45314 Changes store locator search so that it uses a comma to separate search terms instead of a single quotation mark. This change prevents any incorrect conversions when you customize a JSP with multiple search terms.
JR45572 Ensures that editing the billing address on the Shipping and Billing Page, does not incorrectly update the shipping address, too.

Fix Pack 6 fixes

The following fixes are included in Fix Pack 6.
Note: The fixes that are included in Fix Pack 6 are not divided into separate tables for critical fixes and additional fixes. Instead, they are contained in a single table that sorts the fixes by category. The Description column indicates if a particular fix is recommended, if it improves performance and stability, or if it improves security.
Category APAR Description
WebSphere Commerce Version 7.0.0.6Analytics JR40281 Fixes an issue where the cm:cart tag for IBM Digital Analytics, formerly known as Coremetrics Analytics sends only the discounted order price.
JR41256 Prevents a malformed query string from causing a NoSuchElement exception to be thrown from UserTrafficData.
JR42074 Fixes an issue when you work with IBM Digital Analytics where extra parameters added to the order tag are not generated after they are added to the order page.
WebSphere Commerce Version 7.0.0.6Authoring and Staging JR39732 Prevents a DuplicateKeyException when you publish a WebSphere Commerce workspace task for the table PX_PROMOCD or PX_CDPROMO.
JR39925 Provides configuration parameters to reduce latency during publication of workspaces using the "Quick Publish" feature.
JR42158 Improves performance issues that are related to the stagingprop utility.
JR40330 Catches database connection exceptions in the stagingprop utility.
JR40823 Allows you to prevent the STAGLOG table from locking during invocation of the stagingprop utility to allow additional updates to the staging data.
JR41577 Performance and Stability fix:

Fixes an issue where updates to change history data cause performance decline when committing large size of data in workspace.

JR41707 Checks if the catalog is created as part of a workspace task and links the catalog group without using the Scheduler job.
WebSphere Commerce Version 7.0.0.6Catalog, Assets, Contracts, and Pricing IV09872 Performance and Stability fix:

Prevents excessive logging from being printed to the SystemOut.log from the CategoryDataBean.
JR39685 Ensures that deleted bundles do not reappear in bundles and kits page.
JR39946 Performance and Stability fix:

Improves performance and scalability when you have many attachments in the WebSphere Commerce Management Center Assets tool.
JR39917 Fixes an issue where the shipping addresses selection box shows all types of addresses unexpectedly in the Account/Contract creation wizard in WebSphere Commerce Accelerator.
JR40825 Ensures that if a product code is modified in the Management Center, both CATENTRY.PARTNUMBER and BASEITEM.PARTNUMBER are updated with the new value.
JR40868 Changes the getCatentryPublishedClause in class EntitledCatalogEntriesSQLComposer from private to protected, so that it can be customized.
JR41010 Fixes a problem where uploading the eSites Price List fails to resolve the ID for the CATENTRY table.
JR41640 Allows you to directly move a SKU from one parent product to another even if the SKU has defining attributes from the Attribute Dictionary.
JR42218 Resolves a problem where an 'ORA-01722: invalid number' exception might be thrown when deleting SEO enabled catalog entries or catalog groups from an Oracle database using Management Center.
JR42285 Fixes a problem that causes the GetCatalogEntry web service to not return the value of the unique identifier column ATTRVAL.IDENTIFIER
LI76602 Provides an option to allow the catalog import summary report to show the details of errors at the top of the summary report.
SE48270 Assigns the ownership of a contract attachment to an ORGENTITY rather than a USER.
SE49856 Resolves errors that are thrown when adding product to linked sales category on iSeries.
WebSphere Commerce Version 7.0.0.6Data Load and other loading tools JR39916 Fixes an issue where massload fails if the MASTERCATALOG flag in the STORECAT (STORECAT.MASTERCATALOG) table is null.
JR39998 Prevents a maximum open cursors error (ORA-0100) from occurring when using Data Load to load dictionary attributes in WebSphere Commerce Feature Pack 2.
JR40751 Solves a problem that causes an attribute that is loaded via Data Load in multiple languages to be added to the ATTR table only in the first language specified.
JR41338 Ensures that the Data Load script uses the .jar from the correct directory so that APAR changes are picked up.
JR41365 Resolves a password email notification problem when migrating shoppers to WebSphere Commerce using data load
JR41495 Allows you to load more than 254 characters into the VALUE column of the ATTRVALDESC.VALUE table. Prevents a failure in the Data Load utility caused by a SQL exception.
JR41930 (includes JR41495) Allows you to load more than 254 characters into the VALUE column of the ATTRVALDESC.VALUE table. Prevents a failure in the Data Load utility caused by a SQL exception.
JR42667 Recommended fix:

Adds a flag to turn of validation of allowed values in Attribute Dictionary.
LI76602 Provides an option to allow the catalog import summary report to show the details of errors at the top of the summary report.
WebSphere Commerce Version 7.0.0.6Installation, Configuration, Deployment, and Migration JR40607 Updates the database migration code base to properly set the integrity of all tables in "integrity pending" status.
JR41176 Prevents failure of database schema creation on DB2 V9.7 Fix Pack 5 (or later) during installation or upgrade to WebSphere Commerce V7.0.0.2 (or later).
JR41594 Solves a problem that causes WebSphere Commerce database migration check to fail with Warning messages
JR39577 Prevents database migration from failing when the operating system locale is set to a locale other than US_en in WebSphere Commerce.
WebSphere Commerce Version 7.0.0.6Maintenance JR42037 Prevents the WebSphere Commerce DBClean utility from generating empty script files.
WebSphere Commerce Version 7.0.0.6Marketing and Promotions IV08614 Ensures that promotion coupons are issued to customers when the promotion conditions are met.
IV13932 Fixes a problem that prevents shoppers from applying a public promotion code when there are other promotions that are defined with similar public codes.
LI76485 (also includes APAR JR38740 and LI75521) Recommended fix: Performance and Stability

Automates the refresh of the promotion and marketing registries, addressing an issue that could lead to obsolete marketing and promotion data from being displayed to shoppers.
JR39510 The promotion argument that is generated on order completion is incorrect when there are multiple adjustments.
JR39735 Fixes a problem with the default content access control in the WebSphere Commerce Management Center Marketing tool
JR40671 Performance and Stability fix:

Allows you to disable the collection of marketing statistics in WebSphere Commerce.
JR40672 Ensures that if a dialog activity that sends a welcome email to the new registered customer is defined, and if the new user browses the store, adds something to the shopping cart, and registers, then a welcome email is sent to the correct user. Fixes a problem where the welcome email was sent to the previously registered user.
JR41009 Ensures that free gift promotions using an AddStrategy of 0 (Add if needed) or 2 (Never add) are calculated correctly.
JR41022 Provides a way for the WebSphere Commerce marketing dialog activities to pass the order ID to the email template JSP when the Send Message action is started.
JR41101 Ensures that the promotion "Buy X, get additional X at % off" is applied only to the lowest priced items.
JR41269 Fixes a problem where the storefront can display incorrect discounts for promotions, when different rounding methods or rounding multiples are used in the CURFORMAT table.
JR41551 Performance and Stability fix:

Fixes a problem where the Marketing registry may not be in sync in a clustered environment. Removes the check if an object is in the cache before issuing the DynaCache invalidation in the method MarketingEngineCache.removeElement.
JR41832 Allows you to configure the time period for which WebSphere Commerce remembers the recently browsed products or categories of a shopper.
JR42107 Changes the private methods in the ProcessPromotionActivateActionCmdImpl class to protected to allow for easier implementation of customizations.
JR42205 Performance and Stability fix:

Improves performance of CalculationCodeListDataBean.
JR42311 Addresses an issue where the Quick Info dialog does not show properly when WebSphere Commerce is using an Oracle database and the shopper belongs to more than 1000 member groups.
LI76593 Addresses an issue where a coupon promotion with a future date does not apply when tested in future preview mode.
SE49279 Performance and Stability fix:

Improves performance that is related to create or update of the PX_PROMOARG database table.
WebSphere Commerce Version 7.0.0.6Member and Session Management IV12334 Performance and Stability fix:

Fixes a problem where assigning member groups to a user in the Organization Administration Console can last several minutes and, in some cases, crash the browser.

JR39838 Fixes a problem where exceptions are thrown when generic/guest users are checked against Customer Segments that use the "Job function" condition.
JR40248 Performance and Stability fix:

Ensures that no invalidation messages for the Business Context Service are issued when the ContextDataSerValueCmdImpl class is not cached.
JR40513 Performance and Stability fix:

Fixes an issue where the WebSphere Commerce organizational administration console gives an OutOfMemory error when "select members" is chosen for a large member group with many addresses in ADDRESS table.
JR40895 Fixes issues when accessing WebSphere Commerce with Single Sign on Enabled.
JR41007 Ensures the ADDRESS column in the Registered customers report reports the correct data when the address value is present in the database.
JR41633 Resolves an issue where shoppers are unable to log on due to a DuplicateKeyException when inserting data into the CTXMGMT table.
LI76488 Performance and Stability fix:

Fixes a problem that prevents database inserts into the CTXMGMT table when the runAs userId is -1002 to avoid ITL Oracle Lock contention.
WebSphere Commerce Version 7.0.0.6Messaging and Integration (including Sterling integration) JR41212 Provides the flexibility to send emails in MimeMultipart format.
JR42568 Recommended fix:

Prevents a stop or intermittent delay situation from occurring when processing inbound WebSphere MQ messages using the Parallel WebSphere MQ Listener for WebSphere Commerce.
LI76591 Adds an WebSphere MQ error code to WebSphere Commerce logs when an MQException occurs.
WebSphere Commerce Version 7.0.0.6Orders, Payments, and Inventory JR41187 Fixes a problem where configuring the OptimisticLockingSelectForUpdate flag on INVENTORY table as disabled leads to incorrect code path
JR41283 NumberFormatException occurs when converting key value from String to BigInt type and persisting it to PPCEXTDATA table.
JR41313 Allows dynamic kits that contain a back-ordered component to be added to a shopper's cart.
JR41685 Prevents a ClassCastException from being thrown while executing a GetOrder service request where the payment protocol data is stored in a non-String type.
JR41856

Security fix:

Prevents an ORA-01795 error when deleting taxes from an order in an Oracle environment where there are more than 1000 tax categories.
JR42108 Ensures the correct inventory status appears on the 'Order Summary' page.
JR39850 Ensures that the email order functionality in WebSphere Commerce Accelerator sends the email for guest order to the recipient specified.
WebSphere Commerce Version 7.0.0.6Programming Framework JR41992 Prevents a NullPointerException when using the DSL wizard on WebSphere Commerce Toolkit.
WebSphere Commerce Version 7.0.0.6Runtime JR40894 Fixes an issue where custom code that uses a 'SELECT FOR UPDATE' SQL query with JDBCQueryHelper results in error SQLCODE=-228 after you install WebSphere Commerce 7.0.0.3.
JR42758 Recommended fix: Performance and Stability

Improves performance of the ActivityCleanUp Scheduler Job by reducing database contention.
JR42537 Corrects the EventProcessor command to allow processing of more than 5000 rows at a time.
JR42142 Adds capability to use the WebSphere Commerce DynaCacheInvalidation scheduler job to send invalidation ID strings to customer defined servlet cache instances.
JR43173 Addresses a problem that occurs when more than one instance of the RaiseECEvent scheduler job is running. The second job frequently ends before it processes all eligible events. The fix limits the throughput to the number of events that can be processed by a single instance.
JR41229 Performance and Stability fix:

Resolves problem that causes the catalog SOA storefront service to occasionally return wrong data.
JR41337 Prevents the scheduler from timing out when the SCHACTIVE table is locked for an extended period of time.
JR41350 Performance and Stability fix:

Corrects an intermittent ConcurrentModificationException when refreshing Struts Registry
JR41822 Recommended fix: Performance and Stability

Prevents memory leaks in the Double-Click Handler functions of WebSphere Commerce.
JR42439 Prevents a Null Pointer Exception from occurring when a third-party cookie is null.
JR42537 (includes JR40515) Recommended fix: Performance and Stability

Provides optimization of the EventProcessor. including the ability to process up to 500,000 rows from the BUSEVENT table at a time.
JR42665 Recommended fix:

Corrects issues with decimal parsing returning incorrect results.
IV11834 Performance and Stability fix:

Reduces the number of queries run related to the generic user cache.
LI76427 Performance and Stability fix:

Fixes a problem where a large CalculationCodeListDataBean transaction cache can cause out of memory condition.
JR42638 Performance and Stability fix:

Resolves a memory leak that causes ThreadLocalFoundationProxy to build up many objects.
WebSphere Commerce Version 7.0.0.6Sales Center JR37238 Performance and Stability fix:

Provides a way to filter non-published items.
JR39551 Prevents infinite recursive loop in ShowElectronicCatalog.populateSearchResult() when WebSphere Commerce catalog contains multilevel circular merchandising associations.
JR39856 Allows you to assign a tickler to an unregistered/generic user.
JR41545 Disables Sales Center custom cache.
WebSphere Commerce Version 7.0.0.6Search IV16059
Note: The fix for IV16059 is associated with the fixes for IV16050 and JR43641. Install the fixes in the following order:
  1. IV16059
  2. IV16050
  3. JR43641
 Adds support for search queries to have multiple selected facets.
JR40305 Provides the second part of a cumulative service interim fix for WebSphere Commerce Search feature in V7 Feature Pack 2
JR41115 Performance and Stability fix:

Optimizes product level entitlement check to avoid hitting 'too many Boolean clauses' error.
JR41404 Performance and Stability fix:

Prevents excessive product entitlement searches from being performed against the database for eSites and B2B stores, which would result in performance degradation.
JR46747 Resolves performance degradation for searches that are performed on many entitlements.
JR45723 Allows for search rules to use the ampersand character.
WebSphere Commerce Version 7.0.0.6Stores and Mobile JR40578 Security fix

Addresses a security vulnerability with Dojo 1.0.2 and Dojo 1.3.1, which are used in WebSphere V6 and WebSphere V7.
JR40734 Provides the ability to send sitemap XML files to Stores.war.
JR40822 Resolves a problem where entering special characters in the Logon form results in odd characters being returned if logon fails.
JR41270
Note: The fixes for APAR JR41299 and APAR JR41270 must both be installed for the fixes to work. The fix for JR41299 is included in Feature Pack 5.
 Allows guest shoppers to complete registration in the MayUJoy store.
JR42140 Prevents "ORA-01795: maximum number of expressions in a list is 1000" Oracle error which might occur when fetching stores if there are more than 1000.

Critical fixes included in Fix Pack 5

The following fixes included in Fix Pack 5 are considered to be critical fixes for customers. Applying Fix Pack 5 fixes these critical issues.
APAR Fix pack number Description
IV04764 7.0.0.5 Improves the sorting algorithm for determining the promotion evaluation sequence.
JR40912 7.0.0.5 Removes the FileNotFoundException: WCDEDIR\instances\wcs_instances error when enabling feature pack on toolkit.

Additional Fix Pack 5 fixes

The following fixes are also included in Fix Pack 5.
APAR Fix pack number Description
JR39312 7.0.0.5 Adds capability to use the WebSphere Commerce DynaCacheInvalidation scheduler job to send invalidation ID strings to customer defined DistributedMap object cache instances.
JR40061 7.0.0.5 Allows concurrent execution of specified commands by the same user.
JR40243 7.0.0.5 Corrects the item price when the useKitItems=true attribute is used.
JR40334 7.0.0.5 Performance and Stability fix:

Explicitly closes database connections, so that free handles are returned to the pool faster to meet the demands for the next set of database connection requests.
JR40344 7.0.0.5 Makes the applyChoice method public within the DefaultChoiceOfFreeGiftAdjustment class.
JR40347 7.0.0.5 Enables Oracle JDBC batch for LOB-type columns, such as BLOB or CLOB columns, on Oracle databases.
JR40366 7.0.0.5 Resolves issue where Migrate Promotions Utility fails on special characters.
JR40368 7.0.0.5 Allows the removal of an LTPA token when concurrent users are on the system using the same ID.
JR40388 7.0.0.5 Allows the promotions engine to return multiple parent products for an item.
JR40416 7.0.0.5 Allows additional views to be exempted from redirecting when the users's password is invalid.
JR40606 7.0.0.5 Prevents a NullPointer exception from occurring when the User-Agent header from the http request is null.
JR40719 7.0.0.5 Performance and Stability fix:

Improves performance during publication of workspaces using the "Quick Publish" feature.
JR40912 7.0.0.5 Removes the FileNotFoundException: WCDEDIR\instances\wcs_instances error when enabling feature pack on toolkit.
JR41008 7.0.0.5 Corrects instance creation errors on Solaris with WebSphere Application Server 7.0.0.19.
LI76354 7.0.0.5 Allows you to update the allowed value of a defining attribute for products with more than 1000 SKU when working with Oracle database.
LI76405 7.0.0.5 Corrects a class cast exception during fix pack updates to the database.

Critical fixes included in Fix Pack 4

The following fixes included in Fix Pack 4 are considered to be critical fixes for customers. Applying Fix Pack 4 fixes these critical issues.
APAR Fix pack number Description
JR39837 7.0.0.4 Improves the ProcessEvent Job to process any events faster.
JR40293 7.0.0.4 Extends Cross-site Scripting protection to consider more scenarios
JR40420 7.0.0.4 Resolves a potential security vulnerability with Web Services that use Activity Token authentication
LI76855 7.0.0.4 Fixes an issue where an SMTP connection is lost or times out, due to the caching of the connection. When this situation occurs, WebSphere Commerce attempts to use the invalid connection and fails to send emails.

Additional Fix Pack 4 fixes

The following fixes are also included in Fix Pack 4.
APAR Fix pack number Description
IV02122 7.0.0.4 Resolves the Out of Memory errors that occur if you view product defining attributes in WebSphere Commerce Accelerator using Internet Explorer 8.
JR39580 7.0.0.4 Enables enhanced tracing facilities for the stagingprop utility
JR39613 7.0.0.4 Allows the stagingprop utility to continue to process records in the event of a unique constraint failure
JR39671 7.0.0.4 Updates elements named sequence to displaySequence in certain XSDs to prevent compilation errors.
JR40019 7.0.0.4 Enhances the category level promotion SQL query launched when viewing shopping cart.
JR40063 7.0.0.4 Corrects an issue that causes the ScheduledContentManagedFileEARUpdate job to fail if the Deployment Manager is down, even when the Job is configured for FTP or file system copy.
JR40130 7.0.0.4 Prevents an SQLSTATE=23503 error when order records are persisted using the CatalogEntry service to update the Attribute Dictionary.
JR40131 7.0.0.4 Implements a scheduled job to find and delete temporary empty files that are left after deploying static content to the web server.
JR40155 7.0.0.4 Prevents StackOverflowError when processing a TypedProperty containing malformed response property parameters
JR40182 7.0.0.4 Fixes a problem where the wcf:url tag fails to add the HTTPS protocol prefix to the URL for Struts actions with the https property set to true.
JR40333 7.0.0.4 Addresses search-related database lock timeouts under high volume stress
JR40418 7.0.0.4 Adds the logic to record the caller in change history when doing an upload task in the Management Center.
JR40422 7.0.0.4 Allows the customer to add customized type for change history
JR40515 7.0.0.4 Delivers performance improvements for the ECEvent processing framework (BUSEVENT table).
Important: Superseded by JR42537.
JR40600 7.0.0.4 Provides the fix pack component of JR40484. which ensures that Store configuration files do not get removed from the WebSphere Commerce Developer workspace after you run resetstores.bat
SE48281 7.0.0.4 Corrects the Forgot Password functionality when WebSphere Commerce is configured with LDAP using a customized DN structure

Critical fixes included in Fix Pack 3

The following fixes included in Fix Pack 3 are considered to be critical fixes for customers. Applying Fix Pack 3 fixes these critical issues.
APAR Fix pack number Description
JR39313 7.0.0.3 Prevents locking while fetching inventory via the FetchInventoryAvailabilityCmdImpl.

Additional Fix Pack 3 fixes

The following fixes are also included in Fix Pack 3.
APAR Fix pack number Description
IV00450 7.0.0.3 Includes the creation of the WC_AUTHENTICATION cookie for a generic user.
IZ75312 7.0.0.3 Resolves UserSearchBean.findCollaborativeMembers() performance issue.
IZ86794 7.0.0.3 Corrects issue of auto-added items being removed from the order when the WebSphere Commerce promotion engine is started.
IZ94274 7.0.0.3 Adds a function that scans for any active activities with an end date that has passed and set them to deactivated.
IZ95908 7.0.0.3 Improves the performance of query for attributes of a category entry.
IZ99011 7.0.0.3 Prevents a memory leak where thousands of DDThreadContext objects are found in the heap.
JR30124 7.0.0.3 Limits the number of price policies loaded into memory.
JR30589 7.0.0.3 Modifies the query findAccountIdByUserIdStoreIdByOrganizationSQLForOL to change OR + SUBSET to UNION. This improves the performance on the customer's instance. This is a custom fix for DB2 only as this is the only database that has been tested.
JR38049 7.0.0.3 Resolves problem where Total Order price was calculated incorrectly due to the incorrect application of shipping adjustments, which caused unexpected marketing behaviors.
JR38057 7.0.0.3 Resolves an infinite recursive loop situation in the ShowElectronicCatalog.populateSearchResult code flow.
JR38068 7.0.0.3 Adds additional tracing to marketing campaign initiatives logic.
JR38081 7.0.0.3 Corrects the PaymentInstructionStatusType element in the Order XSD to allow values of Pending or Success.
JR38217 7.0.0.3 Addresses performance problems caused by the ActivityCleanUp job issuing explicit cache invalidations.
JR38302 7.0.0.3 Ensures that the preview clock matches the activity clock to allow future web activities to be viewed properly in Store Preview mode.
JR38337 7.0.0.3 Resolves the problem where returned order amount is not correct with VAT configured.
JR38369 7.0.0.3 Prevents anomalistic behavior when uploading and replacing file attachments in WebSphere Commerce Accelerator.
JR38437 7.0.0.3 Avoids the OptimisticUpdateFailureException caused by MigrateUserEntriesCmdImpl command when using SetInterestItemList command.
JR38451 7.0.0.3 Prevents that changing sequence number in MC deletes records from CATGPENREL.
JR38483 7.0.0.3 Adds new configuration to control store-wide promotion handling at run time.
JR38519 7.0.0.3 Changes the second generic error message in MessageMappingCmdImpl.
JR38605 7.0.0.3 Enables showing shopAction tags for all the items in the kit.
JR38616 7.0.0.3 Addresses the problem When trying to update a catalog entry attribute to assign the value to be blank, an error is given.
JR38658 7.0.0.3 Resolves cross site scripting security loopholes in the Madisons mobile store.
JR38678 7.0.0.3 Addresses the issue When calling the CatalogEntry change service, you cannot identify an attribute by only the attribute name.
JR38722 7.0.0.3 Resolves the issue that the return code of stagingprop utility is always zero no matter whether the utility is successful or fails.
JR38736 7.0.0.3 Resolves the problem where Dialog activity repeatable flag is not working.
JR38738 7.0.0.3 A new overridable flag useHttpForLinks enables HTTP when generating links in email activities. The default value is false (HTTPS).
JR38740 7.0.0.3 Uses CACHEIVL to clear Promotion Registries.
JR38767 7.0.0.3 Corrects the issue where wish list links on the mobile store redirect to the desktop store.
JR38862 7.0.0.3 Corrects issue where the value passed to the Order Total in the Shop Action 9 tag is incorrect as it is missing the decimal point.
JR38866 7.0.0.3 Eliminates errors caused by the Windows path limitation during EJB deployment using WebSphere Commerce Build and Deploy tooling.
JR38880 7.0.0.3 Prevents the locking error that can occur when using the Back button during a checkout flow.
JR38884 7.0.0.3 Resolves NumberFormatException thrown by Cart and Product tags.
JR38932 7.0.0.3 Removes the possibility of the business context cache entry of one thread being shared with another.
JR38942 7.0.0.3 Allows all FEP2 updates to be completed successfully a second time following a database type change via setdbtype.bat.
JR38958 7.0.0.3 Allows stagingprop to use JDBC Batch with tables that contain CLOBs in DB2.
JR39009 7.0.0.3 Corrects the behavior of SitemapGenerateCmd when validation=false is set.
JR39021 7.0.0.3 Provides the ability to have the catalog mediator create CATGPENREL associations to sales catalogs.
JR39031 7.0.0.3 Corrects ResolveSKUHelper behavior when the first attribute value is a number.
JR39051 7.0.0.3 Allows Admin console publish menu to see Madisons-FEP.sar store archive.
JR39054 7.0.0.3 Resolves duplicate keys exception encountered when publishing a workspace task with the table CMFILE.
JR39099 7.0.0.3 Resolves the issue where SyncOrder & SyncInventory error responses do not confirm to their XSDs.
JR39100 7.0.0.3 Avoids duplicate keys exception encountered when publishing workspace tables SHPMODCLCD and CATENCALCD.
JR39112 7.0.0.3 Resolves the class path issue related to the order of the jar filrs being loaded.
JR39174 7.0.0.3 Adds missing B2B features when publish Elite-FEP.sar.
JR39187 7.0.0.3 Adds a promotion type: Buy catalog entries from category X, get a percentage off catalog entry Y.
JR39188 7.0.0.3 Resolves the problem where an invalid ATTRVALUE causes dataload.sh to not load records into the database.
JR39209 7.0.0.3 Resolves incorrect billing address update after editing billing then shipping address on Shipping & Billing Method page.
JR39221 7.0.0.3 Enables entire content of the file wcs.stage.foundation.xml to be loaded in Production DB during feature enablement.
JR39222 7.0.0.3 Prevents a ClassCastException while tracing RequestProperty data for NVPs with non-String keys.
JR39223 7.0.0.3 Prints the SQL that causes the exception on the workspace administration console when taskgroup publishing fails due to SQLException.
JR39233 7.0.0.3 Resolves NullPointerException when ChangeCatalogEntry BOD is sent with action specified as "Delete" followed by an "Add".
JR39248 7.0.0.3 Resolves the issue that coupon cannot be restored when an empty order gets canceled.
JR39256 7.0.0.3 Enables taxes taken into account in store when configured in Catalog Asset Store.
JR39286 7.0.0.3 Resolves the issue when interest item lists are merged, left over entries are found in the tables.
JR39310 7.0.0.3 Addresses issue where the UrlTag honors only the ports of the SSL Accelerator configuration, but not the scheme of the inbound request for Ajax requests.
JR39319 7.0.0.3 Resolves the problem where revenue is not captured in experiment after logon duplicate.
JR39321 7.0.0.3 Resolves an exception thrown when a promotion code is added in the shopping cart.
JR39384 7.0.0.3 Resolves the hard-coded (configurable) limit when handling a number of items in TransferOrder.
JR39394 7.0.0.3 Addresses issues with configuring federated repositories with SSL enabled in a WebSphere Application Server federated environment.
JR39408 7.0.0.3 Avoids infinite recursion with incorrect access bean primary key information.
JR39467 7.0.0.3 Addresses the issue of Oracle throwing "ORA-01000: maximum open cursors exceeded" error during stagingprop.
JR39484 7.0.0.3 Updates the handling of free gift promotions in the Madison sample store when there is 0 inventory for the free gift.
JR39498 7.0.0.3 Excludes all customers when using an empty customer segment.
JR39520 7.0.0.3 Addresses the issue of workspace approval failing if customer segment is deleted.
JR39540 7.0.0.3 Resolves the problem that out of memory can occur when WCSEvent queue gets too large.
JR39544 7.0.0.3 Addresses that the DMGR SSL cert is not found after LDAP is enabled.
JR39578 7.0.0.3 Resolves the issue when IBM Digital Analytics order tag might return subtotal of an order as $0.0.
JR39770 7.0.0.3 Resolves the problem with the XMLFileReader class taking up unnecessary heap space.
JR41749 7.0.0.3 Resolves a problem with incorrect mapping when an order is transferred between WebSphere Commerce and Sterling Order Management.
JR42159 7.0.0.3 Prevents the UserRegistrationAdd command from creating unnecessary records in database.
JR42741 7.0.0.3 Resolves the SAXParseException when running the versionInfo command with the -maintenancePackages parameter.
LI75354 7.0.0.3 Enhances the CatalogEntry Finder query so that it uses parameterized markers.
LI75369 7.0.0.3 Fixes the data synch issue WebSphere Commerce and LDAP when a null value is updating using LDAP.
LI75500 7.0.0.3 Resolves performance issue in Sales Center when retrieving products that has associated with large # of published and unpublished items in merchandising associations.
LI75502 7.0.0.3 Prevents OOM when many users are returned.
LI75736 7.0.0.3 Makes changes in the CatEntrySearchListDataBean so that the validation for SQL injection could be performed.
LI75804 7.0.0.3 Solves synchronization problems in PerfMonitor.
LI75818 7.0.0.3 Resolves the problem where CatalogGroupPageRelationAccessBean.findByStoreCategoryMemberGroupsLanguageId throws ORA-01795 exception.
LI76049 7.0.0.3 Gets the ECApplication rather than NPE being thrown when the trading_id of an order is null, in which way the order processing of the job ProcessFutureOrders will not be interrupted due to the null trading_id order.

Critical fixes included in Fix Pack 2

The following fixes included in Fix Pack 2 are considered to be critical fixes for customers. Applying Fix Pack 2 fixes these critical issues.
APAR Fix pack number Description
IZ70832 7.0.0.2 Prevents the Out of Memory condition when publishing a catalog asset store using the Administration Console tool.
IZ73130 7.0.0.2 Addresses SQL injection vulnerabilities from Organization Admin Console JSPs
IZ86802 7.0.0.2 Prevents large allocations from Orders code.
JR38114 7.0.0.2 Stops RunTimeProfileCacheCmdImpl caching mutable objects modified in other controller/task commands.

Additional Fix Pack 2 fixes

The following fixes are also included in Fix Pack 2.
APAR Fix pack number Description
IZ57621 7.0.0.2 Removes default contract restriction for business users in WebSphere Commerce tooling.
IZ71777 7.0.0.2 Allows the extension of the ListMemberGroupForUser command.
IZ72951 7.0.0.2 Requires the wcf:url tag to reference the SSL Accelerator configuration port options (if any) when constructing the URL.
IZ73076 7.0.0.2 Uses content from the default language when no content is available in the shopper's language for an e-Marketing Spot.
IZ73557 7.0.0.2 Resolves the issue related with ShippingModeFilter so that the DN tag is encoded properly in XMLPARM section of PX_PROMOTION.
IZ73858 7.0.0.2 Allows for fallback on attribute names if not defined in the user language, to fall back on the definition in the alternative language.
IZ74687 7.0.0.2 Allows customers to add package components to a sales category within the Management Center.
IZ74723 7.0.0.2 Shares the database queries across all the web activities in the same spot.
IZ75096 7.0.0.2 Propagates element invalidations to all nodes in a clustered environment.
IZ75137 7.0.0.2 Fixes the problem that if you share duplicate part number among different extended site stores, web activity is displayed incorrectly when editing.
IZ75545 7.0.0.2 Adds a variable transaction timeout to DynaCacheInvalidation which allows the command to complete long running transactions that would otherwise be limited to the global transaction timeout. In certain situations transactions timeout and are rolled back. Invalidations that were previously issued are issued again the next time. The timeouts continue forever because the work is never marked as done.
IZ77545 7.0.0.2 Prevents a null pointer from showing up when viewing workspace tasks/taskgroups using the Management Center.
IZ80071 7.0.0.2 Using the PriceList services, ExternalIdentifier is used by setting the StoreIdentifier rather than the price list unique id. This is not enough if multiple PriceLists are in use. Providing the storeId is taking the default PriceList from the DefaultContract. The request is to choose the specific PriceList using the ExternalIdentifier.
IZ84143 7.0.0.2 Catches a null case if a description for the user language or the store default language can not be found.
IZ85239 7.0.0.2 Requires SegmentCache to not clear the Data Cache
IZ89210 7.0.0.2 Removes the calls to SegmentCache.refresh from the MemberGroupMember command implementations
JR35462 7.0.0.2 Corrects the output of the Sort by last name when using the GiftRegistrySearchDataBean
JR35629 7.0.0.2 Ignores TransactionCachedMap when no transaction is active.
JR35894 7.0.0.2 Clears the trading agreement registry when deploying new contracts
JR35995 7.0.0.2 Changes the sorting of DISPCGPREL within the CatalogGroupPageRelationAccessBean.findByStoreCategoryMemberGroupsLanguageId to have the RANK have a higher priority thank the store id value.
JR36284 7.0.0.2 Delivers the required updates on WebSphere Commerce 7.0 to provide support for IBM i.
JR36462 7.0.0.2 Resolves the issue with specifying store identifier in CSV file and not in BusinessContext
JR36471 7.0.0.2 Prevents an empty response object for a web Service response when the content-length header is not present
JR36514 7.0.0.2 Prevents WebSphere MQ messages rejected on shutdown.
JR36529 7.0.0.2 Corrects an issue where e-Marketing Spots using the shopping cart target might not be displayed correctly in an extended site environment.
JR36586 7.0.0.2 Fixes a code logic error in the web service command that resulted in language-specific assets getting deleted unexpectedly. Details: The SOI web service command was populating an empty list of languages for any request coming for updating an attachment asset. The empty list was not being handled correctly in the code. Currently only a NULL check was being performed in the SOI service command. The code flow should not have been executed when the list is empty. The attachment asset data bean should not have an empty list set on it, as the AttachmentUpdateCmdImpl will DELETE all of the attachment asset language records in the ATCHASTLG table and re-create the records for the previous languages.
JR36615 7.0.0.2 Ensures CSVReader handles the BOM character.
JR36641 7.0.0.2 Corrects the order of sales category display sequence in store front.
JR36649 7.0.0.2 Resolves the problem that calculation rule does not work correctly when the jurisdictiongroup is set to null in the SHPJCRULE table.
JR36735 7.0.0.2 Keeps the Production and Staging CMFILE tables in synch after an attachment is deleted on Staging.
JR36777 7.0.0.2 Addresses a problem where Idresgen with optimize='yes' marks different records as duplicates when DB is Oracle
JR36819 7.0.0.2 Makes the checkMinimumQuantity() and resetMaximumQuantity() methods protected in ChangePriceListPriceEntryActionCmdImpl to allow for customization.
JR36820 7.0.0.2 Permits the use of long catalog group IDs (catgroup_ids) in the Shipping notebook within WebSphere Commerce Accelerator.
JR36877 7.0.0.2 Prevents the promotion status from being set to inactive while updating redemption values
JR36963 7.0.0.2 Prevents a NotSerializableException from being thrown when a not serializable message is sent asynchronously.
JR36972 7.0.0.2 Enables customer to cache device-specific page by setting the device id as a request attribute.
JR37003 7.0.0.2 Resolves problems with IBM Digital Analytics Shop5 and Shop9 tags for web 2.0 store.
JR37004 7.0.0.2 Resolves null pointer exception when using standard IBM Digital Analytics tagging infrastructure.
JR37020 7.0.0.2 Exposes PunchoutPaymentCallBackCmdImpl.getPaymentSystemName(TypedProperty) for customization purpose.
JR37041 7.0.0.2 Adds the flexibility to disable SSL connection when username and password are in use to send email.
JR37047 7.0.0.2 Provides the new API of the IBM Digital Analytics registration tag
JR37056 7.0.0.2 Corrects the problem where search results from GiftRegistrySearchDataBean contain duplicate entries.
JR37064 7.0.0.2 Fixes the non-AJAX Madisons store so a nickname gets returned properly on the account update page
JR37087 7.0.0.2 Gets support for ResolveOrderItemPriceCmd to get catentryid and CatEntryPrices.
JR37206 7.0.0.2 Removes the exception that is thrown if the shopper places more than one order within the time interval configured for the SendMarketingTriggers scheduled job.
JR37220 7.0.0.2 Corrects promotion start and end times that are not being saved in WebSphere Commerce Accelerator. Promotion start and end date/time are correctly saved in the CALCODE table. However, only the start/end DATE is saved in PX_PROMOTION. The start/end TIME is not saved in PX_PROMOTION. The start/end time is saved as 00:00:00.
JR37260 7.0.0.2 Does not allow the deletion of an attachment that was previously associated to a business object.
JR37262 7.0.0.2 Allows Installation Manager 1.4 to install WebSphere Commerce 7.0 Feature Pack 1.
JR37274 7.0.0.2 Resolves the NullPointerException seen when opening Preview in Management Center.
JR37275 7.0.0.2 Enables the -schema property of cm_cdfgen.sh to be effective for Oracle and DB2.
JR37286 7.0.0.2 Migrates entry in DMMBRGRPPZN when a guest logon is used.
JR37299 7.0.0.2 Corrects an order error that can occur if one shipping address is mapped to multiple jurisdictions.
JR37314 7.0.0.2 Ensures web activities for merchandising associations do not include items from requisition lists.
JR37325 7.0.0.2 Updates the code base to have the web activity description returned.
JR37366 7.0.0.2 Reduces evaluation time of promotions when using the ShopcartDrivenAgendaBuilder and having no active category-level promotions in the store.
JR37378 7.0.0.2 Corrects the error of picking the wrong inventory system during SAR publish.
JR37399 7.0.0.2 Provides an implementation for the ChangeCatalogEntryAttachmentReferenceMediator.resolveByExternalIdentifier method.
JR37409 7.0.0.2 Populates OFFER.FIELD2 column when using PriceEntry UserData map in Data Load tool configuration.
JR37462 7.0.0.2 Allows the TableDataObject to properly handle CLOBs.
JR37526 7.0.0.2 Fixes a database migration failed error from V56X to V 60010.
JR37563 7.0.0.2 Recovers the Auto Tagging directory that is missing from WebSphere Commerce 7.0 installation.
JR37659 7.0.0.2 Chooses the correct category for a promo in tooling when multiple category keys exist for the same product name
JR37710 7.0.0.2 Addresses the issue where promotions are given to customers that exist in any marketing-managed segment instead of just the specified one.
JR37778 7.0.0.2 Provides an implementation for the ChangePriceListPriceEntryActionCmdImpl.getCatentryIdFromNoun()
JR37779 7.0.0.2 Resolves the USER EJB deadlock problem.
JR37889 7.0.0.2 Loads CSV file catalog- with WebSphere Commerce Accelerator catalog import- containing items with multiple currency prices.
JR37970 7.0.0.2 Corrects the issue where GuestUserOrderMigrationEventListener fails when migrating an empty guest cart.
JR38082 7.0.0.2 Resolves command context issues.
JR38111 7.0.0.2 Solves the problem in the common client facade class (AbstractCatalogFacadeClient) used by the components' client library classes.
JR38152 7.0.0.2 Adds a null check for activity target "Cookie X has any value".
JR38260 7.0.0.2 Removes orphan relationships that are left in CATGPENREL table.
JR44935 7.0.0.2 Provides the ability to disable Sales Center customer related caching and cache invalidation messages.
LI74920 7.0.0.2 Addresses high processor issue of RefreshLocalRegistry, specifically when client has many Store/Organization in their database.
LI75343 7.0.0.2 Allows encrypted strings with carriage return characters to be decrypted by MigrateEncryptedInfo correctly.
LI75344 7.0.0.2 Avoids the freezing issue experienced when using Management Center to create a promotion that is targeted to many SKUs.
LI75376 7.0.0.2 Prevents GroupLevelExclusiveness policy from eliminating promotions that are based on promotions that have already been considered eliminated.
LI75380 7.0.0.2 Makes fileprop optional in stagingprop if WebSphere Application Server parameters are not provided.
LI75492 7.0.0.2 Reduces memory that is used by RegistryCalculationRuleAccessBean when LI74998 is enabled.
LI75503 7.0.0.2 Currently the IBM Digital Analytics tags send the user ID of the shopper as the customerId to IBM Digital Analytics. Allows customers to send the emailId of their shoppers in place of the user ID value to IBM Digital Analytics so that they can better track the behavior of their non-registered shoppers.
LI75512 7.0.0.2 Corrects the problem where the offer finder could not fetch offer among over 1000 price lists with Oracle.
LI75516 7.0.0.2 Fixes the incorrect cached data in promotion engine.
LI75517 7.0.0.2 Corrects the unexpected behavior of Preview in WebSphere Commerce Accelerator to retrieve cached copy of e-Marketing Spot.
LI75521 7.0.0.2 Refreshes registries after stagingprop.
LI75670 7.0.0.2 Allows a task to be returned to active state where the current state of the task group is commit failed.
LI75719 7.0.0.2 Provides an on/off toggle for the lockitemspec method in prepareordercmdimpl.
LI75728 7.0.0.2 Enables caching of Campaign Element Target Task Commands in the Marketing engine.
SE42949 7.0.0.2 Adds ProductSetPublish functionality to Massload.
SE43008 7.0.0.2 Adds pagination to WebSphere Commerce Accelerator page "Defining Attribute" to reduce load time when the number of SKU is large.

Critical fixes included in Fix Pack 1

The following fixes included in Fix Pack 1 are considered to be critical fixes for customers. Applying Fix Pack 1 fixes these critical issues.
APAR Fix pack number Description
IZ63790 7.0.0.1 Corrects a segmentation fault in WebSphere Commerce staging.
IZ65705 7.0.0.1 Corrects the issue where DBClean configuration for object "PaymentRule" and type "obsolete" can cause loss of data in the PPCPAYINST table.

Additional Fix Pack 1 fixes

The following fixes are also included in Fix Pack 1.
APAR Fix pack number Description
IY80324 7.0.0.1 Changes the Payments Database user ID.
JR27361 7.0.0.1 Adds trace information to aid problem determination.
JR27434 7.0.0.1 Prints more verbose logging in the Currency Manager.
JR34433 7.0.0.1 Corrects the issue of LikeMinds not inserting the proper value into the TIMESTAMP column of the tables in the LikeMinds database.
LI71395 7.0.0.1 Adds the ability for an exception to be thrown when no price is set for an item.
LI71721 7.0.0.1 Customizes a shopping flow scenario in the default ConsumerDirect Store.
IZ19468 7.0.0.1 Allows the deletion of linked categories in a sales catalog when using extended sites and catalog asset stores.
IZ56465 7.0.0.1 Corrects an out-of-memory issue when running the sitemap generation tool for a large product set.
IZ62489 7.0.0.1 Provides performance enhancements with cached access beans via the WCDataCache API.
IZ65451 7.0.0.1 Prevents an infinite loop when printing a TypedProperty Map that references itself, and instead throw an error.
IZ66818 7.0.0.1 Displays images (logo and styles) in WebSphere Commerce Accelerator when custom ports are used instead of default ports 80 and 443.
IZ66835 7.0.0.1 Corrects the issue with fixed price promotions where the fixed promotion price is used even if the sum of the prices of the associated items is less than the fixed promotion price.
IZ66937 7.0.0.1 Corrects the performance issue with WebSphere Commerce Accelerator when working with promotions.
IZ68551 7.0.0.1 Improves performance of web Activities when running in Preview mode.
IZ73690 7.0.0.1 Allows workspace preview when store e-Marketing Spot is not defined.
IZ74061 7.0.0.1 Orders DMElements returned for better handling by the UI.
IZ74356 7.0.0.1 Corrects the issue with the request to web service returning a null input stream intermittently.
IZ74566 7.0.0.1 Provides option to disable the Campaign Initiative cache.
IZ74684 7.0.0.1 Clears the cache for a task group that has been approved in a workspace.
JR24966 7.0.0.1 Corrects the generic error that is displayed when an order is placed and there is insufficient inventory.
JR28035 7.0.0.1 Improves scheduler performance and reduce contention on the SCHACTIVE table.
JR29155 7.0.0.1 Optimizes performance of StorePathSupportedAgendaBuilder to evaluate each store only one time.
JR34631 7.0.0.1 Corrects the null pointer exception when using the EDPCompleteOrderActivityDataBean.
JR34670 7.0.0.1 Corrects the issue where request to web service returns a null input stream intermittently.
JR34743 7.0.0.1 Displays a message that Shipping Charge cannot be created when an orphan shipping charge of same name exists in database.
JR34900 7.0.0.1 Corrects the issue where ChangeCatalogEntry BOD does NOT update CATGPENREL.LASTUPDATE field.
JR34924 7.0.0.1 Adds Arabic support into Madisons store for WebSphere Commerce Version 7.
JR35023 7.0.0.1 Corrects all post-GA WebSphere Commerce Version 7 MVT defects.
JR35136 7.0.0.1 Enhances WebSphere Commerce security by separating out session encryption from data encryption.
JR35192 7.0.0.1 Enables the WebSphere Commerce Update Installer to install interim fixes on WebSphere Commerce Payments instances.
JR35199 7.0.0.1 Enhances WebSphere Commerce security by increasing the length of the merchant key from 64 bits to 128 bits.
JR35303 7.0.0.1 Removes duplicate VERSIONSPC records from the ApparelCatalogData.sar catalog.xml and ATP_inventory.xml files.
JR35383 7.0.0.1 Fixes the pagination conditions for displaying products in the Madisons store.
JR35384 7.0.0.1 Provides infrastructure changes that are required to apply future Social Commerce fixes.
JR35424 7.0.0.1 Prevents cross site scripting attack on sample store pages.
JR35436 7.0.0.1 Corrects the display of multiple offer prices for a product in an extended site store front when the price is defined in the catalog asset store only.
JR35506 7.0.0.1 Delivers some known Social Commerce fixes.
JR35507 7.0.0.1 Corrects the issue where the My Account page of the Madisons starter store has an incorrect layout when the Social Commerce sample pages are installed.
JR35509 7.0.0.1 Corrects the issue where the PhotoGallery widget displays the photo's author name outside the bounds of the photo region.
JR35559 7.0.0.1 Corrects the issue where catalog ID gets modified (through rounding) when going through InventoryAdjustment in WebSphere Commerce Accelerator and when the value of catalog ID is large.
JR35594 7.0.0.1 Enhances the performance of quick publish when approving two or more workspace tasks.
JR35689 7.0.0.1 Allows non-admin DB user to connect to DB after running setdbtype.
JR36149 7.0.0.1 Corrects XSD validation failure of transfer order request that is generated as part of order submission when a store is configured to use DOM to submit orders to external system.
JR36283 7.0.0.1 Corrects the issue where e-Marketing Spots might not display expected content in the storefront after using Management Center Store Preview with a preview date set in the future.
JR36349 7.0.0.1 Fixes the problem where the inventory physical SDO objects in Inventory-Server.jar has not been regenerated and are therefore incompatible with extension physical SDO objects generated by Rational Application Developer 7.5.x.
JR36472 7.0.0.1 Fixes the problem where WebSphere Commerce V7 fails to send emails (such as password reset email) in a web 2.0 enabled sample store after upgrading WebSphere Application Server to Version 7.0.0.9
LI71405 7.0.0.1 Allows users to configure which return codes from Paymentech should be considered as successful by specifying the return codes in a properties file.
LI73581 7.0.0.1 Disables the default calendar check on credit card expiry dates during PIAdd. This is to allow for loading of Payment instruction information that contains credit card expiry dates that are in the past and far into the future.
LI73750 7.0.0.1 Implements a check for contracts before canceling to avoid exceptions regarding no contracts for store.
LI74998 7.0.0.1 Reduces memory that is needed for the CalculationRegistry.
LI75000 7.0.0.1 Exposes the start/end date of tax rule into the WebSphere Commerce Accelerator tax tools.
LI75008 7.0.0.1 Corrects a database user authority issue in the new authoring instance creation with local DB2v9.7 database server on unix/linux platforms.
LI75149 7.0.0.1 Prevents the logging of exception "No nominal cost price list found for store=XXXX" when price negotiation is not used.
LI75155 7.0.0.1 Implements a retry mechanism for the workspaces quick publish feature.
LI75167 7.0.0.1 Corrects the issue of the cache in SequenceBuilder causing incorrect promotional prices to be displayed.
LI75276 7.0.0.1 Allows SUBORDERS.TOTALADJUSTMENT to be calculated when the Sub Orders function is enabled.
LI75287 7.0.0.1 Prevents the price of a different order from being used by payments when releasing the order to payments manager.
LI75356 7.0.0.1 Corrects the problem of the ORA-01461 exception being thrown when email is sent to many recipients.
JR36173 7.0.0.1 Corrects the problem where a descriptive attribute is not displayed if the product has a single SKU in the Madisons store front, even if the attribute is there.
SE25158 7.0.0.1 Corrects a potential problem in InventoryBaseCmdImpl where it sometimes acquires NS locks on rows of the INVENTORY table before attempting to update those rows.
SE38676 7.0.0.1 Updates the UnitManager to load the CurrencyFormatDescription beans using the lazy load technique.
SI33252 7.0.0.1 Extends the expiry date of a credit card when it is used for the payment.

Sales Center client fixes

This table lists the interim fixes (APARs) contained in the latest fix pack for the WebSphere Commerce Sales Center client. WebSphere Commerce fix packs are cumulative. The fix pack number that is listed in the table, indicates which fix pack the fix is included in.
APAR Fix pack number Description
JR37909 7.0.0.3 Resolves the issue that when creating a customer in Sales Center, we are unable to set the preferred language to UK English.
JR28177 7.0.0.3 Avoids the lazy loading (Eclipse platform) to start the custom ModelRoot of the sale center

WebSphere Commerce Version 7 APAR fixes

The following list shows APARs from Version 5.6.1 and Version 6.0 that are applicable and included in WebSphere Commerce Version 7. If you are installing WebSphere Commerce V7, you can use this list to determine which APAR fixes from earlier releases are included in WebSphere Commerce V7. Determine the APARs on your system then compare them against the APARs listed in this table. If you applied an APAR that is not on this list, contact IBM support to see if it is applicable to V7 and request an interim fix for your APAR.

IY73830 IZ02645 IZ35803 JR24681 JR27507 JR32174 LI72715
IY75665 IZ02667 IZ35875 JR24748 JR27531 JR32175 LI72716
IY77349 IZ02770 IZ35878 JR24752 JR27543 JR32233 LI72725
IY77789 IZ02779 IZ35878 JR24814 JR27580 JR32348 LI72791
IY78564 IZ02865 IZ36605 JR24822 JR27627 JR32350 LI72800
IY78613 IZ03004 IZ36608 JR24861 JR27642 JR32351 LI72919
IY80068 IZ03337 IZ36666 JR24876 JR27645 JR32363 LI72955
IY80164 IZ03740 IZ37073 JR24885 JR27649 JR32534 LI72970
IY80223 IZ03770 IZ37702 JR24888 JR27656 JR32559 LI72984
IY80667 IZ03771 IZ37775 JR25009 JR27658 JR32575 LI73026
IY82080 IZ05315 IZ37844 JR25013 JR27675 JR32613 LI73107
IY82589 IZ05315 IZ38207 JR25015 JR27692 JR32672 LI73114
IY83748 IZ06174 IZ38873 JR25024 JR27726 JR32686 LI73120
IY83823 IZ06573 IZ39057 JR25038 JR27727 JR32687 LI73152
IY83995 IZ06667 IZ40135 JR25049 JR27727 JR32710 LI73172
IY84081 IZ06990 IZ40675 JR25080 JR27736 JR33124 LI73177
IY84484 IZ07155 IZ40744 JR25085 JR27815 JR33126 LI73179
IY85624 IZ07156 IZ40744 JR25163 JR27818 JR33182 LI73182
IY86276 IZ07537 IZ41664 JR25189 JR27823 JR33274 LI73187
IY86483 IZ08424 IZ41934 JR25318 JR27827 JR33275 LI73284
IY86766 IZ08897 IZ42182 JR25336 JR27841 JR33295 LI73296
IY87038 IZ09485 IZ42293 JR25362 JR27851 JR33347 LI73323
IY87982 IZ11494 IZ42293 JR25378 JR27855 JR33350 LI73442
IY88078 IZ11586 IZ43221 JR25413 JR27865 JR33442 LI73449
IY88549 IZ12237 IZ43229 JR25423 JR27879 JR33494 LI73479
IY88656 IZ12718 IZ43243 JR25504 JR27886 JR33561 LI73488
IY88772 IZ13995 IZ44064 JR25507 JR27888 JR33657 LI73559
IY89101 IZ14145 IZ44678 JR25513 JR27890 JR33721 LI73562
IY89720 IZ14156 IZ44931 JR25517 JR27907 JR33727 LI73574
IY89993 IZ14253 IZ45115 JR25518 JR27929 JR33929 LI73578
IY90010 IZ14476 IZ45204 JR25548 JR27934 JR33955 LI73594
IY90662 IZ14729 IZ45778 JR25553 JR27957 JR34081 LI73710
IY90774 IZ15381 IZ45814 JR25562 JR27970 JR34113 LI73711
IY90929 IZ16611 IZ46815 JR25568 JR28016 JR34114 LI73725
IY90933 IZ16654 IZ47419 JR25583 JR28035 JR34127 LI73754
IY90976 IZ16731 IZ48301 JR25752 JR28054 JR34176 LI73788
IY91134 IZ16932 IZ49847 JR25832 JR28054 JR34210 LI73794
IY91476 IZ16956 IZ49969 JR25891 JR28093 JR34372 LI73795
IY91513 IZ17323 IZ49971 JR25918 JR28278 JR34440 LI73807
IY91758 IZ17416 IZ50181 JR25944 JR28318 JR34578 LI73840
IY91860 IZ17703 IZ50181 JR25946 JR28321 JR34631 LI73841
IY92177 IZ17704 IZ50562 JR25946 JR28393 JR34667 LI73855
IY92792 IZ17753 IZ51733 JR25950 JR28426 JR34743 LI73855
IY92852 IZ17900 IZ51759 JR25955 JR28430 JR34754 LI73876
IY93066 IZ18610 IZ51786 JR26047 JR28438 JR34900 LI73887
IY93118 IZ18611 IZ52082 JR26106 JR28453 LI70699 LI73893
IY93284 IZ19130 IZ52271 JR26112 JR28464 LI70827 LI73929
IY93285 IZ19137 IZ52886 JR26117 JR28529 LI70922 LI73935
IY93304 IZ19468 IZ52889 JR26161 JR28529 LI70934 LI74077
IY93347 IZ19589 IZ53224 JR26172 JR28619 LI71087 LI74105
IY93384 IZ19589 IZ53253 JR26202 JR28623 LI71090 LI74106
IY93633 IZ19594 IZ53759 JR26359 JR28642 LI71098 LI74149
IY93739 IZ20316 IZ54065 JR26432 JR28648 LI71282 LI74176
IY93769 IZ20416 IZ54075 JR26436 JR28672 LI71288 LI74200
IY93770 IZ20688 IZ54092 JR26437 JR28716 LI71315 LI74201
IY94001 IZ20793 IZ54510 JR26463 JR28853 LI71375 LI74218
IY94012 IZ20879 IZ55250 JR26501 JR28977 LI71397 LI74226
IY94413 IZ21063 IZ55356 JR26553 JR29030 LI71582 LI74269
IY94647 IZ21395 IZ57059 JR26597 JR29054 LI71594 LI74286
IY94694 IZ21694 IZ57504 JR26607 JR29074 LI71607 LI74452
IY94869 IZ21702 IZ57937 JR26623 JR29213 LI71608 LI74454
IY94895 IZ22017 IZ57939 JR26636 JR29264 LI71687 LI74505
IY95012 IZ22018 IZ58797 JR26672 JR29380 LI71708 LI74643
IY95047 IZ22196 IZ58851 JR26673 JR29452 LI71714 LI74665
IY95221 IZ22305 IZ59605 JR26684 JR29502 LI71730 LI74676
IY95447 IZ22332 IZ62325 JR26734 JR29656 LI71771 LI74707
IY95567 IZ23043 IZ64183 JR26740 JR29659 LI71819 LI74711
IY95698 IZ23046 IZ65451 JR26779 JR29678 LI71827 LI74791
IY95711 IZ23056 IZ65705 JR26844 JR29682 LI71832 LI74800
IY95720 IZ23461 IZ66818 JR26860 JR29825 LI71970 LI74804
IY95821 IZ23465 IZ66835 JR26863 JR29905 LI72065 LI74805
IY96013 IZ23746 IZ68551 JR26909 JR29906 LI72077 LI74806
IY96015 IZ25738 JR21823 JR26983 JR30127 LI72081 LI74849
IY96034 IZ26384 JR22146 JR27009 JR30192 LI72092 LI74908
IY96151 IZ26528 JR22418 JR27070 JR30263 LI72094 LI74913
IY97562 IZ26551 JR22536 JR27075 JR30315 LI72102 LI74920
IY97875 IZ26726 JR22728 JR27148 JR30316 LI72130 LI74998
IY98301 IZ26967 JR22771 JR27151 JR30333 LI72366 LI75004
IY98306 IZ27239 JR22782 JR27155 JR30514 LI72400 LI75149
IY98315 IZ27816 JR22868 JR27156 JR30590 LI72401 SE24132
IY98337 IZ27969 JR22892 JR27167 JR30667 LI72415 SE26648
IY98684 IZ29181 JR22893 JR27172 JR30707 LI72419 SE27480
IY99039 IZ29184 JR22913 JR27173 JR30741 LI72440 SE29519
IY99225 IZ30095 JR22988 JR27229 JR30743 LI72467 SE29564
IY99570 IZ30106 JR23109 JR27243 JR30847 LI72493 SE29564
IY99636 IZ30223 JR23657 JR27245 JR30862 LI72521 SE29907
IY99777 IZ30280 JR23838 JR27251 JR30908 LI72523 SE30225
IY99844 IZ30561 JR24147 JR27275 JR30972 LI72526 SE30983
IZ00003 IZ32476 JR24205 JR27287 JR31139 LI72530 SE31007
IZ00026 IZ32559 JR24243 JR27317 JR31225 LI72530 SE31360
IZ00386 IZ32769 JR24312 JR27319 JR31247 LI72532 SE31410
IZ01015 IZ32945 JR24385 JR27348 JR31262 LI72541 SE31541
IZ01259 IZ33339 JR24462 JR27352 JR31329 LI72551 SE38676
IZ01422 IZ33347 JR24465 JR27373 JR31330 LI72588 SI25946
IZ01425 IZ33394 JR24495 JR27374 JR31375 LI72589 SI27143
IZ01726 IZ33737 JR24498 JR27391 JR31564 LI72602 SI27161
IZ01938 IZ33752 JR24546 JR27393 JR31584 LI72606 SI27443
IZ02271 IZ33752 JR24552 JR27395 JR31848 LI72675 SI32086
IZ02381 IZ33755 JR24597 JR27432 JR32070 LI72678 SI32088
IZ02625 IZ33822 JR24621 JR27488 JR32076 LI72684 SI33252
IZ02643 IZ34676 JR24671 JR27502 JR32099 LI72706