Internal Order or Interorg Transfer Receipts Fail With Error "Receiving Transaction Manager returned an error while..." (Doc ID 471543.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:RCVTPO - Receiving Transaction Manager
EXECUTABLE:RVCTP - Receiving Transaction Processor
***Checked for relevance on 09-JUN-2014***


Symptoms

ON 11.5.10, can not perform internal order or interorg transfer receipts.
After Internal Order or Inter Org Shipment is created then shipped. It does not get interfaced to inventory because the transaction fails. Shipment status remains in "Shipped" status rather than "Interfaced".

Transaction errors in the MTL_TRANSACTIONS_INTERFACE with message:
ERROR: "Receiving Transaction Manager returned an error while processing the record with Interface Id nnnnnn. The error message returned is ."

Steps to reproduce:

  1. Create an Internal Order or Inter Org Shipment.
  2. Nav: Inventory (Responsibility) ->Transactions -> Transactions Open Interface -> Query for Internal Order Transactions in Error
  3. Transactions get stuck in the Transaction open interface
Debug logfile shows the following:
INV_TRX_MGR: *** Rcv Trx process Fail !!
rstat:0,outcome:ERROR,message:null
INV_TRX_MGR: Deleted 1 rows from RCV_TRANSACTIONS_INTERFACE
INV_TRX_MGR: **Ex: Rcv Trx process Failed
INV_TRX_MGR: *** Ex... in insertRcvInterface:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: **Ex: Ex.. in insertRcvInterface:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: *** Ex... in insertRcvInterface:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: **Ex: Ex.. in insertRcvInterface:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: Ex.. in INTORD.processPostUpdate..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: Ex.. in INTORD...querying PO_REQUISITION_LINES_ALL..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: **Ex: Ex.. in INTORD...querying
PO_REQUISITION_LINES_ALL..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: BaseTransaction. Rollbacking all changes:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: error expl :Ex.. in INTORD...querying
PO_REQUISITION_LINES_ALL..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: TrxUtil:processCurrentMessage UnKnown exception - java.lang.NullPointerException
INV_TRX_MGR: error msg2 :Receiving Transaction Manager returned an error while processing the record with Interface Id nnnnnn. The error message returned is .
.
INV_TRX_MGR: Mssg peeked :Receiving Transaction Manager returned an error while processing the record with Interface Id nnnnnn. The error message returned is .

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