RF31011P - Lean Transactions - Purge

The volume of records create by lean transactions can be significant. To forestall performance problems, use this program to purge lean transaction records from the primary tables and move them to corresponding archive tables.

Based on the master transaction ID, you can purge and archive both active and canceled transactions. A transaction is active if you have performed a completion against a daily plan from Demand Flow Manufacturing or a JD Edwards EnterpriseOne Shop Floor plan, or if you have performed an ad hoc completion. If you have reversed a completion, the transaction has a status of canceled.

If you select a master transaction ID for archiving, the system archives all related transaction records and deletes the transaction records from their respective tables. If you select to archive a subassembly transaction, you can archive all transactions related to the corresponding master transaction ID, or you can archive only the selected transaction.

Note: If the purge process does not clear existing data from the primary tables or fails to copy all selected data to the archive table, the system issues an error message.

The archiving process moves transaction records from these primary tables to the corresponding archive tables:

Primary Table	Archive Table
Transaction ID Master File (FF31011)	Purge - Transaction ID Master File (FF31011S)
Lean Transaction Parts List (FF31111)	Purge - Lean Transaction Parts List (FF31111S)
Routing Transaction Table (FF31112)	Purge - Routing Transaction Table (FF31112S)
Lean Transaction Labor Detail (FF31113)	Purge - Lean Transaction Labor Detail (FF31113S)