Purge Omnichannel Events

Use the Purge Omnichannel Events scheduled process to purge the SVC_OMNI_EVENTS table.

This process deletes records in the SVC_OMNI_EVENTS table that are older than the specified number of days. The retention period is specified using the profile option SVC_OMNI_EVENTS_RETENTION_DAYS.

When to Use

This process is used reduce space in the database consumed by Omnichannel events. Running this scheduled process removes all events that are older than the specified period. Scheduling this process effectively limits the Omnichannel reports to the time window represented by the number of days passed into the process.

Privileges Required

Verify that you have the following privilege or role:

  • FUSION_APPS_CRM_ESS_APPID user

Before You Start

Review the following before scheduling this scheduled process:

  • Recommended Frequency:

    • The frequency is dictated by your data retention requirements.

    • If you must retain only 30 days of data, you can run the job every day.

  • Execution Time:

    • This job should complete fairly quickly. But the execution time is dependent on the amount of data being deleted.

  • Compatibility:

    • This job doesn't affect the performance of the running system.

Parameters

There are no parameters to run this scheduled process. This process uses the SVC_OMNI_EVENTS_RETENTION_DAYS profile option to control the size of the retention window.

Troubleshooting Information

Use this information to troubleshoot the scheduled process.

  • If the job fails, the next run should pick up and delete any data older than the specified retention period.