Drop Ship Order Receipts Fail Stuck In RTI Message 'Fails In OE_DROP_SHIPMENT' RVTII-060 Subroutine INV_TXN_MANAGER_PUB.process_Transactions()
(Doc ID 1396614.1)
Last updated on MAY 18, 2019
Applies to:Oracle Inventory Management - Version 11.5.1 and later
Information in this document applies to any platform.
When receiving Dropship Purchase Orders, receipt remains pending in the Receiving Transaction Status Summary rcv_transactions_interface table with the message
RVCTP log file shows
RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error
Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned an internal error.
Action: Note this error number and the actions you a
When debugging per <Note 299497.1> INV debug shows
[30-MAR-12 07:15:39] INV_Reservation_PUB.Create_Reservation: 30-03-2012 07:15:39 @ Error Obtained at180 Create reservation returns : E INV G_MISS_CHARINV-INVALID RESERVATION QTY G_MISS_CHAR reservation fails with expected error in dropshipreceive() : ORA-0000: normal, successful completion Try receipt after setting sub/item non reservable LEAVING OE_MSG_PUB.ADD_TEXT Quantity on hand fails to satisfy reservation Expected Error in Create Reservation...
Call to Create Reservation returned expected error ORA-0000: normal, successful completion Exiting dropshipreceive with exp. error => User-Defined Exception
[30-MAR-12 07:15:39] INV_TRX_MGR: **Fails in OE_DROP_SHIPMENT :
[30-MAR-12 07:15:39] INV_TRX_MGR: **Ex: Fails in OE_DROP_SHIPMENT
Output of the script HTMOMSE from <Note 133464.1> for the Sales Order shows
LINE PROCESSING MESSAGES
WARNING LINE HEADER_ID LINE_ID MSG_SOURCE ACTIVITY REQUEST_ID DESCRIPTION MESSAGE_TEXT
1 2.1 1962 1644 C=Conc Process 15856997 Quantity on hand fails to satisfy reservation
The issue can be reproduced at will with the following steps:
. Enter Sales order > Book order > Requisition Import > Create Release from Approved Requisition > Approve Release ie create dropshipment purchase order
. Rcv11i output shows
. Navigate to Receiving / Receipts form
Receive the purchase order
Receiving Transaction Processor RVCTP completes in error
. Navigate to Transaction Status Summary form
Transaction is stuck with
Transaction Type Receive
Processing Mode Immediate
Transaction Status Pending
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