EOH and SALES QTY Multiplied 21 Times When UDA Description is Added in OBIEE Reports
(Doc ID 2279281.1)
Last updated on MAY 19, 2020
Applies to:Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.
In both AS-IS and AS_WAS report, EOH and SALES QTY is getting multiplied 21 times when adding UDA description is added.
Steps To Recreate:
- Create a report in OBIEE by selecting Fiscal week, loc number, item level 1 desc, UDA ID, EOH QTY
- Provide criteria filter for Fiscal week, loc number and department number
- Add UDA description to report, observe that the EOH QTY is multiplied 21 times
- In the Log file generated there is an addition join created with W_RTL_ITEM_GRP1_D_diff .
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