My Oracle Support Banner

E1: WRKFLW: Frequently Asked Questions on Purging Work Center Messages (Doc ID 1329669.1)

Last updated on FEBRUARY 25, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information 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.

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 in 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?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.