DeadLock Error (ORA-0060) Occurs when Running Receiving Transaction Processor RVCTP (Doc ID 1407987.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 12.1.2 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

A DeadLock error (ORA-0060) occurs when running the Receiving Transaction Processor (RVCTP).

From the Log file the error is as follows:

ERROR
-----------------------
RVCTP module: Receiving Transaction ProcessorCause:
RVCTP encountered an internal error. Parameters: RVCTP,BATCH,15963,106,
Action:
RVTBM-007: Subroutine rvtbm_batch_mngr() returned error
Cause: Subroutine rvtbm_batch_mngr() returned an internal error.
Action: Note this error number and the actions you are trying to
perform. Contact your
syste
RVTBM-080: 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
RVTLO-050: ORA-00060: deadlock detected while waiting for resource
Cause: A SQL error has occurred in RVTLO. The SQL error is
&LSQL_ERR.

The dead lock error occurs between RVCTP and APXIIMPT.

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