How to delete OrderClose, OpportunityClose & QuoteClose Activities?

(0) Share

Report

Posted on by AlexJohnH

We have been having on-going issues with database storage, mainly the ActivityPointerBase table growing in size. We managed to get a decent breakdown from Microsoft Support showing us that the OrderClose, OpportunityClose, CaseClose & QuoteClose activities are the highest counts on the ActivityPointerBase table.

Here is an example of the OrderClose activity:

I don't see any benefit to keeping these system generated activities, but I cannot delete them via bulk deletion as the Activities table is not an option as seen in the below screenshot:

I then created a cloud flow to try and delete these records but ran into an error message stating that I cannot delete these activities because the table does not support this method:

Here is the logic I'm using in the flow:

It lets me delete these activities via advanced find - but I would like an automated method.

All responses (1)

Answers (1)

Verified answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (1)

Report

RE: How to delete OrderClose, OpportunityClose & QuoteClose Activities?

Hi,

Instead of using Activities in Delete A Row action, you will have to choose Opportunity close/QuoteClose/Case close based on Activity type code from List rows.

You will have to add check condition and define various delete Action for each entity types .

You can not directly use Activities in Delete action.