MFS: Creating Mobile user or Assigning Task To Mobile User Causes Error: ORA-01436: CONNECT BY Loop In User Data
(Doc ID 1468743.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Mobile Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
There are some actions in the application related to Mobile Field Service (MFS) that cause the error ORA-01436: CONNECT BY loop in user data
1. When attempting to run the Manages mobile users program to create a user, an error occurs.
ERROR
-----------------------
User Creation Error: <USERNAME> java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
ORA-06512: at "APPS.ASG_HELPER", line 179
ORA-06512: at line 1
2. When trying to manually assign a task. An error is encountered
ERROR
----------------------
Error returned from Internal API hook.
Procedure name is CSM_WF_PKG.Task_Assignment_Post_Ins. (APPL_ID=883)
STEPS
-----------------------
1. Run Manages Mobile Users (MMU) program to create a Mobile Field Service user.
2. Assign a Task to a Mobile Field Service user.
Changes
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 |
Changes |
Cause |
Solution |
References |