Receiving Transaction Error for Intransit InterOrg Transfer (Doc ID 1279865.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Inventory Management - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to perform Receipt for Inter organization Transfer it completes with the following messages in the concurrent log file:

Concurrent program RVCTP returned error

Cause: RVCTP encountered an internal error. Parameters: RVCTP,IMMEDIATE,8300,

Action: Note both this error number and the actions you are trying to perform. Contact your system administrator
RVTBM-008: Subroutine rvtbm_immediate_mngr() returned error

Cause: Subroutine rvtbm_immediate_mngr() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your syste
RVTBM-120: Subroutine rvtptcontrol() returned error


If you switch on Debug for the Inventory Product, you can see from the debug output that the error actually relates to Unit of Measure Conversion:

INV_ROI_INTEGRATION_GRP: Before calling INV_CONVERT.Within_deviation
INV_ROI_INTEGRATION_GRP: p_quantity 25
INV_ROI_INTEGRATION_GRP: p_quantity2 25.0002
INV_ROI_INTEGRATION_GRP: p_unit_of_measure1 Piece
INV_ROI_INTEGRATION_GRP: p_unit_of_measure2 Piece
INV_ROI_INTEGRATION_GRP: Program INV_CONVERT.Within_deviation return
INV_ROI_INTEGRATION_GRP: Program INV_CONVERT.Within_deviation has failed



The Primary UOM Code for the Item in this example is 'Carton', and the Secondary Unit is 'Piece'.

This InTransit Receipt transaction was entered using the Secondary Unit of Measure, and because the Conversion Factor between Piece and Carton is 180, the calculated Primary Quantity is 0.1388 (recurring), saved as 0.13889.

What has happened is that even though the Secondary Unit of Measure Quantity should be assumed to be correct (because it was user-entered) the system has attempted to recalculate the Secondary Quantity based on the rounded Primary Quantity, and this error is the result.

You can actually observe the same thing happening in the INV Miscellaneous Receipt form if you enter the transaction in the Secondary Unit where the above rounding will occur - when you save the transaction, the Secondary Quantity will be updated away from the entered value.

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