US Payroll taking long timeto execute - 13,000 Employees - 17 Hours :-(

[former_member181966]

Good  afternoon Everyone,

Our SAP payroll run is taking too long to execute ten payroll areas. It is taking altogether 17 hours. I have found the OSS notes below, and I want to reach out to fellow SCNs, and see what parameters you are using at your clients and/or company? What others avenues, we should explore. We don’t have any custom code. We are also using payroll job splitter.

2041117 - Various performance improvements in payroll process

2136385 - Performance improvements: Preparation in the logical database PNP

SAP_HR

604

0085

SAPKE60485

Human Resources

Old

New

SAP Note 2033053 - 'Performance and ABAP dump issues after upgrade'

      SAP Note 2019794 - Improved performance of the class CL_HR_PAYROLL_RUN

      SAP Note 2030347 - Program termination when selecting personnel number multiple times using the logical database PNP/PNPCE

      SAP Note 2087413 - Payroll: Performance improvement by initializing buffers

      SAP Note 2041117 - Various performance improvements in payroll process (When implementing this SAP Note, make sure SAP Note 2086485 is implemented too, as it corrects a side-effect of SAP Note 2041117)

      SAP Note 2086129 - TAX: Performance Enhancement for HCM US Payroll

Thanks in advance for your invaluable input(s).

Thanks & Regards,

Saquib Khan,PMP

“Complaints don’t change culture, actions do!” – Saquib Khan

[former_member235056 · Accepted solution]

Hi Saquib,

Parameters in as mentioned by you are same for our clients.

I wanted to check that did you try running program RPCSC0000 for 10-15 jobs at once?

What is your server load and processes available for use.

These parameters also needs to be considered when payroll is being run.

Please check the system load with admininstrator before you start running payroll.

Thanks,

Ameet

[former_member181966 · Accepted solution]

Yes, we are running 10 -15 jobs at once, and it is taking all of the processes available. We will check with our Basis Admin.

Thanks,

Saquib Khan, PMP

[former_member181966 · Accepted solution]

Hello Everyone,

    We`ve tried five iterations, and experienced very minor change. Open for more suggestion(s).

Thanks,

Saquib Khan, PMP

[former_member235056 · Accepted solution]

Hi Saquib,

Was there any new custom rules or functions added to your schema?

You should give a try using SAP delivered standard schema and see if it also gives you same issue.

Also, was there any exits or BADIs implemented for any functionality as it could cause issues too if not coded well?

Two things you will need to do to see whats causing this issue if none of above applies.

1. Check system load when running the payroll driver. Ask your Basis team to monitor the system load and run the scripts of performance issues and load.

2. Check with your ABAP developer to run Runtime Analysis and SQL Trace to understand how much ABAP and Database memory code is consuming and then you can discuss this out if required with SAP via OSS notes to get a note to improve performance.

Thanks,

Ameet