Exception Encountered When Trying To Add New Material Lines In Debrief While Using Field Service Technician Portal Responsibility
(Doc ID 2088920.1)
Last updated on FEBRUARY 06, 2022
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document