MSS- ECM planning overview and Planning screen-Taking Way too long -EHP6/NWBC HTML*Tough one**
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.
- Expanding planning overview page - 200+ Direct reports - 2 minutes
- "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_ALL||Employees for Compensation Planning||5|
|MSS_ECM_SEL_LIS||Employees from Organizational Units||1|
|MSS_ECM_SEL_REV||Employees for Approval||7|
|MSS_ECM_SEL_TRE||Employees from Organizational Structure|
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.
Saquib Khan, PMP