Wednesday, September 2, 2020

FRM-40735: PRE-BLOCK TRIGGER RAISED UNHANDLED EXCEPTION ORA-4068

 Dear Folks,

The title error we have encountered when we tried to access the form (Orders, Returns)

Navigation - Order Management Super User--> Orders, Returns--> Order Organizer

It may due to  schema / PL/SQL code timestamp mismatches in your environment.


ML - 981240.1
++++++++++

1. set _disable_fast_validate=TRUE in init.ora file and restart the DB in upgrade mode.
2. Invalidate all the objects - @$ORACLE_HOME/rdbms/admin/utlirp.sql
3. Recompile all the objects - @$ORACLE_HOME/rdbms/admin/utlrp.sql
4. Restart DB in normal mode. 
5. Confirm there are no more timestamp mismatches with the query.
$ORACLE_HOME/rdbms/admin/utldtchk.sql

After above work around. We are able to open form.

Thanks.
Sreeharsha