My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


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
reservation fails with expected error in dropshipreceive() : ORA-0000: normal, successful completion
Try receipt after setting sub/item non reservable
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



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

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