Issue with RMS Calendar Script for Gregorian Calendar; Fields Are Incorrectly Populated
Last updated on JULY 13, 2018
Applies to:Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.
In Retail Merchandising System (RMS), calendar setup is incorrect when selecting 'Gregorian' calendar.
Steps to Reproduce:
- Define System Options FINANCIAL_UNIT_OPTIONS.START_OF_HALF_MONTH with the value 1 (First month of the year).
- Execute the script calendar.sql with the following parameters:
G_cal_type = C (Gregorian Calendar); G_week_option = 1 (Sun-Sat) ; G_vdate = 20-APR-2016
- Observe that in SYSTEM_VARIABLES table, the following fields are incorrectly populated:
LAST_EOM_DATE, NEXT_EOM_DATE, LAST_EOM_START_HALF, LAST_EOM_END_HALF, LAST_EOM_START_MONTH, LAST_EOM_MID_MONTH, LAST_EOM_DATE_UNIT and NEXT_EOM_DATE_UNIT.
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