E1: WRKFLW: Frequently Asked Questions on Purging Work Center Messages
(Doc ID 1329669.1)
Last updated on AUGUST 15, 2023
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.1 and laterInformation in this document applies to any platform.
Purpose
This document provides answers to some of the frequently asked questions on purging Work Center Messages. It also describes in detail the procedure to purge Work Center Messages using the R01131P Purge Program.
Application Release 9.2 Only
Download latest ESU of R01131P. Review 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).
Questions and Answers
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
| Purpose |
| Questions and Answers |
| General |
| Question 1: In what tables are the Work Center Messages stored? |
| Question 2: Why do Work Center Messages need to be Purged? |
| Question 3: How to Purge Work Center Messages? |
| R01131P - Purge Completed Tasks |
| Question 1: How do I use the R01131P - Purge Completed Tasks UBE report to purge messages in the Work Center? |
| Question 2: How can I purge a particular Queue/Mailbox Messages in Work Center? |
| Question 3: How do I purge an acted upon Work Center Message? |
| Question 4: How do I purge daily Work Center Messages using DateToday[SL] in Data Selection of R01131P? |
| Question 5: Is there a way to only purge Work Center Messages older than 30 days? |
| Question 6: Can we purge the Work Center tables manually instead of running Work Center Purge Program (R01131P)? |
| Question 7: Why does R01131P not Delete certain Records or all Records from F01131 and F01133 tables ? |
| Question 8: Why does the R01131P sometimes run very slowly? |
| Question 9: When running the R01131P should we only get a blank PDF report? |
| Question 10: The R01131M deleted 10,000,000 records from F01131M and then ended with a memory violation error on the PDF. Why? |
| Orphan Records |
| Question 1: On the Xe/ERP 8 Releases Only, why are we seeing orphan records in the F01131M table? |
| Question 2: How To Use the R01131M to Remove Orphan Records in the F01131M, F01131T and F01133 Work Center Tables? |
| Question 3: How does the R01131M determine if orphaned records are deleted? |
| Question 4: Why there are orphan records in F00166? |
| Question 5: R01131M is still running after a very long time, for the last 5 hours. How do I stop R01131M? |
| References |