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.


On : 23.1, Operations & Maintenance

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.

The Reset indicator in the payload is 1 so it should add an end date to the existing Clearance according to the Admin Guide (


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

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