Purging Old Transactional Data From MWM RSI Tables (Doc ID 1563272.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.0.1 and later
Information in this document applies to any platform.

Goal

Is purge functionality provided to limit the number of historical records in the database?

For instance, table M1_TO_DEV_STATUS has +300000 records and it seems that the running time for M1-RSIBP processes is greatly affected by this.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms