Hello,
I’m not sure if this should be posted in the assets forum for the PM functionality or this forum for database task schedule functionality. We are attempting to create a new database task schedule to run the function Pm_Action_Calendar_Plan_API.Extend_Plan. This function extends the system parameter PM Plan Horizon. Our plan is to keep this value set 5 years out and the hope is to run this at the beginning of each year to automatically extend the plan horizon by another year. Otherwise it could easily be forgotten if it has to be run manually once a year.
There’s only one parameter for this function called NEW_YEAR_ and it should be a YYYY number. I’ve tried multiple setups to set this to a value 5 years from this year, but nothing seems to be working properly. The closest I’ve gotten is using #NUMBER_OF_THIS_YEAR#+5 but this just sets the argument to quite literally 2023+5.
It seems odd that this parameter won’t sum the two values together. We have other PM calendar generation database tasks scheduled with sysdate+X setups that work fine. For example, we have one set up like this:
START_DATE_: sysdate
STOP_DATE_: sysdate+22
and the arguments used when it ran this morning were
START_DATE_2023-02-27-02.00.56
STOP_DATE_2023-03-21-02.00.56
Is there a different way to get this 5 year out value? Or is there a reason the summing doesn’t work for the Extend_Plan function but is working fine for the other calendar generation setups?
We are running Apps 10 update 13 IEE.
Best answer by Tomas Ruderfelt
View original
