My Oracle Support Banner

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.

Symptoms

Problem Statement
When receiving and modifying the po release at the same time,
the following error occurs in Receiving Transaction Processor(RTP).

Error
ORA-00060: deadlock detected while waiting for resource

Steps to Reproduce

  1. Create BPA and Release
    PO: XXXX
    Release: 1
    Shipment: 1,2,3,4,5

  2. Purchase Order Summary to Release
    Enter Promised Date against Line 3
    Do not save
  3. Receiving > Receipts
    (Profile RCV: Procesing Mode is Immediate.)
    Perform Receipt against Line 1, 2, 3, 4, 5
    Save
    RTP is launched

  4. RTP will not Complete

  5. Switch to Purchase Order Summary to Releases form
    Save
    Re-Approve

  6. RTP Completed with Error

 

Expected Behavior

  1. Deadlock doesn't occur

  2. Line 1, 2, 4, 5 are received successfully

  3. 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)

 

Changes

 

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
Changes
Cause
Solution
References


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