MFS Sync Error: ORA-933 SQL Command Not Properly Ended in Package CSM_DEBRIEF_HEADERS_PKG Procedure APPLY INSERT
(Doc ID 2885176.1)
Last updated on JULY 29, 2022
Applies to:
Oracle Mobile Field Service - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
Service Request and Task Statuses are not getting updated on the server after syncing from the Mobile Field Service client.
STEPS
-----------------------
1 Create a Service Request on the Server with SR Status and Task Status populated.
2 Sync to MFS and Verified SR Status and Task Status are correct.
3 Change the Task Status in MFS and add a debrief install and return to the task
4 MFS Sync Completed normally
5 EBS Processes Uploaded Mobile Data Process Completed normally
6 The Service Request and Task Statuses are not changed on the Server. The original values are unchanged.
ORA-933 SQL command not properly ended in package CSM_DEBRIEF_HEADERS_PKG Procedure APPLY INSERT.
Changes
Apply patch 34058146:R12.CSM.C or any patch with file csmudbhb.pls version120.5.12020000.13.
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 |