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?

Report message to a moderator

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: 21823
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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: bank account creation
Next Topic: AP_FINAP_NOT_DEFINED
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 06:42:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.