My Oracle Support Banner

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 JULY 14, 2020

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.