Home » Applications » Oracle Fusion Apps & E-Business Suite » trigger error
trigger error [message #544447] Tue, 21 February 2012 19:26 Go to next message
charanyevadu
Messages: 17
Registered: February 2012
Junior Member
select OPM Financial Super user => click on Cost Rollup => and give folloing details. After click on accept got error and then click on 'Details' got trigger error.
  • Attachment: Cost1.JPG
    (Size: 100.22KB, Downloaded 1189 times)
Re: trigger error [message #544464 is a reply to message #544447] Wed, 22 February 2012 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this a question? Or, did you answer someone else's question (incorrectly, though, as you opened a new topic instead of "replying" in existing one)?
Re: trigger error [message #544465 is a reply to message #544464] Wed, 22 February 2012 00:13 Go to previous messageGo to next message
charanyevadu
Messages: 17
Registered: February 2012
Junior Member
that one is question dude i am getting the mentioned error.

Iam justing giving the navigation for that.

[Updated on: Wed, 22 February 2012 00:14]

Report message to a moderator

Re: trigger error [message #544469 is a reply to message #544465] Wed, 22 February 2012 00:23 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From my point of view (note that I don't use Oracle Apps.), form author didn't pay attention to exception handling and one of SELECT statements returned nothing and you got NO-DATA-FOUND as a result. What should you do? No idea; do you know who wrote that form? If so, contact him/her. If it is part of the Suite, perhaps you should contact Oracle Support.

By the way, what is the result of the "Details" button pressed?
Re: trigger error [message #544472 is a reply to message #544469] Wed, 22 February 2012 00:35 Go to previous messageGo to next message
charanyevadu
Messages: 17
Registered: February 2012
Junior Member
ORA-01403: no data found.

FRM-40735: WHEN-BUTTON PRESSED trigger raised unhandled exception ORA-06502.
  • Attachment: cost2.JPG
    (Size: 99.38KB, Downloaded 1203 times)
Re: trigger error [message #544479 is a reply to message #544472] Wed, 22 February 2012 00:55 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-06502: PL/SQL: numeric or value errorstring

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.


I'm not sure that you can do much without form's author.
Re: trigger error [message #544483 is a reply to message #544479] Wed, 22 February 2012 01:12 Go to previous messageGo to next message
charanyevadu
Messages: 17
Registered: February 2012
Junior Member
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.




I didn't get you where exactly i need to change the data whether in the form or tables related. Can explain me bit clear what i can do.
Re: trigger error [message #544486 is a reply to message #544483] Wed, 22 February 2012 01:36 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure that YOU can do anything about it. A trigger raised an exception, which was unhandled.

This error says that - just for example - CALENDAR value in your form, which is NC12 at the moment, is to be stored into a VARCHAR2(3) column. Obviously, that won't work (as NC12 has 4 characters).

Check whether all values you entered into a form are meaningful and correct.

If you think that everything is OK, I'm afraid that I don't have any other ideas.

HOWEVER: as I said - I don't use Oracle Apps. Wait a little bit longer until someone who actually uses it sees your question. The answer might be completely different from what I think it is.
Re: trigger error [message #544487 is a reply to message #544486] Wed, 22 February 2012 01:45 Go to previous message
charanyevadu
Messages: 17
Registered: February 2012
Junior Member
I checked and everything seems to be fine with the input data. Ny how thanks for your suggestion and looking forward for someone who and help me out
Previous Topic: Oracle Report Output not generated
Next Topic: No One Knows? Help on OAB Fast Formula Testing
Goto Forum:
  


Current Time: Mon Dec 23 05:54:08 CST 2024