My Oracle Support Banner

MWM Orders Missing From ORS And Not Being Scheduled or Dispatched (Doc ID 1544174.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version 1.4.5 to 1.5.0 [Release 1.4 to 1.5]
Oracle Real-Time Scheduler - Version 1.12.0 to 1.13.0 [Release 1.12 to 1.13]
Information in this document applies to any platform.

Symptoms

Today, there are ~300 orders in MWM that are not found in the ORS database. These orders are not getting assigned or dispatched.  Dispatchers are manually dispatching these orders as a workaround. The logs do not indicate any crashes or disruptions to the running processes.

MWM and ORS orders were compared with the following SQL:

SELECT B.FO_CMPL_STATUS, B.FO_TRACK_STATUS, B.APPT_START_DTTM, B.APPT_FINISH_DTTM, * FROM MWM.DHTFOCMN A, MWM.DHTFOSCH B
WHERE A.FO_NUMBER = B.FO_NUMBER AND B.FO_NUMBER NOT IN (SELECT STOP_ID FROM ORS.STOP)
AND FO_TYPE NOT IN ('BREAK', 'POU')
AND B.FO_CMPL_STATUS  = 'O'                        ---- Open orders
AND B.FO_NUMBER NOT IN (SELECT STOP_ID FROM ORS.STOP_ARCHIVE)
order BY A.DIVISION, B.SCHED_FROM_DTTM DESC

 

Cause

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
Symptoms
Cause
Solution


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