Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Bilal Sami Ur Rahman , IT Supply Chain Service Manager , MYNaghi & Bros Group - FMCG Sector
Date Posted: 2016/01/17
Deleted user
by Deleted user

Unpaid leave and purchased leave to be run from Oracle payroll

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

oracle payroll for leaves to deduct from sallary

Deleted user
by Deleted user

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
by 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