IFS Cloud only support the Gregorian calendar. The Gregorian calendar is the default calendar in all Oracle installations so no specific setting is required. It will lead to errors If you try and change the calendar to a format other than Gregorian. Thus the Oracle initialization parameter Nls_Calendar must not be changed from "GREGORIAN". The calendar used by IFS Cloud can be found within the function
IFS Cloud have two fixed dates:
- First calendar date
This date is set to 1st of January year one, 0001-01-01.
You can get the first date by calling
- Last calendar date
The last date is set to 9999-12-31
You can get the last date by calling
These two dates are generally used if you have designed your entity with an open date interval where either of the date values can be null.
sysdate BETWEEEN Nvl(start_date, Database_SYS.First_Calendar_Date) AND Nvl(stop_date, Database_SYS.Last_Calendar_Date)