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.
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.
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.
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.
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.
Yes, thank you. The issue is solved.
A common error to occur whiling 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.
Thanks For Sharing...MCDVOICE
