Trying To Unmatch An Invoice Is Giving The Error Divisor Is Equal To Zero
(Doc ID 2967477.1)
Last updated on AUGUST 14, 2023
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version NA to 19.3 [Release No Release to 19.3]Information in this document applies to any platform.
Symptoms
In one particular invoice, when trying to unmatch the invoice so it can be deleted afterwards, it throws the error "sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01476: divisor is equal to zero@2SHIPMENT_API_SQL.DEDUCT_INVOICE_QTY_MATCHED ORA-01476: divisor is equal to zero".
This invoice cannot be used and has one item matched to the receipt. Business needs to delete invoice since it is incorrect and after that needs to enter the correct invoice.
ERROR
-----------------------
"sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01476: divisor is equal to zero@2SHIPMENT_API_SQL.DEDUCT_INVOICE_QTY_MATCHED ORA-01476: divisor is equal to zero".
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Have a invoice matched with has at least two receiving lines and one of them the quantity received is zero.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |