EOH and SALES QTY Multiplied 21 Times When UDA Description is Added in OBIEE Reports
Last updated on JULY 25, 2017
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 .
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