My Oracle Support Banner

RPO: Competitor 1 and 2 Price Measures Are Zeroed Out in Price Analysis Workbook (Doc ID 2434788.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Regular Price Optimization - Version 16.0.2 and later
Information in this document applies to any platform.


Measures 'Competitor 1 Price' and 'Competitor 2 Price' are zeroed out in cases where Competitors are referenced by their indices, i.e. indexes SCmpCurPcendx1, SCmpCurPcendx2.  These are the Default Competitors (AVG, MAX or MIN) in the Price Analysis workbook.

These two measures pick up Competitors referenced by workbook indices 1 and 2, but in cases where Competitors referenced by those indices are one of the Default Competitors (AVG, MAX or MIN), the measures are zeroed out. In addition, those metrics are using indices 1 & 2 to pick up Competitors, but that does not give any functional significance to the measures, because the Competitors under those indices might vary according to the selection of Competitors done in the Scenario Management workbook. There should exist an additional measure in the Price Analysis workbook to allow users to select the Competitors needed to calculate the 'Competitor 1 Price' and 'Competitor 2 Price' , or any other functionality that would give functional logic to those measures.

Steps to reproduce:

1. Login and open Price Analysis workbook.
2. In step Competition Constraints, access worksheet Competition Item Metrics and observe that all All Competitors are populated for the selected Item.
3. In step Recommendations and What If, access worksheet Price Entry and observe that Item has a recommended price based on the optimization.
4. In step Recommendations and What If, access worksheet Detail Metrics and observe that the 'Competitor1 Price' and 'Competitor 2 Price' measures have values 0.00.




To view full details, 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 a vibrant support community of peers and Oracle experts.