Who's Online Now
0 registered members (), 11 guests, and 7 spiders.
Key: Admin, Global Mod, Mod
Newest Members
muralirac, Mooo, Tony Park, Jithen, Ganesh
1311 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
516,095 PAYE RTI
65,271 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12153 - 13/06/18 02:05 PM Retropay Enhanced Performance Issues  
Joined: Mar 2005
Posts: 1,311
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,311
Somewhere in South of England
The retropay process has never been the speediest process in payroll. We thought Oracle had resolved the problem when they introduced enhanced retropay. Indeed it did at first, shaving hours off the time. However, we now seem to be back into the realms of retropay increasing again month on month. From a process originally running for about 6 hours, our latest process took 39 hours.

has anyone had similar issues, and if so, have you resolved it?

#12162 - 05/07/18 12:31 PM Re: Retropay Enhanced Performance Issues [Re: delboy]  
Joined: May 2009
Posts: 12
JNA Offline
newbie
JNA  Offline
newbie

Joined: May 2009
Posts: 12
Gloucestershire
Delboy,

Consider running gather stats. Also look at Generate Run Balances. If you do not do these already and need more info let me know.

John.

#12163 - 05/07/18 03:17 PM Re: Retropay Enhanced Performance Issues [Re: JNA]  
Joined: Mar 2005
Posts: 1,311
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,311
Somewhere in South of England
Thanks John,

We have since raised an SR and they have given us an action plan. We are currently working through this in our test environment.

#12165 - 17/07/18 06:06 AM Re: Retropay Enhanced Performance Issues [Re: delboy]  
Joined: Mar 2005
Posts: 1,311
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,311
Somewhere in South of England
Seems the action plan worked. Performance was improved by 60%. The plan included gather stats and generate run balances as well as a couple of patches and a datafix.......Happy Days!


Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,230
Posts12,039
Members1,312
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,120
delboy 1,311
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
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.024s Queries: 15 (0.007s) Memory: 2.7550 MB (Peak: 2.9106 MB) Zlib disabled. Server Time: 2021-09-23 10:58:49 UTC