My Oracle Support Banner

Clearance Resets Shows Wrong Price in Item Lookup (Doc ID 2957254.1)

Last updated on JUNE 26, 2023

Applies to:

Oracle Retail Store Operations Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On : 23.1, Operations & Maintenance

ACTUAL BEHAVIOR
---------------
When an item/location is on Clearance, SIOCS is showing the Clearance Price Type and the Clearance Price in Item Lookup as expected.
When a Clearance Reset is sent from RPCS, it reaches the ITEM_PRICE table but the Item Lookup is showing the wrong price - it keeps showing the Price Type as Clearance and the Clearance Price, not the new/regular price after the Clearance Reset.

Note: On the Item Detail Report, the Price is shown correctly.

EXPECTED BEHAVIOR
-----------------------
The Reset indicator in the payload is 1 so it should add an end date to the existing Clearance according to the Admin Guide (https://docs.oracle.com/en/industries/retail/store-inventory-op-cloud/23.1.201.0/reiag/batches.htm#GUID-14B420BE-EBF4-447B-88E6-5E9BC6FBEB9A)..)

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
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.