RFR And RPILE Have Incorrect Timestamp Upon Changing Promo End Date (Doc ID 2202014.1)

Last updated on NOVEMBER 14, 2016

Applies to:

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

Symptoms

Upon changing the promo end date, the RPM_PROMO_ITEM_LOC_EXPL.DETAIL_END_DATE has a time portion = 23:59:59 (rather than 23:59:00) and the RPM_FUTURE_RETAIL.ACTION_DATE has a time portion of 00:00:59 (rather than 00:00:00).

Steps to reproduce:
-------------------------

1) vdate = 14-SEP-2016
2) Enforce chunking by reducing the THREAD_LUW_COUNT for 'com.retek.rpm.app.bulkcc.service.BulkConflictCheckAppService' and also by ensuring
(item-loc combinations/THREAD_LUW_COUNT) > RPM_SYSTEM_OPTIONS.CONFLICT_CHECK_CHUNK_FACTOR
3) Create a skulist with around 60 items and range it to around 4-5 stores belonging to the same zone
4) Create a promo at skulist zone/level and approve it.  Start date = 15-SEP-2016, End date = 30-SEP-2016
5) Make the promo Active
6) Advance the vdate to 20-SEP-2016
7) Update the end date of the promo to a date greater than or equal to vdate

Note that after changing the end date, RPILE has a time stamp of 20-SEP-16 23:59:59 (rather than 23:59:00) and RFR has a timestamp of 21-SEP-16 00:00:59(rather than 00:00:00)



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms