Incorrect UNIT PRICE In Merchandise Insights AS-WAS Reports (Doc ID 2236229.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

Incorrect UNIT PRICE in Merchandise Insights AS-WAS

Steps To Recreate:

1. Create new analysis from Merchandise Insights - AS WAS
2. Select column fiscal week, location, item level 1 number, item level 2 number, price
3. Add filters for fiscal week 2016WEEK38 i.e. the week for which data is available in our RI DB

NOTE: when user add fiscal date the price is coming out correctly, the issue seems to be with the LAST function used to pick the selling price at week level


Cause

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