Records Are Stuck in RCV_TRANSACTIONS_INTERFACE with Running Status and Cannot be Seen on Transaction Status Summary Form RCVTXVTX (Doc ID 1438224.1)

Last updated on MARCH 18, 2024

Applies to:

Symptoms

Some records are stuck in RTI RCV_TRANSACTIONS_INTERFACE table with  RUNNING Status
and cannot be seen on the Transaction Status Summary Form RCVTXVTX.

These records are not needed because the receiving side of the transaction processed successfully.

Expected Behavior
These records should be deleted

Steps
  Rcv11i output shows  some deliver records are stuck in RCV_TRANSACTIONS_INTERFACE with
     Transaction_Type DELIVER
     Processing_Status_Code RUNNING
     Processing_Mode_Code IMMEDIATE
     Transaction_Status_Code PENDING
     Receipt_Source_Code INTERNAL ORDER
     Source_Document_Code REQ

Navigate to: Purchasing Super User Responsibility  > Receiving > Transaction Status Summary
The transactions are not visible in Transaction Status Summary Form.
It is not possible to delete the records using the form.

Cause

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