Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to improve "Payroll Run" concurrent program performance in Oracle?

user-image
Question ajoutée par Bilal Sami Ur Rahman , IT Supply Chain Service Manager , MYNaghi & Bros Group - FMCG Sector
Date de publication: 2016/01/17
Utilisateur supprimé
par Utilisateur supprimé

Unpaid leave and purchased leave to be run from Oracle payroll

Alaa AbdlHady
par Alaa AbdlHady , payroll accountant , Kuwait institute for scientific researches

oracle payroll for leaves to deduct from sallary

Utilisateur supprimé
par Utilisateur supprimé

Payroll Run is a Concurrent Program, This is a seeded function, But we can always improve its performance by writing efficient Fast Formulas for Earnings and Deductions. For Example Complicated logic while calculating Deductions like Staff Loan, Car Loan or any benefits. For these we need to write Fast Formula's for calculation. Payroll Run Concurrent program When executed it uses all calculation rules, Formulas, No. of Elements for earnings and deductions, No. Employees considered for Payroll run. By calling Functions in Fast Formuala's rather than writing complex coding. Coding Logic should be efficient and simple. The next Performance Fix, Running Payroll Run by assignment set, (ie;) Do not run Payroll for 5000 employees in one Go. Run part by part, so that there will not be much load, so performance Improves, Fast Formula's efficient Logic help Performance

Mudasir Hussain
par Mudasir Hussain , Tariff Analyst Support Officer , United States Agency for International Development (USAID)

During installation and testing of your Oracle Payroll system you may need to turn on the detailed logging options provided with the product. Use the LOGGING parameter to provide a large volume of detailed information that is useful for investigating problems.

Detailed logging options should only be switched on when you need to investigate problems that are not easily identified in other ways. The logging activities will have an impact on the overall performance of the process you are logging. Usually, this feature is needed during your initial implementation and testing before you go live. In normal operation you should switch off detailed logging.

 

 

 

More Questions Like This