My Oracle Support Banner

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

Last updated on MARCH 16, 2019

Applies to:

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


Incorrect UNIT PRICE in Merchandise Insights AS-WAS Report.

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.




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

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