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 JUNE 28, 2024
Applies to:
Oracle Inventory Management - Version 11.5.1 and laterInformation in this document applies to any platform.
Symptoms
When receiving Dropship Purchase Orders, receipt remains pending in the Receiving Transaction Status Summary rcv_transactions_interface table with the message
or
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
Reviewing the order details, see the following:
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
Steps
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
PO_LINE_LOCATIONS_ALL
Drop_Ship_Flag Y
. 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
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |