Failed Mobile LPN Receiving Transactions get Stuck in RCV_TRANSACTIONS_INTERFACE (Doc ID 358984.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 11.5.10.2 and later
Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor


Symptoms

Mobile Intransit LPN Receipts error and get stuck in RCV_TRANSACTIONS_INTERFACE table if there are multiple shipments having the same shipment number.  (i.e.: Create two internal shipments with different source and destination org with the same shipment_num with packed LPN, then performing receipt of shipment)

The same error occurs when performing direct express receipts against a shipment that have multiple lines with the same item, there may be multiple MTL_MATERIAL_TRANSACTIONS records created after the transaction completes.
(i.e.:  a. Perform Misc receipt of an item into LPN A with qty 4.  Do another Misc receipt of another item into LPN B with qty 10; b.Create intransit shipment, entering LPN A FIRST, then LPN B SECOND; then c. In the destination org, perform express receipt of LPN B.)

Receiving Interface Errors report shows errors as follows:

ERROR:

Error in Shipment Line Information (in RCV_TRANSACTIONS_INTERFACE)
Column Name   INTERFACE_TRANSACTION_ID
Error Message  LPN validation failed. Please check log for details.

Column Name  INTERFACE_TRANSACTION_ID
Error Message WMSINB-18557:LPN validation failed. Please check log for details.  or
                        WMSINB-19139:LPN validation failed. Please check log for details.

Column Name  UNIT_OF_MEASURE
Error Message  Specified Unit Of Measure conversion to primary UOM not defined
                     (SHIPMENT UNIT OF MEASURE = Carton : PRIMARY UNIT OF MEASURE = Each)

Column Name   INTERFACE_TRANSACTION_ID
Error Message  RVSSH-020: ORA-1403: no data found
Cause:    A SQL error has occurred in RVSSH.  The SQL error is &LSQL_ERR.
Action:    Take note of both this error number and the actions you were

Receiving Transaction Processor (RVCTP) log shows the generic errors as follows:

Concurrent program RVCTP returned error
Cause:    RVCTP encountered an internal error.  Parameters: RVCTP,IMMEDIATE, 36288,
Action:    Note both this error number and the actions you are trying to perform. Contact your system adm

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
Cause:    Subroutine rvtptcontrol() returned an internal error.
Action:    Note this error number and the actions you are trying to perform. Contact your system administrator

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