2.39 CALENDAR_FISCAL_YEAR_START

CALENDAR_FISCAL_YEAR_START specifies the start of the fiscal year.

Property Description

Parameter type

String

Syntax

CALENDAR_FISCAL_YEAR_START = string1 [, string2 ]

Default value

None

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

This parameter is used by SQL fiscal functions. Fiscal functions return results that are informed by a specified fiscal year. For example, if you specify that June 1 is the start of the fiscal year, then fiscal functions return data such that dates June 1 through August 31 fall in the first quarter of the fiscal year, the dates September 1 through November 30 fall in the second quarter of the fiscal year, and so on.

Fiscal function names all start with the word FISCAL, such as FISCAL_YEAR and FISCAL_QUARTER. See Oracle AI Database SQL Language Reference for a complete list of SQL fiscal functions and detailed information about each function.

If the start of the fiscal year is not specified when a fiscal function is invoked, then the function uses the value of this parameter to determine the start of the fiscal year. If the value of this parameter is null, then the function uses January 1 as the start of the fiscal year.

You can set this parameter at the session or system level:

ALTER SESSION SET CALENDAR_FISCAL_YEAR_START = string1 [, string2 ]
ALTER SYSTEM SET CALENDAR_FISCAL_YEAR_START = string1 [, string2 ]

Where:

  • string1 is a string literal representing a DATE. It is expected to use the date format for the session (NLS_DATE_FORMAT). Otherwise, specify the date format with string2.

  • string2, if specified, represents the date format to use when converting string1 to a DATE.

Example

Set the start of the fiscal year to June 1 for the session:

ALTER SESSION SET CALENDAR_FISCAL_YEAR_START = '01-JUN-2026', 'DD-MON-YYYY';

Note that only the month and day are relevant when setting the start of the fiscal year, so the following syntax could also be used:

ALTER SESSION SET CALENDAR_FISCAL_YEAR_START = '01-JUN', 'DD-MON';

Verify that June 15, 2026, falls within the first quarter of fiscal year 2027:

SELECT FISCAL_QUARTER('15-JUN-2026');

FISCAL_QUARTER
–-------------
Q1-FY2027

Verify that May 15, 2026, falls within the fourth quarter of fiscal year 2026:

SELECT FISCAL_QUARTER('15-MAY-2026');

FISCAL_QUARTER
–-------------
Q4-FY2026

Note:

This parameter is available starting with Oracle AI Database 26ai, Release Update 23.26.1.