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.

Symptoms

ACTUAL BEHAVIOR
"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


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

STEPS

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.


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
Cause
Solution
References


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.