Table Type DFF Value Sets Were Not Restricted To Be Downloaded to MFS Client, Which Causes Performance Issue.

(Doc ID 2370660.1)

Last updated on MARCH 07, 2018

Applies to:

Oracle Mobile Field Service - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Multiplatform

ACTUAL BEHAVIOR
---------------

Client is not able to complete the initial login/installation for MFS client.
Frequently they are getting:
'Unable to locate server. Please try after some time'

When checkeing the sync details table and it was found the download process was stuck at
Flexfield PI. And each mobile user had about 250K records in CSM_TABLE_FLEX_VALUE_ACC

EXPECTED BEHAVIOR
-----------------------
expect less results in csm_table_flex_value_acc and avoid the performance issue

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create tasks in Enterprise
2. Do a sync


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