RPM Worksheet Contains Effective Date Even If the Default_effective_date is 0 in the RPM_SYSTEM_OPTIONS Table
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.
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
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