Time Windows Displayed On Activity UI Maps And Time Windows In DB Don't Match (Doc ID 1553711.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

The Time windows displayed on the Display Activity UI map and the time windows displayed when you EDIT the activity are shown in different time zones and the time stored in the DB is a different time zone.

Steps to Recreate the problem.
1. Create a FA, View the Time windows when the FA is created.
2. EDIT the FA created and view the time windows.
3. Run a query and view the time window stored in the DB is all different (select * from M1_TASK_TM_WIND where task_id = '1122334455').

How should the time zone be configured on the MWM app and DB?

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