1. Workflow Tools Guide
  2. Understanding the Purge Process

Understanding the Purge Process

When a JD Edwards EnterpriseOne workflow process runs, the system creates entries in the following tables:

  • Process Instance (F98860)

  • Task Instance (F98865

  • PPAT Message Control File (F01131)

  • PPAT Message Detail File (F01133)

  • JDEM Multi Level Message (F011131M)

  • Message Attachment Tag File (F01131T)

  • Media Objects Storage (F00165)

Note: PPAT is an acronym for People, Places, and Things.

If you choose to have your workflow process retain these records for historical purposes, the files may become very large and occupy storage resources. The presence of large amounts of data in the tables will also hinder performance of the JD Edwards EnterpriseOne Workflow engine. You should purge workflow data files periodically to minimize the amount of data in the tables and recover disk space. You can purge completed tasks or completed processes. Purging completed tasks deletes Action and Information tasks and Work Center messages associated with these tasks, whereas purging completed workflow processes deletes process instances.

It is recommended that you purge completed processes regularly to minimize the amount of data in the tables. This process only purges records that do not affect active processes in the system and purges F98860 and F98865 records that possess a status of complete, terminated, or error.