My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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 Procurement Receiving Analyzer <Document 2012304.1> for the Internal Requisition shows:

  Requisition_Header_Id 1723505
  Segment1 3010293
  Type_Lookup_Code  INTERNAL
  Org_Id 766

  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

  Distribution_Id 1904516
  Requisition_Line_Id 1802253
  Req_Line_Quantity 0

  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

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


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

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