Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

re: week number based on fiscal calendar setup in Oracle.

Rao MDec 1 2020

Hi,
Is there a function in Oracle to derive the week_number based on fiscal calendar start date.
Our FY21 stats from 27-Dec-2020.
So 27-Dec-2020 to 2-Jan-2021 is week-1.
It's always Sun-Sat week.
i.e Fiscal year always starts on Sunday.
Next year it will be from 26-Dec-2021 to 01-Jan-2022 week-1.
How can we derive the week based on the input_date using above fiscal calendar.
The Fiscal year start_date is defined in Oracle GL period tables. So we know when the year begin along with fiscal months.
thanks for your input.

Comments

Post Details

Added on Dec 1 2020
1 comment
618 views