My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2019

Applies to:

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


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.

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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.