Creating Standard Appraisal - Error: SQLStmtException: JBO-27122: SQL error during statement preparation ORA-00942: table or view does not exist (Doc ID 819754.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Talent Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Performance Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked For rrelevance on 27-JAN-2013***
***Checked For rrelevance on 07-JUL-2014***

Symptoms

S

When attempting to create an appraisal for an employee from Manager Self-Service, the following occurs:

ERROR

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lp.LEARNING_PATH_ID,
lp.BUSINESS_GROUP_ID,
lp.PERSON_ID,
lp.SOURCE_ID,
lp.SOURCE_FUNCTION_CODE,
lp.ASSIGNMENT_ID,
lp.DISPLAY_TO_LEARNER_FLAG,
lp.NAME,
lp.NOTIFY_DAYS_BEFORE_TARGET,
lp.PUBLIC_FLAG,
lp.PATH_SOURCE_CODE,
lpe.PATH_STATUS_CODE,
lpe.CREATOR_PERSON_ID,
lps.LEARNING_PATH_SECTION_ID,
lpe.LP_ENROLLMENT_ID,
lpe.PERSON_ID AS LPEPERSON_ID,
lpe.LEARNING_PATH_ID AS LPELEARNING_PATH_ID,
lpe.BUSINESS_GROUP_ID AS LPEBUSINESS_GROUP_ID,
lpe.PATH_STATUS_CODE AS LPEPATH_STATUS_CODE,
lpe.ENROLLMENT_SOURCE_CODE AS LPEENROLLMENT_SOURCE_CODE,
lpe.CREATOR_PERSON_ID AS LPECREATOR_PERSON_ID,
lps.LEARNING_PATH_ID AS LPSLEARNING_PATH_ID,
lps.BUSINESS_GROUP_ID AS LPSBUSINESS_GROUP_ID,
lps.COMPLETION_TYPE_CODE AS LPSCOMPLETION_TYPE_CODE,
lps.NAME AS LPSNAME,
lp.START_DATE_ACTIVE
from ota_learning_paths_vl lp,
ota_lp_enrollments lpe,
ota_lp_sections_vl lps
where nvl(lp.source_id, -1) = nvl(:1, -1)
and lpe.person_id = :2
and lp.path_source_code = 'TALENT_MGMT'
and lp.source_function_code = :3
and lpe.learning_path_id = lp.learning_path_id
and lps.learning_path_id = lp.learning_path_id
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:209)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:131)
at
oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:7
48)
at
oracle.apps.per.selfservice.compgaps.webui.ActivitiesGapsCO.processRequest(ActivitiesGapsCO.java:83)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:525)
....
## Detail 0 ##
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627)
.......



Steps To Reproduce:

The issue can be reproduced at will with the following steps:

  1. Go to Responsibility: Manager Self-Service > Function: Talent Management
  2. From the left-side menu select: Create Standard Appraisal
  3. Select an employee, click the Action icon
  4. Enter Setup details and click Next
  5. Unexpected error occurs

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