My Oracle Support Banner

Incorrect PL Level Entries In Rpm_Future_Retail (RFR) (Doc ID 2466166.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Price Management - Version 13.2.6 and later
Information in this document applies to any platform.


When an item on stock keeping unit (SKU) level is having lower retail compared to other SKU's under a style is ranged to a location, incorrect PL level entries have been posted into RPM_FUTURE_RETAIL (RFR) with selling retail = lower retail of ranging SKU after NewItemLocBatch is executed. These entries conflict in clearance approval for other SKU's with higher retail under same style.

Steps To Recreate :

  1. Range SKU's with lesser retail under a style to locations where already an higher retail SKU's are ranged.
    Example: Style S1 having two SKU's SK1(Diff D1) and SK2(Diff D2) with retail as $49.95 and $59.95 respectively. Having SK2 already ranged to Location L1, Range SK1 to same location L1.
  2.  Run NewItemLocBatch.
  3. Observe there are PL level entry at Location L1 with SK1 retail(49.95), which is Incorrect as the Style S1 is having SKU's ranged to Location L1 with higher retail(59.95) earlier as well.




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.