WHEN-VALIDATE-ITEM trigger raise unhandled exception ORA-01422 [message #523136] |
Thu, 15 September 2011 14:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/eff5d06335e6d6b44ff5a85f9b597c63?s=64&d=mm&r=g) |
nik.gujeran
Messages: 11 Registered: July 2011
|
Junior Member |
|
|
Hello Gurus,
I have a small issue that I am not able to figure out.. I have a form (StaffDetail) with three different blcoks. One of them is an Application Assignment block which consists of nothing but Assignment Type, Staff (Name), Last Updated By and Last Updated Date.. The Assignment Type and Staff has LOVs assigned to them individually.. Assignment type lets me pick all different types except for Project Manager. As soon as I select this option, i get the following error :
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception...
This does not even let me select any other Assignment type, then i have to go close all sessions and come back into the same screen. I am stuck with this screen and cannot solve this issue.. Please help me.
Also, this form was first created and tested on the development environment and later moved to QA environment. All selections work in the development environment.. I checked for the roles in QA for individual Users.. This is not a roles issue..
Could you please help me..
thanks
|
|
|
|
|