Deadlock In RVCTP Receiving Transaction Processor RVTLO-050: ORA-00060: RVTCL-040: (Doc ID 1504760.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3 , after upgrade from 11i
Issue presents while attempting to perform 'Manual Drop' for LPNs.
For every single LPN that is dropped, the Receiving Transaction Processor program runs.

If multiple receiving transaction processors are running, dead lock is detected and program completes with the following errors:


This is happening every time. If single RTP program is running it will complete successfully.

Steps
Drop LPNs one by one using standard 'Manual Drop' function, each LPN having multiple quantities.

Workaround
Set Incompatibility for RVCTP program so that even when launching more than 1 RTP at the same time at no time more than 1 RTP request will be in Running Status.
They will be processed one by one .
To set this follow below steps.
  1. Launch to System Administrator Responsibility
  2. Concurrent->Program->Define
  3. Query for "Receiving Transaction Processor".
  4. Click Incompatibilities Button at the Bottom.
  5. Keep Application as Purchasing.
  6. Give Name as ->"Receiving Transaction Processor".
  7. Scope-> Program
  8. Type-> Global

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