Who's Online Now
0 registered members (), 3 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Sarathy R, pjchiverton, Jampat, sankumar, MAS - HRMS
1255 Registered Users
Recent Posts
Monthly Data Collection
by delboy. 20/09/17 02:31 PM
Costing Proration
by delboy. 20/09/17 12:21 PM
Future dated records and API
by CT. 14/09/17 10:26 AM
Location Extra info API error
by ALERO. 13/09/17 02:52 PM
Fusion OSP/OMP Setup Guidance Request
by delboy. 11/09/17 05:39 AM
Faster Payments
by pat. 07/09/17 10:29 AM
11i or R12.1.x to R12.2.x Upgrade
by CT. 06/09/17 06:44 AM
Incrementing parameter in scheduled request
by ClanGowland. 04/09/17 10:22 AM
Top Posters(30 Days)
CT 11
ALERO 10
delboy 6
PeterP 3
pat 1
Rashmi 1
Popular Topics(Views)
412,206 PAYE RTI
49,345 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,190
Posts11,857
Members1,255
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,085
bcooper 1,285
delboy 1,249
paulgos 431
SBi 423
Gus 252
pat 248
vkumar 223
September
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.018s Queries: 15 (0.005s) Memory: 2.7373 MB (Peak: 2.8825 MB) Zlib disabled. Server Time: 2017-09-24 15:54:50 UTC