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 JULY 14, 2020
Applies to:
Oracle Field Service - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
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.
ERROR
-----------------------
"You have encountered an unexpected error. Please contact the System Administrator for assistance."
Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT distinct
CsfPoTaskAssignmentsEO.TASK_ASSIGNMENT_ID,
CsfPoTaskAssignmentsEO.TASK_ID,
CsfPoTaskAssignmentsEO.RESOURCE_TYPE_CODE,
CsfPoTaskAssignmentsEO.RESOURCE_ID,
CsfPoTaskAssignmentsEO.ASSIGNMENT_STATUS_ID,
CsfPoTaskAssignmentsEO.ASSIGNEE_ROLE,
TaskEO.TASK_ID AS TASK_ID1,
TaskEO.TASK_NUMBER,
TaskEO.TASK_STATUS_ID,
.
.
.
## 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)
STEPS
-----------------------
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
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |