Receiving Transaction Processor Going To Deadlock RVSSH-030: ORA-00060: Deadlock

(Doc ID 2103193.1)

Last updated on FEBRUARY 08, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On :  11.5.10.2 version,
 
Receiving Transaction Processor (RVCTP) program is going to deadlock many times during its run.

As the event is random i.e. sometimes twice/thrice times in a day and sometimes twice/thrice in a week.
Also no program is fix i.e. sometimes it goes to deadlock with Planning Manager (MRCRLF) and sometimes with "MPS Relief Worker" sometimes with itself, etc

Possible cause is explained in
<Note 1071727.1> - Receiving Transactions Fail with TM_TIMEOUT or Deadlock

But even with that patching in place the issue continues.

The RVCTP and MRCRLF have been made incompatible but the issue continues to occur.

ERROR
RVTTH-035: Subroutine rvsrv_rcv_match_supply() returned error
Cause:        Subroutine rvsrv_rcv_match_supply() returned an internal error.  
Action:        Note this error number and the actions you are trying to perform. Contact your s
RVSRV-165: Subroutine rvsrvf_process_inv_receive() returned error
Cause:        Subroutine rvsrvf_process_inv_receive() returned an internal error.  
Action:        Note this error number and the actions you are trying to perform. Contac
RVSRV-105: Subroutine rvsshb_remove_shipment_supply() returned error
Cause:        Subroutine rvsshb_remove_shipment_supply() returned an internal error.  
Action:        Note this error number and the actions you are trying to perform.
RVSSH-030: ORA-00060: deadlock detected while waiting for resource
Cause:        A SQL error has occurred in RVSSH.  The SQL error is &LSQL_ERR.


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Perform Receipt
2. Run RVCTP

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