The Notorious NullPointerException

Personally, I'm really fond of errors...but this one can get a little messy!! I'll be picking out one particular case here.

Scope - Oracle Applications 11.5.10.2

Issue - One particular user gets the NullPointerException right after login.

Analysis - The below query

select * from icx_custom_menu_entries where user_id = (select user_id from fnd_user where user_name ='user')

returns two entries corresponding to the user where one of the entries had the Prompt and URL field null(yes, the culprits!)

Similar issue has been documented in bug 4866881; this is a Data Corruption issue.

Solution - Create a backup of table icx_custom_menu_entries

create table icx.icx_custom_menu_entries_bak as select * from icx_custom_menu_entries

Extract the user id of the concerned user

select user_id from fnd_user where user_name ='user'

Delete the offending entry from the table

delete from icx_custom_menu_entries where user_id='userid' and prompt is null

And life’s good again!!