Skip to Main Content
Feature Request FR-4150
Product Area Workflow
Status CLOSED

15 Voters

Workflow Purge Days should be optional

gemma wood Public · Dec 12 2024

Idea Summary
Workflows are currently purged as per the blog post https://blogs.oracle.com/apex/post/archiving-human-tasks-and-workflows-in-apex-241

This limitiation makes workflow unusable in a lot of scenarios as while you could do custom reporting on workflow activities, the workflow diagram would no longer render the historic workflow.

There is no such limitation in workflow in a lot of other workflow engines including EBS.

Use Case
Some specific cases we have is that cases are opened, closed and then may need to be re-opened on appeal.  Users would need to look at the history in the same format they could pre-archive purge.  e.g. using the workflow diagram.  This would no longer be possible and the UX would be totally different and it would be diffficult to show complex workflows in reports.  

This would apply to any use case or historic workflow.

Preferred Solution (Optional)
The purge days for workflows should be optional.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Known Duplicates

Known duplicates

FR-4376
FR-4376 Workflow Retention Period Days to indefinite

Comments

Comments

  • rstevenson OP 9 months ago

    Absolutely makes sense!

  • nickolasluan15 OP 6 months ago

    @rstevenson

  • ralf.mueller APEX Team OP 2 months ago

    We are not considering this for now as this might result in indefinite growth of the APEX schema.

    There is a blog on how to implement a strategy for archiving soon to be purged Workflow and Task instances, see https://blogs.oracle.com/apex/post/archiving-human-tasks-and-workflows-in-apex-241

    Regards, Ralf

  • gemma wood OP 3 weeks ago

    I appreciate that potential performance isssues are behind this issue being rejected, but surely Oracle should provide the mechanism to archive the data or at the very least document the API that is used by the APEX team internally so that customers could re-draw a workflow diagram from the archived data?