Optimize Entry Event Process Performance

Create the following indexes in your environment to improve the performance of the Entry Event process:

• Create a new index on PS_KK_SOURCE_HDR with following fields: PROCESS_INSTANCE, KK_SOURCE_TRAN, BUSINESS_UNIT, PO_ID, KK_TRAN_ID, and KK_TRAN_DT.

• Create a new index on PS_KK_REFERENCED with following fields: KK_REFD_ID, KK_REFD_DT, KK_REFED_LN, KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN.

• Create a new index on PS_KK_SOURCE_HDR with following fields: KK_SOURCE_TRAN, BUSINESS_UNIT, KK_PROCESS_STATUS, KK_TRAN_ID, KK_TRAN_DT.

• Create a new custom index on PS_KK_ACTIVITY_LOG with following fields: KK_TRAN_ID, KK_TRAN_DT, EE_PROC_STATUS.

After creating the above indexes, run Update Statistics on the above records.