FSTP Error: 'ORA-00904' When Attempting To Drill Down On A Service Request (Doc ID 1403074.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to open a Service Request, using the hyper-linked SR number displayed on this screen, the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.

 
Drilling into the error:

## Detail 0 ## java.sql.SQLSyntaxErrorException: ORA-00904: "CHARGEEO"."ACTIVITY_END_TIME": invalid identifier

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. FSTP Responsibility
2. Display today's tasks
3. From one of the tasks select the SR hyper-link

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