Error JBO-27122: SQL error during statement preparation. (Doc ID 1296543.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2013***

Symptoms

On : 12.1.3 version, Debrief / Field Service Report

When attempting to open the Debrief html screen from either the Task or Dispatch Center, the following error occurs.


ERROR
-----------------------

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select fl.meaning,fl.lookup_code from fnd_lookups fl, (
-- Not Required
select 'N' lookup_code,jta.task_assignment_id
from jtf_tasks_b jtb,
jtf_task_assignments jta,
jtf_task_statuses_b jtsb
where jtb.task_id = jta.task_id
and jtsb.task_status_id = jta.assignment_status_id
and ((jtb.task_confirmation_status = 'N')
or (jtb.task_confirmation_status = 'R'
and greatest(nvl(jtsb.working_flag,'N'),
nvl(jtsb.completed_flag,'N'),
nvl(jtsb.closed_flag,'N')) = 'N')
or (jtb.task_confirmation_status = 'C'
and greatest(nvl(jtsb.schedulable_flag,'N'),
nvl(jtsb.planned_flag,'N'),
nvl(jtsb.working_flag,'N'),
nvl(jtsb.completed_flag,'N'),
nvl(jtsb.closed_flag,'N')) = 'N')) union all
-- Required

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as the Field Service Dispatcher, (or other suitable responsibility).
2. Navigate to the Dispatch Center, and select a task.
3. (Using the right mouse button) select the Debrief option.
4. Note the error which appears.

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