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 JULY 07, 2016

Applies to:

Oracle Inventory Management - Version 11.5.1 and later
Information 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

Fails in OE_DROP_SHIPMENT

or

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


RVCTP log file shows

Fails in OE_DROP_SHIPMENT
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 @ Raising expected errorE
[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

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

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