Who's Online Now
0 registered members (), 5 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
AKR, Barry_Test_User, KVS, Andrew, wilts
1284 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
479,764 PAYE RTI
57,301 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,297
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,297
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,297
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,297
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,297
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,297
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,220
Posts11,996
Members1,284
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,103
delboy 1,297
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
May
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 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.031s Queries: 15 (0.007s) Memory: 2.7549 MB (Peak: 2.9103 MB) Zlib disabled. Server Time: 2019-05-24 06:50:32 UTC