Mark down clearance creating multiple entry for same reset date in RPM_CLEARANCE_RESET Table.
Hi ,
I am using 13.2.4 version of RPM . When I create a mark down clearance , I get multiple record for the same item/loc with same reset date in RPM_CLEARANCE_RESET table, detail example below
Clearance 1
---------------
Item : 123456
location: 456
Action date: 1-NOV-15
Percentage off: 10 %
Out of stock Date : 24-DEC-15
Reset Date: 25-DEC-15
Clearance 2
-----------------
Item : 123456
location: 456
Action date: 10-NOV-15
Percentage off: 20%
Out of stock Date : 24-DEC-15
Reset Date: 25-DEC-15
When I check in RPM_CLEARANCE_RESET table , I have two reset record for the same reset date as below , can some please let me know why this happne , because when it try to move any one the clearance to worksheet , it get stuck in conflict check due to duplicate entry .