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

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