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 FEBRUARY 03, 2022

Applies to:

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:

 
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

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