By Kabeer Khan on Sunday, 22 November 2015
Category: Apps DBA

Error: FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-04062

Issue

Following errors are coming in almost all forms after installing Oracle E-Business Suite Release 12.2.4 VM under Oracle Virtualbox:

ORA-01403: no data found

FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-04062

Resolution

Compile the following items using adadmin utility:

1. Libraries

2. Messages

3. JAR Files

4. All SQL and PL/SQL

5. Forms

Shutdown and restart both DB Tier and Apps Tier. Retry and the error will be gone.

Environment

+ Oracle E-Business Suite Release 12.2.4

+ Oracle Linux x86-64

+ Oracle Virtualbox VM under Windows 7 host

Leave Comments