+7
I am looking to see if anyone has any advice on the syntax required by a custom task schedule in Apps 8 that I am trying to implement to run a specific task on the last day of the month. Using Oracle 11.2.0.3.0 database and cant find any specific advice as to whether the syntax is different. This string works on later versions.
Best answer by Charith Epitawatta
View original
+31
Hi
Try below expression instead and see if it works:
LAST_DAY(sysdate+1)
Assuming you need to get the last day of each month. Next execution date is set after each execution, so adding 1 to the current date would make sure the next execution date is set to next month.
Any expression that returns a valid date is supposed to work, but some expressions may not work in older versions of the app due to limitations.
Hope this helps!
+7
Hi
Try below expression instead and see if it works:
LAST_DAY(sysdate+1)
Assuming you need to get the last day of each month. Next execution date is set after each execution, so adding 1 to the current date would make sure the next execution date is set to next month.
Any expression that returns a valid date is supposed to work, but some expressions may not work in older versions of the app due to limitations.
Hope this helps!
Thanks Charith, that worked as expected! Many thanks for your quick response
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.