My Oracle Support Banner

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:

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


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

  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.


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

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