RVTII-060 Error On Receiving A Drop Ship: INV_RESERVATION_PVT
(Doc ID 1345003.1)
Last updated on SEPTEMBER 18, 2023
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.
Symptoms
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
[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
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 |