Internal Order Receipts Cannot be Found (APP-PO-14094) Because TripStop (WSHINTERFACE) Fails With "Receiving Transaction Manager Returned error" (Doc ID 1323849.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 30-May-2017***

Form:RCVRCERC.FMB - Enter Receipts GUI
Executable:WSHINTERFACE - Interface Trip Stop
Executable:RCVTPO - Receiving Transaction Manager


Symptoms

Intransit Internal Order receipt cannot be found in Find Expected Receipts window (in Enter Receipts form). The error "APP-PO-14094: No records meet your search criteria." occurs upon entering the internal requisition number and clicking FIND.

When reviewing the TripStop log (WSHINTERFACE concurrent log) in Order Management, it shows an error in Receiving Transaction Manager as seen in excerpts from that log below:

Shipping Execution: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights
reserved.
WSHINTERFACE module: Interface Trip Stop
+-------------------------------------------------------------+
Current system time is 18-MAY-2011 09:30:00
+-------------------------------------------------------------+
**Starts**18-MAY-2011 09:30:01
**Ends**18-MAY-2011 09:30:34
Interface trip stop is completed with warning
+-------------------------------------------------------------+
Start of log messages from FND_FILE
+-------------------------------------------------------------+
Starting WSH Debugger ==> 05/18/2011 09:30:01 AM,Session
ID=21790874
The following are the current Shipping related debug settings:
OM: Debug Level ==> 0
 INV: Debug Level ==>
 WSH: Debug Enabled ==> Yes
 WSH: Debug File Prefix ==>
 WSH: Debug Level ==> Statement
 WSH: Debug Log Directory ==> /usr/tmp
 WSH: Debug Module ==> %
....
INV_TXNSTUB_PUB: Entered INV_TXNSTUB_PUB.postTransaction
INV_TXNSTUB_PUB: InstallBase Trackable: N
INV_TXNSTUB_PUB: g_fnd_install_status is not I or item is not
installbase trackable
INV_TRX_MGR: Before Calling DCP API
INV_TRX_MGR: **Checking for internal orderdirect**
INV_TRX_MGR: INVCONV RCV changes: trx.mRcvIntfId: 12001
INV_TRX_MGR: mXfrCostGroupId: null
INV_TRX_MGR: INVCONV RcvTrxManager: Setting Secondary Qty in
RTI 0.0
INV_TRX_MGR: INVCONV RCV changes: Setting UOM in RTI
INV_TRX_MGR: ** Rcv inserted ***::1
INV_TRX_MGR: *** RcvTrxManager, currentBatchId :0
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.. 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: stacked message - Receiving Transaction
Manager returned an error while processing the record with
Interface Id 241. The error message returned is .
INV_TRX_MGR: error msg :Receiving Transaction Manager
returned an error while processing the record with Interface
Id 241. The error message returned is .
INV_TRX_MGR: error msg2 :Receiving Transaction Manager
returned an error while processing the record with Interface
Id 241. The error message returned is .
INV_TRX_MGR: Mssg peeked :Receiving Transaction Manager
returned an error while processing the record with
Interface Id 241. The error message returned is .
INV_TRX_MGR: Updated 1 rows with error msg from MTI with
batch id=0
...
INVTXNB: Error from INV worker : error_code : Transaction
processor error, err_expl :Receiving Transaction Manager
returned an error while processing the record with Interface
Id 241. The error message returned is .
 Current Time is ==> 05/18/2011 09:30:34 AM
 l_outcome ==> FALSE
MTL_ONLINE_TRANSACTION_PUB.process_online returns false
Error Code:Transaction processor error
Error Explanation:Receiving Transaction Manager returned an
error while processing the record with Interface Id 241. The
error message returned is .
Retrieving messages from the stack
 Error Code: ==> Transaction processor error
 Error Explanation:: ==> Receiving Transaction Manager
returned an error while processing the record with Interface
Id 241. The error message returned is .
 x_return_status ==> E
 Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE
(05/18/2011 09:30:34 AM, 29.28 seconds)
 Batch 5001: TXN 106577 : PROCESS ONLINE FAILED AGAIN
 l_completion_status ==> WARNING
 Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP
(05/18/2011 09:30:34 AM, 30.42 seconds)

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