Purchase Order Update Division by Zero Error: Decimal division by zero occurred. (180,109) PO_MISC_WRK.FUNCLIB.FieldFormula Name:prorate_misc_lines PCPC:38416 Statement:511 (Doc ID 2966680.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

Updating a purchase order gives division by zero error:

Error:

Decimal division by zero occurred. (180,109) PO_MISC_WRK.FUNCLIB.FieldFormula Name:prorate_misc_lines PCPC:38416 Statement:511
Called from:PO_LINE_SHIP.QTY_PO.FieldChange Name:do_sched_misc Statement:183
Called from:PO_LINE_SHIP.SHIPTO_ID.FieldChange Name:shipto_id_fc Statement:214
Called from:PO_DFLT_TBL.SHIPTO_ID.FieldChange Name:change_sched Statement:27
Called from:PO_DFLT_TBL.SHIPTO_ID.FieldChange Name:shipto_id_chng Statement:98
Called from:PO_HDR.BUYER_ID.FieldChange Name:update_buyer_flds Statement:256
Called from:PO_HDR.BUY

Steps to Reproduce Issue:

1. In buyers workbench close 1 line on a purchase order with multiple lines
Navigation:
Purchasing > Purchase Orders > Buyer’s Workbench

2. In Add/Update POs Update Buyer ID for the PO in step 1.
Navigation:
Purchasing > Purchase Orders ? Add/Update POs

3. Click Save

Cause

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