Deadlock In RVCTP Receiving Transaction Processor RVTLO-050: ORA-00060: RVTCL-040:
Last updated on OCTOBER 25, 2017
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
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
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