When doing a production receipt, quantity 1000 can be received while 2000 generates an error. The only difference the received quantity, no idea why it is related to characters.
Solved
ORA-06502 error on Production Receipt
Best answer by Nikila Dis
Hi
This is a generic error that could occur due to several reasons. All the scenarios are covered in the below artical:
-
Overflow Error: You may be trying to assign a value to a numeric variable that exceeds its maximum limit.
-
NULL Assignment: You might be attempting to assign a NULL value to a variable that has a NOT NULL constraint, which violates the rules.
Once possible option is: can you please enable the debug window , take the server invoke from there and run it on the PL SQL Developer. Then view the program source error stack. It will give you some hints to identify the exact place.
If not it's challenging to determine the exact cause without additional information. If you’re still unsure how to resolve the issue, raising a support case would be the best option. They can provide more targeted assistance.
Regards,
Nikila Dissanayake
+9Hi
This is a generic error that could occur due to several reasons. All the scenarios are covered in the below artical:
-
Overflow Error: You may be trying to assign a value to a numeric variable that exceeds its maximum limit.
-
NULL Assignment: You might be attempting to assign a NULL value to a variable that has a NOT NULL constraint, which violates the rules.
Once possible option is: can you please enable the debug window , take the server invoke from there and run it on the PL SQL Developer. Then view the program source error stack. It will give you some hints to identify the exact place.
If not it's challenging to determine the exact cause without additional information. If you’re still unsure how to resolve the issue, raising a support case would be the best option. They can provide more targeted assistance.
Regards,
Nikila Dissanayake
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.