Unable to Receive Internal Requisition / ISO RVTII-077 ORA-01476: Divisor is Equal To Zero (Doc ID 1442168.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.2.3 [Release 12 to 12.2]
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to receive Intransit Shipment linked to Internal Requisition  / Internal Sales Order  the following error occurs.

RVTII-030: Subroutine rvtiicreate() returned error
Cause: Subroutine rvtiicreate() returned an internal error.
Action: Note this error number and the actions you are trying to perform. Contact your system administrator fo
RVTII-077: ORA-01476: divisor is equal to zero


The output of the Receiving Data Collection Script for the internal requisition shows

PO_REQUISITION_HEADERS
  Requisition_Header_Id 1723505
  Segment1 3010293
  Type_Lookup_Code  INTERNAL
  Org_Id 766

PO_REQUISITION_LINES
  Requisition_Line_Id 1802253
  Requisition_Header_Id 1723505
  Line_Num 48
  Quantity 0  
  Source_Type_Code INVENTORY
  Item_Id 448446
  Cancel_Flag N
  Source_Organization_Id 545
  Destination_Type_Code INVENTORY
  Destination_Organization_Id 767
  Quantity_Cancelled 0

PO_REQ_DISTRIBUTIONS
  Distribution_Id 1904516
  Requisition_Line_Id 1802253
  Req_Line_Quantity 0

OE_ORDER_LINES 
  Line_Id 7724874 
  Header_Id 1966117
  Line_Number 48
  Cancelled_Quantity 0
  Ordered_Quantity 8400 
  Fulfilled_Quantity 8400
  Inventory_Item_Id 448446
  Source_Document_Type_Id 10
  Orig_Sys_Document_Ref 3010293
  Source_Document_Id 1723505
  Orig_Sys_Line_Ref 48
  Source_Document_Line_Id 1802253
  Cancelled_Flag N
  Open_Flag N
  Booked_Flag Y
  Fulfilled_Flag Y

Steps
The issue can be reproduced at will with the following steps:
Navigate to Enter Receipts RCVRCERC form
. Search for Internal Requisition
. Select line and save
RVCTP completes in error

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms