My Oracle Support Banner

What is the Best Practice for Purging Messaging Tables in MWM? (Doc ID 2249306.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Oracle Real-Time Scheduler - Version 2.1.0 and later
Information in this document applies to any platform.

Goal

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

MWM - Oracle Utilities Mobile Workforce Management
ORTS/ORS/ERTS - Oracle Real-Time Scheduler
FK - Foreign Key
RSI - Remote Scripting Invocation

 

What is the best practice for deleting rows from the following tables:


  F1_OUTMSG
  F1_OUTMSG_K
  F1_OUTMSG_ERRPARM

  M1_REMOTE_MSG
  M1_REMOTE_MSG _LOG_PARM
  M1_REMOTE_MSG _LOG
  M1_REMOTE_MSG _CHAR
  M1_TO_SERVER

  M1_TO_DEVICE
  M1_DEV_CTXT
  M1_TO_DEV_STATUS

  M1_SRVR_CTXT
  M1_SRVR_STATUS

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.