Deadlock In RVCTP Receiving Transaction Processor RVTLO-050: ORA-00060: RVTCL-040:
(Doc ID 1504760.1)
Last updated on DECEMBER 12, 2023
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
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
| Symptoms |
| Cause |
| Solution |
| References |