Application Error When Unmatching Invoices Having One Item with Qty_received = 0 (Doc ID 2994748.1)

Last updated on DECEMBER 22, 2023

Applies to:

Symptoms

Application error occurs, when user tries to "Unmatch" an Invoice.

The invoice was matched at Summary Level. The shipment againts the invoice was matched has one item and this item with severals records in SHIPSKU table for different

CARTONS, and some of those records have with QTY_RECEIVED = 0.

IN logger logs table the follow error is recorded:

sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01476: the divisor is equal

to zero@2SHIPMENT_API_SQL.DEDUCT_INVOICE_QTY_MATCHED

Steps to Recreate:

1. Create a Purchase Order(PO) in RMS with one item.

Ex.: QTY_ORDERED = 100 and some of those CARTONS with quantity received = 0.

Ex: Carton1 = 25

      Carton2 = 25

      Carton3 = 25

      Carton4 = 25

2. In RWMS ,Navigate to Container checking Screen > Delete the cartons Carton1 and Carton2.

    Carton 1 = 0

    Carton 2 = 0

    Carton 3 = 25

    Carton 4 = 25

3.Create an Invoice in REIM with the Item with no discrepancies.

4.Navigate To “Task  Invoice Matching  Summary Match” and Match the invoice at Summary Level.

The invoice is matched successfully.

5.Now, try to UNMATCH the invoice from “Task  Invoice Matching  Match Inquiry Search screen”.

The following error raises: An Application error occurs.

LOGGER_LOGS table data:

sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01476: the divisor is equal

to zero @2SHIPMENT_API_SQL.DEDUCT_INVOICE_QTY_MATCHED

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.