Mobile Field Service Upload Error Page Throw Java Exception

(Doc ID 2096788.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : 12.2.4 version, Mobile Field Service

When attempting to search Deferred uploaded Errors for mobile user,
the following error occurs.

"You haveException Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select a.device_user_name, a.tranid,
  to_char(b.last_update_date, :1) l_date,
  to_char(a.sync_date, :2) sync_date,

The issue can be reproduced at will with the following steps:
1. Log in Oracle Mobile Administrator responsibility
2. Navigate to Mobile Field Service Sync Activity Monitor->Upload Errors->Deferred
3. Enter a User name and try to search the records for this user


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