Concurrent Program Recalculate Parameters putting backslash in date values
Hi
EBS R12.2.9
I have a custom concurrent program which needs to be scheduled periodically once every 15 days. It has a data parameter in string format whose default value needs to be SYSDATE - 24 months.
(The parameter value is converted back to date using a date mask 'YYYY/MM/DD HH24:MI:SS' in the code)
In the concurrent program parameter definition I have used
Value Set 100 Characters (I also have tried FND_STANDARD_DATETIME, FND_DATE4_REQUIRED etc but no difference)
Default Type: SQL Statement
Default Value: SELECT TO_CHAR(TRUNC(ADD_MONTHS(SYSDATE, -24)), 'YYYY/MM/DD HH24:MI:SS') FROM DUAL