Home » Applications » Oracle Fusion Apps & E-Business Suite » frm-40735: WHEN-CREATE-RECORD (r12)
frm-40735: WHEN-CREATE-RECORD [message #408198] Mon, 15 June 2009 04:34 Go to next message
bananaman
Messages: 71
Registered: March 2009
Member
Hi! I'm encountering an error upon accessing the Distribution Sets and Quick Invoices windows. Here is the prompt after attempting to access the above windows:
'FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403'
What is wrong with this? Any suggestion to fix this?
Re: frm-40735: WHEN-CREATE-RECORD [message #408219 is a reply to message #408198] Mon, 15 June 2009 06:18 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Trigger contains code (a SELECT statement) that returns no records - thus ORA-01403 (no data found) error message.

Either make it return some value, or handle current situation in exception handling section.
Re: frm-40735: WHEN-CREATE-RECORD [message #408236 is a reply to message #408198] Mon, 15 June 2009 07:10 Go to previous messageGo to next message
tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India
Member
Metalink note id 435519.1 may help to resolve this issue.

Cheers,
Sara
Re: frm-40735: WHEN-CREATE-RECORD [message #408355 is a reply to message #408236] Mon, 15 June 2009 20:51 Go to previous message
bananaman
Messages: 71
Registered: March 2009
Member
Hi Sara!
The document that you referred to me from metalink is not for POST-QUERY trigger and not for WHEN-CREATE-RECORD trigger. Though I tried to follow the steps from the document, I wasn't able to fix the problem. Are there any other document that you can suggest for this? I tried to search in metalink for solution to this but didn't find exact situation as this.

PS Thanks for the reply.
Previous Topic: bank account creation
Next Topic: AP_FINAP_NOT_DEFINED
Goto Forum:
  


Current Time: Tue Dec 06 16:00:39 CST 2016

Total time taken to generate the page: 0.09889 seconds