It's not clear. Could you explain more?
I have to schedule "PRC: Generate Draft Invoices for a Range of Projects" concurrent program on R12.1.3
Seq Prompt Display Modify Shared Parameter Type Value 4 Bill Through Date * * SQL Statement select trunc(next_day(last_day(sysdate)-7, 'Sunday')) from dual 13 Invoice Date * * SQL Statement select trunc(sysdate) from dual)
Above are the parameters used, if I run for today it runs with correct values, but I need to run every day and sql should be executed in run time.
Hope it is clear now.
Thanks for your time.
Schedule Concurrent Request Does Not Get The Correct Parameter to Run Every Time
Anyone have any idea to bypass this please? To use any tricks to achieve my result.
When you schedule, it will not work. I too face same situation long back, that time I wrote same logic in formula column.
So handle same logic inside your code.
Hope this will help.
Thank you Hussein and Jaga. As the oracle doc , it is intended functionality. I cannot handle this code because I am running standard program "PRC: Generate Draft Invoices for a Range of Projects"