RVTII-060 Error On Receiving A Drop Ship: INV_RESERVATION_PVT (Doc ID 1345003.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***

Symptoms

On 12.0.6 in production when processing drop ship PO receipt the following error is raised when RVCTP calls OE_DROP_SHIPMENT API:

     RVTII:060 INV TRX Manager Error Msg: Fails in OE_DROP_SHIPMENT

The Inventory Debug Log file shows the following cause of the above error to be call to RESERVATION in package INV_RESERVATION_PVT:

[29-JUL-11 09:17:27] INV_RESERVATION_PVT: After modify tree crt del rel E
[29-JUL-11 09:17:27] INV_RESERVATION_PVT: l_qty_changed:
[29-JUL-11 09:17:27] INV_RESERVATION_PVT: l_secondary_qty_changed:
[29-JUL-11 09:17:27] INV_Reservation_PUB.Create_Reservation: Return Status after creating reservations E
[29-JUL-11 09:17:27] INV_Reservation_PUB.Create_Reservation: Raising expected errorE
[29-JUL-11 09:17:27] INV_Reservation_PUB.Create_Reservation: 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
ENTER Save_API_Messages
l_errmsg User-Defined Exception
L_MSG_DATA=Quantity on hand fails to satisfy reservation
EXIT Save_API_Messages
[29-JUL-11 09:17:27] INV_TRX_MGR: **Fails in OE_DROP_SHIPMENT :
[29-JUL-11 09:17:27] INV_TRX_MGR: **Ex: Fails in OE_DROP_SHIPMENT
[29-JUL-11 09:17:27] INV_TRX_MGR: BaseTransaction. Rollbacking all changes: oracle.apps.inv.transaction.utilities.InvTrxException
[29-JUL-11 09:17:28] INV_TRX_MGR:  error expl :Fails in OE_DROP_SHIPMENT

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