index for PY_PULL_COST

Here is the code to create the index.

create index PS2WRK_XREF_CALC4 on PS_WRK_XREF_CALC4(process_instance,emplid,

empl_rcd,dur,dilute_lbdst_flag,lbr_dist_amt,orig_seq_nbr ) tablespace psindex

After we test and confirm that this helps then we can add it to app designer and create it thru proper channel.

Thanks,

Murali

Can you rerun PY_PULL_COST in HCM90UAT? I have created a new index that may speed up the process. I want to know how much we gain. Let me know if you have any questions.

The traces are completed for PY_PULL_COST and PYDDAUSA in HCM90UAT. However, I am unsure if you have access to this environment to view the traces.