Exception Encountered When Trying To Add New Material Lines In Debrief While Using Field Service Technician Portal Responsibility

Last updated on MARCH 08, 2017

Applies to:

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

Cause