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

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