scheduled concurrent request date parameter is not chaging automatically
I have scheduled a concureent request with date parameter having default value set based on sql statement. The SQL Statement is :
Select sysdate-1 from dual.
That is if request runs today its date will be of yesterday. I have scheduled this reuqest yesterday. But its parameter value is not changing automatically and its static on 14-Aug-2011..
Any hint what i am missing here please?
Hina