My Oracle Support Banner

InventoryAdjustmentReport in BI Displays Incorrect CREATE_DATE (Doc ID 2645023.1)

Last updated on MARCH 18, 2020

Applies to:

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

Symptoms

InventoryAdjustmentReport in Business Intelligence Publisher (BIP) is displaying incorrect CREATE DATE on the report, whereas the date is displayed correctly on SIM PC.

Steps To Recreate:

  1. Consider a store is associated with Timezone 'America/Managua'.
  2. Create a Inventory Adjustment using the above store and any valid item.
  3. Check the Create Date on SIM UI (Inventory Adjustment Detail screen) for this Inventory Adjustment. It is displaying the date correctly. Ex: CREATE_DATE 17 -DEC-19.
  4. Open InventoryAdjsutmentReport in BIP and try to open the report for this Inventory Adjustment. Check the Create Date on the report. It is showing the date one day ahead on the report. Ex: CREATE_DATE 18 -DEC-19.

Cause

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
Symptoms
Cause
Solution
References


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