Technology Stack - EBS (MOSC)

MOSC Banner

recalculate request parameters in scheduled requestset

edited Sep 6, 2016 5:00AM in Technology Stack - EBS (MOSC) 6 commentsAnswered

Hi,

We have a requestset scheduled for every night. For some programs it's required to have a date_to parameter. We would like this date to be the end of the month. In order to achieve this I set the requestparameter in the set to:

Type: SQL-statement

Value: SELECT last_day(trunc(sysdate)) from dual

When I schedule the set, this works great...until we move to the next month: then the parameter is still the last day of the previous month. It seems that the parameters for the next run of the requestset are simply copied from the previous run of the set instead of being recalulated.

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