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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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


STEPS TO REPRODUCE
-------------------------------------

 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,
  lookup.tag
  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(OAException.java:912)
  at  oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
  at  oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247)
  at  oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
  at _OA._jspService(_OA.java:228)
  at  com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
  at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)

 
 

 It is expected the end user is informed that is not able to re-submit the job, instead of displaying the Generic 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