RPM Worksheet Contains Effective Date Even If the Default_effective_date is 0 in the RPM_SYSTEM_OPTIONS Table

(Doc ID 2364952.1)

Last updated on FEBRUARY 27, 2018

Applies to:

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

Symptoms


The worksheets resulting from a clearance strategy show an effective date even when you have RPM_SYSTEM_OPTIONS.DEFAULT_EFFECTIVE_DATE to 0.
You expect that the effective date in the worksheet detail should be blank since the system option setting is set to unchecked.


The issue can be reproduced at will with the following steps:
   1) Edit System Options and make sure to uncheck the Pricing Strategy Default Effective Day (under the General Tab)
   2) Create a Calendar
   3) Create a Candidate Rule
   4) Put a dept/class/or subclass in a Clearance Strategy
   5) Run RPM Merchandise Extract Kickoff Batch
   6) Edit a Worksheet and notice the the details have Effective dates



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