Mobile Field Service Sync Activity Monitor Page Receives Error JBO-27122: ORA-00942: table or view does not exist

(Doc ID 2393174.1)

Last updated on APRIL 30, 2018

Applies to:

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

Symptoms

On : 12.1.3 Multiplatform

When using Multiplatform Mobile Field Service, the following error occurs when attempting to access the Mobile Field Service Sync Activity Monitor responsibility,


ERROR
-----------------------
Error Page

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select ( select count(1)
  from mobileadmin.c$sync_history
  where trunc(start_time)=trunc(sysdate)
  and result<>'SUCCESS'
  and client_id =:1
  and device_platform in ('WCE','WTG')) today_sync,
  ( select count(1)
  from mobileadmin.c$sync_history
  where result<>'SUCCESS'
  and client_id =:2
  and device_platform in ('WCE','WTG')) total_sync,
  ( select count(1)
  from asg_users_inqinfo
  where trunc(CREATION_DATE)=trunc(sysdate)
  and deferred='Y'
  and device_user_name=:3) today_defer,
  ( select count(1)
  from asg_users_inqinfo
  where deferred='Y'
  and device_user_name=:4) total_defer,
  ( select count(1)
  from asg_user
  where enabled='N'
  and user_name=:5) failed_user,
  ( select count(distinct client_id)
  from mobileadmin.c$sync_history
  where trunc(start_time)=trunc(sysdate)
  and finish_time is not null
  and finish_time >= start_time
  and client_id=:6
  and device_platform in ('WCE','WTG')) synched_user,
  (select round(avg(finish_time-start_time)*86400)
  from mobileadmin.c$sync_history
  where trunc(start_time)=trunc(sysdate)
  and finish_time is not null
  and finish_time >= start_time
  and client_id=:7
  and device_platform in ('WCE','WTG')) avg_time,
  (select round(max(finish_time-start_time)*86400)
  from mobileadmin.c$sync_history
  where trunc(start_time)=trunc(sysdate)
  and finish_time is not null
  and finish_time >= start_time
  and client_id=:8
  and device_platform in ('WCE','WTG')) max_time,
  to_char(trunc(sysdate)) today
from dual
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select Mobile Field Service Sync Activity Monitor responsibility.

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