E1: WRKFLW: R01131P Is Leaving a Lot of Orphan Records in F01131M Table and R01131M Report Needs to Be Run Each Time After R01131P
(Doc ID 2771447.1)
Last updated on APRIL 28, 2021
Applies to:JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.
Each time when running R01131P to purge the Work Center messages, there is a huge number of orphan records left in F01131M. In order to clear the orphaned records, it is required to run R01131M. Both UBE runs are taking a lot of time to purge the records just because there are a lot of records to be purged.
Checking the debug logs, there is no significant delay when records are fetched or deleted from tables used by Work Center (F01131, F01131T, F01131M, F01133, F00165 and F00166).
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