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
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
The task retention policy determines how long to keep completed tasks. The default task retention period is seven days and the maximum task retention period is thirty days. An instance administrator can configure the task retention period in Instance Settings. For more information, see Configuring Workflow Settings in Oracle APEX Administration Guide.
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.
Parent topic: Managing Approvals