Future Retail Rollup Was Not Happening as Expected
Last updated on MARCH 22, 2017
Applies to:Oracle Retail Price Management - Version 13.2.8 and later
Information in this document applies to any platform.
Performance issue occurs while running NewItemLocBatch. This was due to wrong WHERE clause in RPM_GENERATE_ROLLUP_FR_SQL package. This was also leading to wrong rollup data.
Steps to Recreate:
1. Create new items against locations under a zone at which there was a zone level promotion.
2. Run NewItemLocBatch and notice the poor performance. Also, notice that it was leading to wrong rollup data.
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