RVCTP Kicked Off By LCM Shipments Interface Import Intermittently Fails With Errors: RVTPT-054: ORA-01086 (Doc ID 1926398.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Shipment Workbench

When attempting to receive LCM shipments, the following error occurs intermittently in Receiving Transaction Processor RVCTP log file:

ERROR

 

When debugging further inventory debug log file shows the following errors

[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE:  
p_cas_mol_rec_tb(1).task_id             =>
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE: This is a
PO receipt
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE: Some
other exception occurred! Raising Exception!
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE:
SQLCODE:-54 SQLERRM:ORA-00054: resource busy and acquire with NOWAIT
specified or timeout expired
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE: Exception
occurred at progress: ###
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE: SQLCODE:1
SQLERRM:User-Defined Exception
[08-AUG-14 16:36:08] INV_RCV_RESERVATION_UTIL.MAINTAIN_RSV_RECEIVE: Exiting
maintain_rsv_receive with error: ###
[08-AUG-14 16:36:08] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.127
$): PROCESS_TXN - rsv api returns:E
[08-AUG-14 16:36:08] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.127
$): PROCESS_TXN : - Exception :WMSINB-14998 2014-08-08 04:08:08Error =1
[08-AUG-14 16:36:08] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.127
$): STACKED ERROR MESSAGES :
[08-AUG-14 16:36:08] po.src.rvtp.rvtls.RVTLS.C.end_implicit:          
^--------Implicit Procedure Exit-----^
[08-AUG-14 16:36:08] po.src.rvtp.rvtls.RCV_TRANSACTION_PROC.end_implicit:    
^--------Implicit Procedure Exit-----^
[08-AUG-14 16:36:08] po.src.rvtp.rvtls.RVTTH.C.end_implicit:      
^--------Implicit Procedure Exit-----^
[08-AUG-14 16:36:08] po.src.rvtp.rvtls.RVTPA.C.end_implicit:    
^--------Implicit Procedure Exit-----^
[08-AUG-14 16:36:08] po.src.rvtp.rvtpt.RVTPT.C.4001:     RVTPT:040 Error in
lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint

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