My Oracle Support Banner

Item Template form (INVIDITM.fmb) Fails With Errors ORA-01403/ FRM-40735: ON-LOCK Trigger Raised Unhandled Exception ORA-04062 When Selecting Organization (Doc ID 2337909.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Oracle Item Master - Version 12.2.3 and later
Information in this document applies to any platform.


When trying to enter or select an organization in the Item Template form (INVIDTMP.fmb), the following error messages appear:

NOTE: While this error was reported in R12.2, recompiling a form is always a valid option/troubleshooting technique for resolving errors such as the ones reported here.


ORA-01403: no data found
FRM-40735: ON-LOCK trigger raised unhandled exception ORA-04062


  1. Navigation: Inventory > Setup > Items > Templates
  2. Open the Organization LOV or enter a value manually and receive the error message.


Patches were applied.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.