Concurrent Request "increment date parameters each run" results in ORA-01861
Hi,
I have a custom built concurrent program that has a date parameter. This date parameter has been assigned the FND_STANDARD_DATE value set. My "ICX: Date format mask" is set to DD.MM.RRRR
When I submit the concurrent request, I was required to enter the date parameter in following format: DD-MON-RRRR, which I did as 25-MAR-2014. I scheduled the report to run daily and chose the option to increment the date parameter. For the first request that ran I could see that the date parameter was stored in FND_CONCURRENT_REQUESTS table in the standard canonical format (2014/03/25 00:00:00). The request completed normally. However, the subsequent scheduled request that was automatically created, incremented date parameter value correctly by 1 day, but stored the value in FND_CONCURRENT_REQUESTS in the following format: "26.03.2014 00:00:00". This should not