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***

Symptoms

On : 12.1.3 version, Debrief / Field Service Report: when attempting to access the Debrief screen from Service Request page, 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, (
....
## 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. Create a Service Request on Service Request form.
2. Click the Debrief button to open Debrief html page.

Changes

 

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