ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Bilal Sami Ur Rahman , IT Supply Chain Service Manager , MYNaghi & Bros Group - FMCG Sector
تاريخ النشر: 2016/01/17

Unpaid leave and purchased leave to be run from Oracle payroll

Alaa AbdlHady
من قبل Alaa AbdlHady , payroll accountant , Kuwait institute for scientific researches

oracle payroll for leaves to deduct from sallary

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
من قبل 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.

 

 

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟