My Oracle Support Banner

Question Regarding Calendar Data (Doc ID 2792109.1)

Last updated on MAY 25, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Goal


The Calendar setup is Gregorian, but the data in Calendar table is based on 454.
Can you please rebuild the Calendar and other related tables in stage instance.

Customers Calendar
- Gregorian Calendar
- May to April
- Sunday to Saturday
- The period 01-MAY-2021 to 30-Apr-2022 is financial 2022

so the START_OF_HALF_MONTH system option should be '-5'


Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.