Remote Messages Failures After Environment Data Refresh Due To Missing PK_VALUE1

(Doc ID 2347783.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Mobile Workforce Cloud Service - Version NA and later
Oracle Utilities Mobile Workforce Management - Version 2.3.0.0.0 to 2.3.0.1.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

Over 9,000 To Dos for Remote Message Errors have been generated in TEST. This looks to be due to the Remote Messages containing stale Remote Messages from devices that have not been used since the database was refreshed. These messages contain Task ID and Crew Shift IDs that do not exist in TEST. Since these contain invalid values, they are not accessible on the To Do List page (displays blank screen) or queryable on the Remote Message Query page and not able to be resolved online.

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