Errors ORA

Hi @Link ,

I believe you are using APP9.

As per the above error stack, we can’t say much information. But, from the given information I can say the error comes when retrieving the status of the Invoice. I might be able to assist you further, if you can send the complete error stack and implementation/code of the even action.

Moreover, kindly mention what is the error you receive?

Yes, we use Apps 9.

OK, that is true. I have deleted the status. Now another one:

at "IFSAPP.FND_EVENT_ACTION_API", line 2070

ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2075

ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1934

ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1954

ORA-06512: at "IFSAPP.EVENT_SYS", line 199

ORA-06512: at "IFSAPP.C_COPY_POSTING_TEXT_EVI", line 18

ORA-04088: error during execution of trigger 'IFSAPP.C_COPY_POSTING_TEXT_EVI'

HI @Link ,

I am really sorry. Unfortunately the given information is not enough to provide an explanation.

As per the above call stack this is a general one, cannot get specific information as the error stack shows an exception has been occurred when executing your SQL statement.

Hi @Link ,

Did you write your UPDATE STATEMENT inside a BEGIN END; section? If not, kindly try and let me know if the issue resolved.

Hi @Link , Could you please share your event action’s code, so we can try to give a better solution for your errors.

Yes I did.

But I haven’t other error messages.

Hi @Link ,

This error occurs when the SQL statement in your event action is wrong. Thus, kindly check if you have passed parameters properly.

Hope this helps.

A common error to occur while using Oracle is the ORA-06502 error message. This is an error that results from a mistake in the arithmetic or the numeric value executed in a statement. ... For instance, say you successfully completed a procedure but when going to execute it the ORA-06502 error message springs up.

Thank you. I could run it in PLSQL developer but not in IFS. Then I’ve changed the code.

Yes, thank you. The issue is solved.

Thanks  For Sharing...MCDVOICE