Item Request Report Is Not Converting Date/Time from GMT to Store Date/Time

(Doc ID 2103431.1)

Last updated on FEBRUARY 09, 2016

Applies to:

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


In Oracle Retail Store Inventory Management (SIM), the Item Request report is not converting the date from GMT to store date.  For a store in the [GMT+3] timezone, the report shows the date as one day earlier than shown on the UI.

Steps to Reproduce:

  1. Log in to a store that has the store time zone as [GMT+3].
  2. Create an item request for a date.
  3. Check the database and note that the requested date is posted in GMT (one day earlier at hour 21:00:00).
  4. Print the report.  The report shows the date as GMT, which should be converted to store time.


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