Sales Loading Fails When Upload File Has More Than 500 Items

(Doc ID 1969502.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.1 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release SIM 14.0.3.
This article will be updated as official patch information becomes available.

The Store Inventory Management (SIM) sales loading batch job fails whenever there are more than 500 sale items and at least one of the items has STORE_ITEM_STOCK.OPEN_STOCK_COUNT > 0.  Here is the error in log file:

Steps to Reproduce:

  1. Run with a file containing more than 500 records, and one item with STORE_ITEM_STOCK.OPEN_STOCK_COUNTS = 1
  2. Observe the above error.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms