Price Changes and Clearances Processed Incorrectly by SIM Data Seeding Scripts
Last updated on DECEMBER 05, 2017
Applies to:Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.
When the price changes/clearances are converted using Oracle Retail Store Inventory Management (RSIM) Data seeding scripts from RMS ITEM_LOC table, it doesn't convert the date into GMT. When the data is displayed in the SIM UI, it assumes the date in ITEM_PRICE and ITEM_PRICE_HIST is in GMT and converts that to store's local time. Hence the date appears incorrectly.
Steps to Reproduce:
1. Run data seeding script after SIM installation.
2. Observe the incorrect date for existing price change and clearances.
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