APP-FND-01926 ORA-06508

I was upgrading Oracle Apps 11.5.10.2 to R12 and faced an issue with forms soon after applying Pre-requisite patches

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

The issue can be reproduced at will with the following steps:

1. Login to http://hostname.domain:port/OA_HTML/AppsLocalLogin.jsp
2. Navigate to any forms-based application

After applying new patches, the forms and pl/sql libraries were not regenerated.

  1. Tried copying source CUSTOM.pll from backup
  2. re-compiling existing $AU_TOP/resource/CUSTOM.pll
  3. Copy and re-compile CUSTOM.pll
None of the above three helped in my case.

Finally, I did the following

1. Use adadmin and generate JAR files with force option.
2. Use adadmin and run Generate Form Files and PL/SQL Library Files

Forms started working!

Advertisements

About mpoojari
Oracle Database/Applications Administrator

One Response to APP-FND-01926 ORA-06508

  1. Thank you for this. I just upgraded from R12.2.4 to R12.2.7 and also upgraded RDBMS from 11.2.0.4 to 12.1.0.2 and began having this same error. I too tried recompiling the CUSTOM.pll but still same error. I’m running adadmin now to see if generating the JAR with force will fix. Thanks again

    Benny

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: