My Oracle Support Banner

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 later
Information in this document applies to any platform.


Service Request and Task Statuses are not getting updated on the server after syncing from the Mobile Field Service client.


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.


 Apply patch 34058146:R12.CSM.C or any patch with file csmudbhb.pls version120.5.12020000.13.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.