My Oracle Support Banner

Future Price Change Has 3 Entries For A Single Item/loc With All The Details The Same (Doc ID 2946379.1)

Last updated on MAY 03, 2023

Applies to:

Oracle Retail Pricing Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

On : 22.1 version, Pricing - Price Changes


  After creating a price change and running the RPM_PRICE_CHANGE_CLEARANCE_CACHE_ADHOC batch, you observe that RPM_PC_JSON_CACHE has multiple rows for the price change


The issue can be reproduced at will with the following steps:
  a. make sure v2/item/price is enabled
  b. create a price change that is to be active tomorrow and approve it
  e. check the price change is in rpm_pc_json_cache
  d. notice there are 3 entries for v1 and v2 each for each just executed price change



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.