My Oracle Support Banner

MFS: Performance Issue Due To Missing Indexes Missing On Mobile Client (Doc ID 1447902.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Mobile Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


On : 12.1.3 version, General / Laptop

When attempting to use MFS Laptop, many pages have performance issue. And it's found that many indexes are missing from MFS client after patching.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in MFS Laptop
2. Try to use some pages
3. Check client database's index info by running:
     select * from all_indexes order by table_name;
    In case it only returned Primary Key indexes; all the non-primary key indexes are missing.

Changes

 

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
Changes
Cause
Solution
References


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