RVTII-077: ORA-01476: Divisor is Equal To Zero

Unable to Receive Internal Requisition / ISO RVTII-077: ORA-01476: Divisor is Equal To Zero

The cause of the issue is invalid / incorrect data in tables

Requisition line has Quantity 0 Zero although it has not been canceled.

Root cause for data corruption is not known.

　

　

Work Around : ( i have suggested to the User)

***************

As of now you can close the inventory period by deleting the transaction,

this transaction will not stop the Period closing

ACTION PLAN

-------------------------------------------------------

Dear Gautham,

There is a corruption on your Requisition Lines 4 and corresponding Req distribution.

Then quantity is equal to 0 as it should not be.

Please run the following scripts on a clone instance first.

　

　

UPDATE PO_REQUISITION_LINES_ALL rl SET QUANTITY= (select

sum(ORDERED_QUANTITY) from oe_order_lines_all oel

where rl.requisition_line_id=oel.SOURCE_DOCUMENT_LINE_ID) WHERE

requisition_line_id

=40243;

UPDATE PO_REQ_DISTRIBUTIONS_ALL rd SET Req_line_quantity= (select QUANTITY

from PO_REQUISITION_LINES_ALL rl

where rl.requisition_line_id=rd.requisition_line_id )

WHERE rd.requisition_line_id = 40243

and (select count(1) from PO_REQ_DISTRIBUTIONS_ALL prd where

prd.requisition_line_id=rd.requisition_line_id)=1;

Try to reproduce the Issue