Future Retail Rollup Was Not Happening as Expected

(Doc ID 2240226.1)

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