APP-FND-01926 - The custom event WHEN-LOGON-CHANGED raised unhandled exception. ORA-06508 PL/SQL could not find program unit being called

byHimanshu -May 16, 2013

This error occurs while opening Forms in Oracle Applications.

Reason:This issue accurs mostly after Upgrade/Clone of applications.The invalid objects in Custom.pll, form throws an error when opened.

Solution:Compile Custom.pll using the below command to generate Custom.plx. Always make sure to backup the previous CUSTOM.plx

Syntax:
f60gen module=$AU_TOP/resource/CUSTOM.pll userid=APPS/APPS output_file=$AU_TOP/resource/CUSTOM.plx module_type=library batch=no compile_all=special

4 Comments

UnknownApril 18, 2014 at 4:25 PM
Hi Himanshu,

In my case i take bounce of adfrmctl.sh and issue resolve

We can try before compiling the .pll

Thanks
Altaf S
Kpit Cummins ADSC Apps DBA :-)

ReplyDelete
Replies
AnonymousJune 17, 2015 at 8:41 PM
Thanks Altaf, it resolved my issue.

Thanks,
Najeeb
KPIT cummins apps DBA.
ReplyDelete
Replies
HimanshuMarch 1, 2017 at 8:03 AM
Hi Ashik,

The form you are trying to launch is a Custom one!! Please check the code as it seems it is picking a wrong datatype in place of number.
Please also check your CUSTOM.pll file , it might have got corrupted.

Regards,
Himanshu
ReplyDelete
Replies
SabrinaOctober 5, 2018 at 5:22 PM
I really like your blog post very much.
ReplyDelete
Replies