OraFAQ Forum: Forms » FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932

Home » Developer & Programmer » Forms » FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932 (Oracle EBS 12.1.2 OS: Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932 [message #483473]

Mon, 22 November 2010 06:31

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

Hi Friends

I installed EBS 12.1.1 and upgraded to 12.1.2. While doing the validation checks one developer found few issues.

1. On edit_item_lot form (INVTDILT.fmx) he got an error as Quote:

ORA-00932 : inconsistent datatype, expected number got data

Details:

ORA-00932: inconsistent datatypes: expected NUMBER got DATE

--------------------------------------------------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932.

2. On find batches form he got an erroras

Quote:

FRM-40735: post query trigger raised unhandled exception ORA-04062

I regenerated the forms using adadmin and also I recompiled the apps schema using adadmin. Still I am facing the same issue. Can any one suggest some solution.

Thanks
Ridhi Sundar

Report message to a moderator

Re: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932 [message #483516 is a reply to message #483473]

Mon, 22 November 2010 11:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Maybe tables' descriptions changed between those two versions, so - what used to be valid before, became invalid now.

I'd check trigger code. Perhaps it is matter of a simple variable re-declaration (and recompilation, of course).

Report message to a moderator

Re: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932 [message #483614 is a reply to message #483516]

Tue, 23 November 2010 08:47

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

which trigger are you speaking of? I even executed utlrp.sql. It validated many objects still the same issue.

Report message to a moderator

Re: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00932 [message #483618 is a reply to message #483614]

Tue, 23 November 2010 09:14

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

The triggers that are raising the errors obviously.

Report message to a moderator

Previous Topic:	how to validate list item
Next Topic:	Forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 18:02:22 CST 2025