My Oracle Support Banner

MFS MP: Manages Mobile Users Concurrent Program Completed With Error While Creating A New User "ORA-00001: unique constraint (CSM.CSM_FND_LOBS_ACC_U2) violated" (Doc ID 2123963.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Mobile Field Service - Version 12.1.3 and later
Information in this document applies to any platform.


"Manages Mobile Users" concurrent program completed with error while creating a new mobile user in MFS MP (Mobile Field Service Multiplatform).

Error: User Creation Error: XXXXXXX java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CSM.CSM_FND_LOBS_ACC_U2) violated
ORA-06512: at "APPS.ASG_HELPER", line 147
ORA-06512: at line 1

"Manages Mobile Users" concurrent program should create new mobile user for MFS MP without any error.


The issue can be reproduced with the following steps:
1. Login the Oracle Application.
2. Navigate to R) Mobile Field Service Administrator > View > Requests
3. Run the "Manages Mobile Users" concurrent program with "Create Users = Yes" and "Create multiple Platform User = Yes " parameters.
4. Program completes with above mentioned error.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.