Solved

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

  • 17 April 2023
  • 2 replies
  • 150 views

Badge +4

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

icon

Best answer by AsankaGaru 17 April 2023, 17:24

View original

2 replies

Userlevel 6
Badge +11

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.

 

Badge +4

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