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 SEPTEMBER 20, 2017

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
Information in this document applies to any platform.
Form:RCVTXVTX.FMB - View Transactions Status


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

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