E1: WRKFLW: Enhancement Request to Improve Performance of Running R01131P for Purging Workflow Messages
(Doc ID 2608080.1)
Last updated on MARCH 19, 2021
Applies to:JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.
When there are huge amount of records in F01131M, the performance of R01131P - Purge Completed Tasks, is very slow.
Here are possible reasons why performance may be slow on the R01131P.
- The processing options and data selection are not being used correctly.
- Work Center has many multi-level messages. Multi-level messages will take longer to delete because R01131P has to use recursive loop to delete.
- F01131M is for storing multilevel parent child messages, it is a recursive table (like employee-manager table), if this table is very large, R01131P will take a long time. R01131P will loop through F01131M for each record selected in F01131.
- One or more Work Center tables are missing an index. Missing index will impact performance greatly.
- Network speed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document