19.6.9 About Task Retention and Task Purging

Learn about task retention, task purging, and the Archive of Purged Task Files Report.

The Approvals Component can create tasks with complex payloads. This means task data can grow exponentially, causing space and performance overloads. Periodically purging task data prevents overloading the system.

Task Retention Logic

A DBMS_SCHEDULER job runs on a daily basis to check all records in the task instance table. When DBMS_SCHEDULER runs, it:

• Keeps created, unassigned, and assigned tasks.
• Purges completed tasks with a retention period that is less than or equal to the current date.
• Purges errored and canceled tasks. Errored and canceled tasks do not have a retention period.

The Archive of Purged Tasks Report saves a JSON document of tasks that are eligible for purge. After the report is generated, the tasks eligible for purge are cleaned up.

Task Retention Settings

Task Retention Settings are visible under Workspace Preferences, Approval Settings. The default setting is 7 days, and the maximum setting is 30 days.

Archive of Purged Task Files Report

The report of tasks that have been purged by the Task Purge job is located in Workspace Administration. For more information, see Accessing the Monitor Activity Page in Administration Services in Oracle APEX Administration Guide.

Files in the Purged Task Files Report area are cleaned up every 30 days.