SIM is Not Allowing an Item Request for the Same Day as the Next Delivery Date

(Doc ID 2208627.1)

Last updated on DECEMBER 06, 2016

Applies to:

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


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

In the Store Inventory Management (SIM) application, we find that an Item Request cannot be created for the date on which the item's next replenishment is due, and when the store is in a timezone that is ahead of GMT.

Steps to Reproduce:

  1. Ensure that the STORE_ITEM.NEXT_DELIVERY_DATE is set to a future date (for example, today is July 29th 2016...let the next_delivery_date be set to '30-July-2016').
  2. Ensure that the store is a timezone that is ahead of GMT time.
  3. Set the System admin parameter 'Enable GMT for Item Requests' to 'No'.
  4. In SIM, create an item request for the same date as the next delivery date from Step 1 above (ex: 30-Jul-2016).  Note that an error dialog is displayed with the message "Item XXXXXXXXX cannot be ordered based on the request by Date".
  5. Change the date to next day (31-Jul-2016) and note that the item request can be created.
  6. Repeat the test by setting the system admin parameter 'Enable GMT for Item Requests" to "Yes" (followed by a SIM bounce) and find that the error still occurs.



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