Who's Online Now
0 registered members (), 4 guests, and 19 spiders.
Key: Admin, Global Mod, Mod
Newest Members
SAI, Balasubramaniam, Dataterrain, Sarathy R, pjchiverton
1258 Registered Users
Recent Posts
Just imagine...
by MarinaH. 08/11/17 05:42 AM
Changing the PAYE ref on an "in flight" Payroll
by BRIAN_D. 30/10/17 02:00 PM
Top Posters(30 Days)
delboy 1
Popular Topics(Views)
421,915 PAYE RTI
50,341 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#11989 - 18/08/17 07:31 AM Incrementing parameter in scheduled request  
Joined: Apr 2007
Posts: 42
ClanGowland Offline
enthusiast
ClanGowland  Offline
enthusiast

Joined: Apr 2007
Posts: 42
Surrey, England
We have scheduled the Participation Process: Absence to run each evening and, as we wish for the Effective Date parameter to automatically populate with the last day of the current month, we have created a request set, attached the process and chosen a SQL statement for the "Effective Date" parameter of "select fnd_date.date_to_displaydate(last_day(sysdate)) from sys.dual".

However, when this runs, it populates the parameter with the same end of month, even when crossing periods - i.e. if we schedule on the 30 July, it will populate the parameter with the 31st July for both the 30th and 31st, but then will keep the 31st July when it runs on 1 August.

We have tried ticking the "Recalculate Default Program Parameters" on the Request Set screen, the "Increment date parameters each run" on the schedule request screen, and the "Recalculate Parameters" on the schedule request screen, but none of them seem to resolve the issue.

Has anyone come across this issue before and, if so, how was it resolved? I seem to recall previously we were able to do this for requests but I am not sure what this is missing.

If we cannot resolve this we will have to either extend the end date out or create a wrapper program that defines the date and calls the Participation Process but I would like to avoid this.

Many thanks
Craig


Anyone who believes in telekinesis, raise my hand
#11996 - 23/08/17 08:59 AM Re: Incrementing parameter in scheduled request [Re: ClanGowland]  
Joined: Mar 2005
Posts: 1,285
bcooper Offline
bcooper  Offline


*****

Joined: Mar 2005
Posts: 1,285
Earth, Europe, England, here
Hello Craig
I recall back in the mists of time we encountered some similar issues on the NHS project.
We ended up going down the wrapper route - although in part that was driven by the need to hide some of the lesser used parameters for some of the payroll processes (ie to stop the users from mucking things up). So most of the payroll related concurrent requests (and other selected non-payroll processes) all got wrapped in custom wrappers controlled by custom code - thus we were able to programmatically control such parameters.

I know that this doesn't necessarily provide the answer you want, but shows that sometimes even a project stuffed-full of consultants cannot resolve the apparently simple problems without resorting to code smile

Regards
Barry

#12017 - 04/09/17 10:22 AM Re: Incrementing parameter in scheduled request [Re: bcooper]  
Joined: Apr 2007
Posts: 42
ClanGowland Offline
enthusiast
ClanGowland  Offline
enthusiast

Joined: Apr 2007
Posts: 42
Surrey, England
Thanks Barry, I guess that'll be where we head too. 😩

Thanks for the reply

Many thanks
Craig


Anyone who believes in telekinesis, raise my hand

Moderated by  Administrator, andy.fisher 

Forum Statistics
Forums48
Topics2,194
Posts11,872
Members1,258
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,086
bcooper 1,285
delboy 1,251
paulgos 431
SBi 425
Gus 252
pat 249
vkumar 223
November
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.017s Queries: 15 (0.004s) Memory: 2.7344 MB (Peak: 2.8809 MB) Zlib disabled. Server Time: 2017-11-19 12:19:23 UTC