My Oracle Support Banner

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 OCTOBER 25, 2017

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.