Purge F01131 Message File

[gerd_renz3]

Hi,

I inherited a routine that periodically purges F01131 and F01133 via SQL command, deleting all entries older then a given date.
Now I saw that there are two more tables, F01131T and F01131M, that are not treated by my SQL purge.

Questions:
1. What is the data in these two tables (F01131T,F01131M)?
2. Should they be treated the same as F01131 and F01133?
3. Has anybody used R01131P (Purge Completed Tasks) successfully? (I was told here that is does not work).

We are on ERP8, HP-UX, Oracle.

Thanks for any answers. Gerd

 

[cncjunior1]

The F01131T and F01131M tables are connected to the F01131 table. They are basically detail tables for the F01131. I have been using R01131P for many years and haven't had many issues. Sometimes I have to run a SQL to clean up a few orphan records it leave behind. Search for any ESUs for the R01131P to make sure you have the latest fixes for it.

 

[gerd_renz3]

Thanks Junior,

your answer is quite helpful to me.

Thanks, Gerd

 

[altquark]

The R01131P did indeed break under some of the ESU's or Updates - but I believe that it then got "fixed" later on.

What I recommend is that you modify R01131P (or, preferably, make a copy of R01131P to R5501131P and modify that) - and modify the code (the link is HERE )

That way, you can place the modified report in the scheduler, and run the report every day and it will delete messages older than, say, 90 days old (or whatever value you want).

 

[loue]

We are on ERP 8.0 sp22, after applied ESU 6878, R01131P then purged records clean