My Oracle Support Banner

Manages Mobile User Program (MMU) Errors: ORA-06510: PL/SQL: unhandled user-defined exception - ORA-06512: at APPS.ASG_HELPER (Doc ID 1084129.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Mobile Field Service - Version 11.5.10.2 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


Goal

This note provides guidelines on how to investigate the cause of the following error, which occurs when running the Manages Mobile Users concurrent program:

User Creation Error: <USER_ID> 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 caused by a data-issue, 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.

Bug 5188746 and Bug 5694256 deal with this error for a case where the program tries to find addresses linked to service requests, but those addresses are not party addresses but only known as HZ locations. Patch 5694256 fixes that for 11.5.10. But there are other cases possible, often caused by some kind of data corruption. As new causes are found for the error, they will be added to <Note 1093420.1> - Known Causes For Manages Mobile Users Program to Fail With: ORA-06510: PL/SQL: unhandled user-defined exception.  This living document can be used as a point of reference to avoid rediscovery. When the steps below assist in finding an undocumented cause for the error, then a comment to <Note 1093420.1> with cause, verification steps and solution would be helpful to the entire MFS community.

Solution

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
Goal
Solution
 Generic Debugging
 Get fileversions
 Example of Indepth Investigation.
References


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