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
Million Knowledge Articles and hundreds of Community platforms