My Oracle Support Banner Sales Loading Fails When Upload File Has More Than 500 Items (Doc ID 1969502.1)

Last updated on SEPTEMBER 16, 2019

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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.