Last updated on MARCH 08, 2017
Applies to:Oracle Field Service - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Field Service Engineer Portal
When attempting to add a material Debrief line (Install) using Field Service Technician Portal,
the following error occurs.
"You have encountered an unexpected error. Please contact the System Administrator for assistance."
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT distinct
TaskEO.TASK_ID AS TASK_ID1,
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 11
WHAT IS WORKING
When doing a Debrief from Field Service Manager responsibility there is no error (Field Service Manager > My Tasks > for an existing task click Debrief icon > on Debrief page add a new material line under Install > no error)
The issue can be reproduced at will with the following steps:
1. Open the technician portal responsibility and then, for an existing task, go to debrief
2. In the Debrief page, click to add a new material line under the Install section
3. The reported error occurs
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms