Issue with RMS Calendar Script for Gregorian Calendar; Fields Are Incorrectly Populated (Doc ID 2151665.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

In Retail Merchandising System (RMS), calendar setup is incorrect when selecting 'Gregorian' calendar. 


Steps to Reproduce:

  1. Define System Options FINANCIAL_UNIT_OPTIONS.START_OF_HALF_MONTH with the value 1 (First month of the year).
  2. 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
  3. 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.

 

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