avatar image
Former Member

MSS- ECM planning overview and Planning screen-Taking Way too long -EHP6/NWBC HTML*Tough one**

Hello Everyone,

   We are experiencing long time, when loading planning overview page for Org units, as well as when selecting good chunk of org units and "hit" planning.

  1. Expanding planning overview page - 200+  Direct reports - 2 minutes
  2. "Planning" - 200+  Direct reports - 1.5 minutes.

I have done performance trace (ST05) as a test ID , and system is reading HRP1001 9000 times ( open/fetch) / HRP1000  5000 times, PLOGI ( 1500 times).  ( 8000 eligible employees with 1100 org units - Expanding all)

We have also coded an enhancement spot for "HRWPC_RFC_OADP_EVAL_DATAVIEW" to set  CACHEMAXAGE  = '30'. Also change V_TWPC_ORGVWG_P sequence of "MSS_ECM_SEL" group.

MSS_ECM_SEL_ALLEmployees for Compensation Planning5MSS_ECM_SEL_DIRDirect Reports3MSS_ECM_SEL_FLTFilter Employees6MSS_ECM_SEL_LISEmployees from Organizational Units1MSS_ECM_SEL_REVEmployees for Approval7MSS_ECM_SEL_SEAEmployee Search4MSS_ECM_SEL_TREEmployees from Organizational Structure

2

http://scn.sap.com/message/6920615

We are also looking at class CL_HRECM00_PLANNING_SERVICES method GET_INFO_FOR_ORGUNIT, thinking to create a staging table to load all of the org units via custom background job, and put an enhancement spot and  have system read it from Z staging table. ( The job needed to run every 10 minutes at CEO level), not sure if it is a better soloution.

Also looked at OSS note - 1974957 - Performance with HRP1001 table. General troubleshooting guide. 

We have also coded 20% custom code in "HRECM00_PLANNING_OVERVIEW", and 5% in HRECM00_PLANNING_UI to handle our company specific business rules.

Note: We have implemented a hybrid  solution very similar to ECM "deep approval."

We are using MSS via NWBC HTML ( EHP6).

Any ideas will be appreciated.

Thanks,

Saquib Khan, PMP

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 30, 2014 at 12:42 AM

    can you take a trace using ST12 ie HTTP trace in this and perform the above actions in portal you can capture ABAP or DB time where most time is spent http://wiki.scn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis Whats your EA HR level? There were some notes release to improver performance

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Siddharth Rajora

      Thanks Sid. We have already schedule the program (RHBAUS00) in production  for the all the managers who have more than 5 direct reports.

      On the side, for the merit planning overview screen,  we did change our custom code to reduce number of recursive calls. I will test and update you the results.

      Thanks,

      Saquib Khan, PMP

Skip to Content