OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » MPS/MRP workbench return "No Data Error"

Home » Applications » Oracle Fusion Apps & E-Business Suite » MPS/MRP workbench return "No Data Error" (Oracle MRP, 12.1.3, Linux)

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

MPS/MRP workbench return "No Data Error" [message #570763]

Thu, 15 November 2012 08:25

achieving
Messages: 2
Registered: November 2012

Junior Member

When I open the MRP or MPS workbench for the plan, one error pops up, showing:

ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-01403.

Even I cannot release the PR or work order.

Is there anyone know this issue?

Report message to a moderator

Re: MPS/MRP workbench return "No Data Error" [message #570777 is a reply to message #570763]

Thu, 15 November 2012 11:34

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

Senior Member
Account Moderator

Can you edit a form and see what's in the WHEN-NEW-RECORD-INSTANCE trigger?

Report message to a moderator

Re: MPS/MRP workbench return "No Data Error" [message #571321 is a reply to message #570777]

Fri, 23 November 2012 05:50

achieving
Messages: 2
Registered: November 2012

Junior Member

Hi, I cannot see the form. It is a new installed vision instance, do you have any suggestion?

Report message to a moderator

Re: MPS/MRP workbench return "No Data Error" [message #572142 is a reply to message #571321]

Thu, 06 December 2012 08:29

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

I cannot see the form

What do you mean by this?
If you have server access, you can check the form.
Get the form name from the Help menu -> About Oracle Applications
Then in go to $AU_TOP/forms/US and open the form.
Don't change the code, it is not recommended.
But check the code to understand which sql is giving the error.

By
Vamsi

Report message to a moderator

Previous Topic:	Getting current form function name
Next Topic:	Disable DELETE button or image on HTML form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 17:44:34 CDT 2023