My Oracle Support Banner

Users Without Privileges: Unexpected Screen Is Appearing After Re-Submitting Any Job (Doc ID 2045315.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.2 and later
Information in this document applies to any platform.


After upgrading from LSH 2.2.1 to LSH 2.2.2, unexpected screen is appearing after resubmitting any job.


 1. Login LSH UI with the user previously created.
 2. Select "Life Sciences Data Hub -> My Home"
 3. Click on the "Administration" tab.
 4. Select "Job Execution" subtab.
 5. In the "Job Administration" page displayed, enter a search criteria so  that the job from Precondition/Step is displayed.
 6. Click on the JOB ID.
 7. Click on "Re-Submit" button. Note the error displayed:

Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details. About Previous Page

  8. Extract from the exception details:

  Exception Details.
  oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
  JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
  (SELECT lov.position AS POSITION,
  lov.value AS LOOKUP_CODE,
  lookup.meaning AS MEANING,
  FROM cdr_lookups lookup, cdr_lov_values lov
  WHERE lov.company_id = :1
  AND lov_id = :2
  AND lov_ver = :3
  AND lov.value = lookup.lookup_code
  AND lookup.lookup_type = :4
  AND (lookup.lookup_code <> '$RUNMODES$INCREMENTAL' OR :5 <> 'N')
  AND (lookup.lookup_type <> 'CDR_BLIND_BREAK' OR lookup.lookup_code <> '$YESNO$YES' OR :6 <> 'N')
  AND (lookup.lookup_code <> '$CURRENCYTYPE$SNAPSHOT' OR :7 <> 'N')
  AND (lookup.lookup_code <> '$CURRENCYTYPE$BACKCHAIN' OR :8 <> 'N')
  AND (lookup.lookup_code <> '$SUBMISSTYPES$TRIGGERED' OR :9 <> 'N'))
  QRSLT ORDER BY position
  at oracle.apps.fnd.framework.OAException.wrapperException(
  at  oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
  at  oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
  at  oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
  at _OA._jspService(
  at  com.orionserver.http.OrionHttpJspPage.service(
  at oracle.jsp.runtimev2.JspPageTable.service(


 It is expected the end user is informed that is not able to re-submit the job, instead of displaying the Generic Exception.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.