RVCTP Receiving Transaction Processor Is Not Picking Records / Records Remain Pending in RTI (Doc ID 1671301.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.2.3 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

Find RVCTP Receiving transaction processor does not pick / process records.

Many Records are stuck in RCV_TRANSACTIONS_INTERFACE table with
 
INTERFACE_TRANSACTION_ID 414368 414369 ... 414418 414428
CREATION_DATE 08/05/2014 08:22
TRANSACTION_TYPE RECEIVE
TRANSACTION_DATE 05-MAY-14
PROCESSING_STATUS_CODE PENDING
PROCESSING_MODE_CODE IMMEDIATE
PROCESSING_REQUEST_ID null
TRANSACTION_STATUS_CODE PENDING 
AUTO_TRANSACT_CODE DELIVER
RECEIPT_SOURCE_CODE VENDOR
TO_ORGANIZATION_ID 85
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 111378 
HEADER_INTERFACE_ID Null
VALIDATION_FLAG Y

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