RTP Error "ORA-00060: deadlock detected while waiting for resource" Happens When Receiving and Modifying the Po Release at the Same Time
(Doc ID 2518329.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.
When receiving and modifying the po release at the same time,
the following error occurs in Receiving Transaction Processor(RTP).
ORA-00060: deadlock detected while waiting for resource
Steps to Reproduce
- Create BPA and Release
- Purchase Order Summary to Release
Enter Promised Date against Line 3
Do not save
Receiving > Receipts
(Profile RCV: Procesing Mode is Immediate.)
Perform Receipt against Line 1, 2, 3, 4, 5
RTP is launched
RTP will not Complete
Switch to Purchase Order Summary to Releases form
RTP Completed with Error
- Deadlock doesn't occur
- Line 1, 2, 4, 5 are received successfully
- Line 3 is stuck in RCV_TRANSACTIONS_INTERFACE table with following error:
RVTTH-192.rvtthins: Subroutine PO_INVALID_REL_SHIPMENT_STATUS returned error
Cause: Subroutine PO_INVALID_REL_SHIPMENT_STATUS returned an internal error.
Action: Note this error number and the actions you are trying to pe
Receiving error of Line 3 is expected behavior.
This is explained in the following Note:
Receipt on Blanket Release, or Standard Purchase Order Errors With: PO_INVALID_REL_SHIPMENT_STATUS (Doc ID 2147870.1)
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