Problem Opening a Shift in the Mobile Workforce Managment Admin Tool Due to Invalid Status Values in the Database (Doc ID 557859.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 1.4.5 and later   [Release: 1.4 and later ]
Information in this document applies to any platform.

Symptoms

An error is received when attempting to Update crew shift information via the Mobile Workforce Management (MWM) Admin Tool.  In the Oracle Realtime Scheduler (ORS) database, there is a SHIFT_BREAK record for this crew whose status was INACTIVE. This was the only record in this table, which contains many records, that had this status. Since the SHIFT_BREAK record was for yesterday, it was felt it would not affect ORS if this status was manually changed to COMPLETED as the other SHIFT_BREAKs for yesterday were statused for other crews. Then tried to open the crew's shift via the Admin Tool and it was then successfully opened. Do not know how this crew's shift_break was set to INACTIVE. All changes have either been made via the Admin Tool or perhaps ORS can set them.

-- Business Impact:
Can not update a crew's shift information when this problem occurs.

Cause

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