F4209 Purge

[vlaria]

Hello all,
We have reached 25000 records in the above table and it goes pretty slow when releasing orders. Does anybody know if it is possible to purge records?
Thanks

 

[slandess]

If not needed for historical purposes, the records in the hold file that
have already been released (HORDC <> ' ' ) can be purged from the file any
time.

I work on World version A 7.3, and there is not a history file for these
transactions in this version of JDE. I'm not sure if XE has a history file
for order holds, but if you want to preserve the records for historical
purposes it is easy enough to create a history file that has the same record
layout as F4209 (maybe call it F4209H) and copy these records to the history
file _before_ deleting them from F4209.

Steve Landess

----- Original Message -----
From: "vlaria" <[email protected]>
To: <[email protected]>
Sent: Tuesday, January 21, 2003 10:25 AM
Subject: F4209 Purge


pretty slow when releasing orders. Does anybody know if it is possible to
purge records?Thanks
list/forum.



Steve Landess
V4R4 A7.3 cume9
EDI
(512) 423-0935

 

[ame]

Do you want to save off the records or do you want to just blow them away?
If you want to get rid of them totally you could use SQL or Oracle to do
that.. however if you want to keep the records you would have to create
something as far as I know...






We have reached 25000 records in the above table and it goes pretty slow
when releasing orders. Does anybody know if it is possible to purge records?
Thanks


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

 

[adri_valentim]

Hi,

I'm not aware of any purge. I either get a developer to write a UBE or do it using SQL. Delete records older than 3 months that have been approved. It would be nice if JD Edwards would write a purge for that table.

 

[ame]

well in world they had a program P00PURGE that you could set up the based on
file and create a versions for each file to purge... unfortunately they
didn't make that in OW...







I'm not aware of any purge. I either get a developer to write a UBE or do it
using SQL. Delete records older than 3 months that have been approved. It
would be nice if JD Edwards would write a purge for that table.


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

 

[Larry_Jones]

Hi Victor,

what do you mean by "... releasing orders."?

Most processing uses the F4211 (SO Detail) table. How many records do you have in that table?

 

[vlaria]

Hello,
Orders that are held by Credit are stored on F4209 table. When you release them there is a change on the release Code but the record is not deleted.
For F4211 table, there is a purge report (R4211P) that moves records to another table (F42119, I think). Have you or someone done it? My F4211 table hold around 80000 records now.
Thanks

 

[Larry_Jones]

Hi Victor,

We weren't happy with the criteria R4211P uses so my co-worker wrote a SQL script to move SO detail from F4211 to F42119.

Regards,