My Oracle Support Banner

JBO-27122 oracle.jbo.SQLStmtException - When Trying To Open User Information In Multi Platform Administrator (Doc ID 2117489.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When attempting to search with the User name, the following error occurs.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT devreg.device_id,
  devreg.mobile_os,
  devreg.status,
  devreg.push_enabled,
  devreg.registration_id,
  asg.user_name,
  asg.creation_date,
  max(sync.start_date),
  sync.device
FROM ASG_USER asg,
  (SELECT mreg.device_id,
  mreg.user_name,
  mdis.mobile_os,
  mapp.status,
  mapp.push_enabled,
  mreg.registration_id
  FROM FND_MBL_NOTIF_REGISTRATIONS mreg,
  FND_MBL_APPLICATION mapp,
  FND_MBL_DISTRIBUTIONS mdis
  WHERE mapp.application_short_name = 'CSM'
  AND mapp.application_id = mdis.application_id
  AND mreg.application_distribution_id = mdis.application_distribution_id
  ) devreg,
  csm_html5_sync_info sync
WHERE asg.user_name = devreg.user_name(+)
AND asg.enabled = 'Y'
AND asg.multi_platform = 'Y'
AND asg.user_name = sync.user_name(+)
GROUP BY devreg.device_id, devreg.mobile_os, devreg.status, devreg.push_enabled, devreg.registration_id,
asg.user_name, asg.creation_date , sync.device
ORDER BY asg.user_name) QRSLT WHERE (UPPER(USER_NAME) LIKE :1)

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

at oracle.apps.csm.adminUI.util.AsgVOAbstract.runQuery(AsgVOAbstract.java:108)
at oracle.apps.csm.adminUI.util.AsgVOAbstract.runQuery(AsgVOAbstract.java:113)
at oracle.apps.csm.adminUI.device.webui.CsmOADevRegCO.processFormRequest(CsmOADevRegCO.java:78)

STEPS
1. Login to Oracle Apps.
2. R) Mobile Field Service Administrator -> Multiplatform -> User Information
3. Enter any user -> Click 'Go', get the above mentioned exception.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.