My Oracle Support Banner

Manages Mobile Users Program (MMU) - Know Causes Of Failure With: ORA-06510: PL/SQL: unhandled user-defined exception (Doc ID 1093420.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Mobile Field Service - Version to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Executable:ASG_USER_CONC - Manages Mobile Users


This note is intended to be a living document to record known causes for the Manages Mobile Users concurrent program (MMU) to fail with the following error when trying to create a mobile user:

User Creation Error: 105027603 java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.ASG_HELPER", line 177
ORA-06512: at line 1

This error is very generic. It can have many different causes.  In general it is a data-issue that is causing it, often for only one or a few records. The error occurs when MMU is trying to create the user and finding/populating all required data for that user in the access tables.

There is a note that can be used to take action on investigating this error:
<Note 1084129.1> - How To Investigate MMU failing with ORA-06510: PL/SQL: unhandled user-defined exception

The standard FND debug information does not always point to the exact problem so further debugging is required. The steps to do that involve changing seeded code, which is rather invasive. To minimize the rediscovery effort, this note will be used to document all causes found for this error so the known cases can be checked before debugging further.


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
 1. Invalid Address on the Service Request
 2. billing_category for existing debrief_line_id  is NULL
 3. Invalid Objects

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