EBS Customizations (MOSC)

MOSC Banner

request set sql statement parameter

edited Feb 11, 2014 12:00PM in EBS Customizations (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center