This content has been marked as final. Show 5 replies
Ok, let me get this. Looks like you are trying to generate a Intercompany AR Invoices and you hit the ORA-01722.
What is looks like is that the code is trying to convert a string into a number however this fails due to the fact that this string is holding none numeric characters (letter, spaces, special char's). What you might want to do is check if there is somewhere a none numeric character in a field where you would expect only numbers.
Somewhere during the string to number conversion you have your issue so it is most likely data related.
Similar error mention at below notes,pelase review:
Create Intercompany AR Invoices Failing With App-Fnd-01564: Oracle Error 1426 In Inilcoi() [ID 1301558.1]
Error 'ORA-01426: numeric overflow' Occurs while Running Create Intercompany AR Invoice Program [ID 1233843.1]
ORACLE Error 3149 When Run Create Intercompany AR Invoices [ID 1469322.1]
941250 wrote:If no workaround is mentioned in any of the docs, then you need to apply the patch to fix the issue. You may log a SR and ask for a workaround (if any exists).
Thanks for update,
But in all mentioned docs, there is a bug and we are not in a position to apply patch immediately. is there any workaround. Moreover this issue is in Create Intercompany AP
and also it used to come earlier also, but used to get resolved by itself in next run.