Skip to main content
Solved

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

  • April 17, 2023
  • 2 replies
  • 280 views

Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 6 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.

 

2 replies

Forum|alt.badge.img+12
  • Hero (Partner)
  • 196 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)
  • 6 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