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.
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?
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...