Home » Applications » Oracle Fusion Apps & E-Business Suite » ORA-01403 FRM-40735: PRE-FORM in custom form
ORA-01403 FRM-40735: PRE-FORM in custom form [message #563819] Fri, 17 August 2012 05:59 Go to next message
Messages: 2
Registered: August 2012
Location: India
Junior Member
HI Team,

I have designed a custom form and deployed in Oracle CRM.

On click of the new custom form I am getting this message "ORA-01403 no data found"

Then click of details button getting

ORA-01403: no data found

FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06502.
But the strange thing I observed is , It is working fine in other system.

Can anybody tell me , what could be the reason behind this??

Do I need to make some setup change OR to check any prerequisites.. (System Specific) ?

Re: payments [message #564767 is a reply to message #563819] Tue, 28 August 2012 10:02 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What is the code you have in PRE-FORM ?
When you mean "It is working fine in other system", is it other PC or other instance?

Re: payments [message #564960 is a reply to message #564767] Wed, 29 August 2012 14:16 Go to previous message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator

ORA-06502: PL/SQL: numeric or value error string

Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).

Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

"Other system" maybe used valid value (for example, there was a NUMBER datatype form item and "other system's user" entered 1 into it (which was actually a string, '1' and Oracle implicitly converted it into 1, a number). However, "this system's user" entered A (which is really 'A') into it and implicit conversion resulted in ORA-06502.
Previous Topic: Error While Running Depreciation in Oracle Fixed Asset
Next Topic: Error When create new emplyee
Goto Forum:

Current Time: Tue May 28 14:54:50 CDT 2024