RVTII-060 Error On Receiving A Drop Ship: INV_RESERVATION_PVT
(Doc ID 1345003.1)
Last updated on MARCH 09, 2020
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.
***Checked for relevance on 26-Jul-2013***
When processing drop ship PO receipt the following error is raised when RVCTP calls OE_DROP_SHIPMENT API:
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: 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
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
l_errmsg User-Defined Exception
L_MSG_DATA=Quantity on hand fails to satisfy reservation
[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