Failed Mobile LPN Receiving Transactions get Stuck in RCV_TRANSACTIONS_INTERFACE
(Doc ID 358984.1)
Last updated on NOVEMBER 09, 2023
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:
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
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |