Support for Hard Delete Refresh for Rollups

A hard delete means physically deleting rows from rollup tables in the source database, instead of soft deleting them which means marking them as deleted but not removing them. A refresh then follows which updates the rollup tables to reflect changes (inserts, updates, deletes) in the source data and maintains rollup data consistency.

To enable this feature, you must create the ZCA_ENABLE_ROLLUP_HARD_DELETE_REFRESH profile option and set the value to Y. Navigate to Setup and Maintenance > Sales > Sales Foundation > Manage Administrator Profile Values to create this profile option.

Once enabled, there are certain limitations for supporting a hard delete refresh for rollups. For example:

• If a rollup that you want delete from the rollup table is already published, you must first unpublish it and then publish it again to use this feature. See the Remove Rollups section in this playbook for more information.
• If you're running a Rollup Full Refresh scheduled process for your rollups you must include the Refresh for Deleted Records parameter and set the value to Y.

• If rollup hard deletes are imported, then they won't get refreshed by running the Rollup Incremental Refresh job because this job is associated with the Signals feature. For example, if the Rollup Incremental Refresh job is run more than 7 days from the last successful run, or if it has failed for more than 7 days, then a hard delete refresh won't be possible because Signals data is purged after 7 days.