My Oracle Support Banner

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

Last updated on MARCH 26, 2018

Applies to:

Oracle Warehouse Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Inventory Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
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

To view full details, 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 a vibrant support community of peers and Oracle experts.