Debrief HTML Error: JBO-27122 While Accessing HTML Page After R12.1.3 Upgrade

(Doc ID 1347379.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 01-AUG-2016***


On : 12.1.3 version, Debrief / Field Service Report: when attempting to access the Debrief screen from Service Request page, the following error occurs:


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, (
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
at oracle.jbo.server.QueryCollection.buildResultSet(
at oracle.jbo.server.QueryCollection.executeQuery(

The issue can be reproduced at will with the following steps:
1. Create a Service Request on Service Request form.
2. Click the Debrief button to open Debrief html page.




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