request set sql statement parameter
Hi all,
I have a request set and I want to schedule it monthly, for example, the report will run on every 1 month 00:05 generating the previous month data, JAN-2014, i can;'t use incremental so i use sql statemnt as paarmeter in request set.
SELECT GP.PERIOD_NAME FROM GL_PERIODS GP WHERE GP.period_set_name = (SELECT period_set_name FROM gl_ledgers g WHERE g.ledger_id = fnd_profile.value('GL_SET_OF_BKS_ID')) AND GP.ADJUSTMENT_PERIOD_FLAG = 'N' AND LAST_DAY(add_months(to_date(to_char(sysdate, 'YYYYMM'), 'YYYYMM'), -1)) = GP.END_DATE;
the first submission is correct, drawing the previous month, but the scheduled concurrent job in the next month will give out the same parameter as the first submission paramter, JAN-2014, not FEB-2014. i have tried setting the sql in concurrent program it self and leaving blank also, also no luck.