In this post, you’ll learn more about the Oracle ErrorORA-27417: BYWEEKNO clause requires YEARLY clause with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-27417: BYWEEKNO clause requires YEARLY clause
Reason for the Error ORA-27417: BYWEEKNO clause requires YEARLY clause
A repeat interval or calendar contained a BYWEEKNO clause with a frequency other than yearly.
How to fix the Error ORA-27417: BYWEEKNO clause requires YEARLY clause ?
You can fix this error in Oracle by following the below steps
Remove the BYWEEKNO clause or change the frequency to YEARLY.