Who's Online Now
0 registered members (), 6 guests, and 8 spiders.
Key: Admin, Global Mod, Mod
Newest Members
KVS, Andrew, wilts, Renuka, KavyaMurthy
1282 Registered Users
Recent Posts
Notifications not firing
by Administrator. 21/03/19 11:03 AM
Major Organization Restructure
by CT. 12/03/19 11:40 AM
Update employee spinal point via API
by CT. 01/03/19 02:40 PM
Top Posters(30 Days)
CT 4
delboy 3
KVS 2
Popular Topics(Views)
476,922 PAYE RTI
56,642 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12108 - 28/02/18 02:57 PM Balance Retrieval  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
Hello
Anyone using Cloud Payroll?

My client are having issues using the oracle-supplied balance retrieval package as per MOS note 1940275.1
We have serious performance issues in data retrieval, even though we barely have much on the way of payroll run data in the system yet.

Any clues?

Help.

Thanks

#12109 - 05/03/18 08:08 AM Re: Balance Retrieval [Re: bcooper]  
Joined: Mar 2005
Posts: 2,101
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,101
A long shot, I guess, but it sounds vaguely optimisation related.

Do we still have the notion of 'gather schema stats' in cloud land?

Also, if I recall correctly there is (in EBS anyway) an action parameter that tells the system if there is low payroll related data volumes - which I believe somehow controls the optimiser mode. Possibly the balance retrieval functionality makes some kind of use of it?


CT
#12110 - 07/03/18 10:38 AM Re: Balance Retrieval [Re: CT]  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
Originally Posted by CT
A long shot, I guess, but it sounds vaguely optimisation related.

Do we still have the notion of 'gather schema stats' in cloud land?

Also, if I recall correctly there is (in EBS anyway) an action parameter that tells the system if there is low payroll related data volumes - which I believe somehow controls the optimiser mode. Possibly the balance retrieval functionality makes some kind of use of it?

Unfortunately a lot of this is now "managed" in the cloud by Oracle themselves.

I am beginning to think that anyone running even a moderately large payroll would be crazy to go into the cloud - there is so much control you lose...


Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,219
Posts11,988
Members1,283
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,101
delboy 1,294
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
March
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.025s Queries: 15 (0.004s) Memory: 2.7490 MB (Peak: 2.8942 MB) Zlib disabled. Server Time: 2019-03-26 03:54:43 UTC