Skip to main content
Solved

POCO - Update Purchase Order - ORA-06502: PL/SQL: numeric or value error


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 5 replies

A user is attempting to update a purchase order with a change to one line (line 5). On using the RMB ‘Update Purchase Order’ on the Purchase Order Change Order screen he receives an error

Debug console shows that the error is thrown by this function in Change_Purchase_Order_Line_API

As the error is thrown within Change_Purchase_Order_Line_API, is it finding a non-numeric in the line number or somewhere else?

Thanks in advance

Andrew

Best answer by AsankaGaru

Hi,

Do you have support from IFS?

From my experience at IFS, PL/SQL: numeric or value errors almost all the time end up being bugs, that are fixed by RnD.

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+11
  • Hero
  • 193 replies
  • Answer
  • April 17, 2023

Hi,

Do you have support from IFS?

From my experience at IFS, PL/SQL: numeric or value errors almost all the time end up being bugs, that are fixed by RnD.

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • April 17, 2023

Hi Asanka. I was wondering if it might be a bug as it wasn’t clear where the error was coming from. We do have IFS support so I may pass it to them to investigate. Thanks for the reply


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings