FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001 in R12.1

During our CRP, users received “FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001” and have to login again.
This typically happens when running queries in EBS core forms with the profile “FND: Enable Cancel Query” set to “Yes” in order to enable the cancel query functionality. If the “Cancel Query” window is displayed and the user tries to cancel the query, the following error message is displayed:

After working with Oracle support, analyst suggested to apply the patch 9357219 that lead to the problem resolution.
Ofcourse, after applying the patch on forsms home, relink the forms via
make -f install


About Sunthar Tharmalingam
Bio: Sunthar is an Oracle Certified Professional with over 14 years of experience in multifaceted architectural design and implementation of mission-critical global Oracle Applications. He provides technical leadership to the enterprise project teams and manages the comprehensive implementation life-cycle. Sunthar has exhaustive hands-on competencies in vital Oracle technologies such as Oracle E-Business Suite, Databases, OBI Applications, Oracle Identity Management and Webcenter suites. This Blog has been categorized according to the Oracle products that integrates with Oracle E-Business Suite. Should you wish to participate as an author for a related module or category please register as a member and mail me to let me know which category you would like to write under.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: