Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 Planning5
MSS_ECM_SEL_DIRDirect Reports3
MSS_ECM_SEL_FLTFilter Employees6
MSS_ECM_SEL_LISEmployees from Organizational Units1
MSS_ECM_SEL_REVEmployees for Approval7
MSS_ECM_SEL_SEAEmployee Search4
MSS_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

Former Member
Not what you were looking for? View more on this topic or Ask a question