My Oracle Support Banner

Manage Mobile Users Error: "ORA-00001: Unique Constraint CSM.CSM_PO_LOC_ASS_ALL_ACC_U1 Violated" (Doc ID 1063202.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Mobile Field Service - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


After running "Manages Mobile Users" concurrent program, several users are still disabled.  Following error is generated:

6867482: User creation error: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CSM.CSM_PO_LOC_ASS_ALL_ACC_U1) violated
ORA-06512: at "APPS.ASG_HELPER", line 179
ORA-06512: at line 1

Issue continues to reproduce after removing and re-adding "Oracle Mobile Field Service" responsibility to the affected users.

The issue can be reproduced by running the "Manages Mobile Users" concurrent program.


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.