Transaction Processor Error An Error Occurred While Relieving Reservations
(Doc ID 1903128.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Inventory Management - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
Symptoms
Sales Order Issue transaction stucked in Material Interface Table (MTI) with the following error:
Error Code :Transaction processor error
Error Explanation : An error occurred while relieving reservations.
Log File shows the following errors:
-------------------------------------------
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: Negative Balance Allowed Org
[29-JUN-14 09:17:56] INV_QUANTITY_TREE_PVT: QUERY_TREE Entered
[29-JUN-14 09:17:56] INV_QUANTITY_TREE_PVT: >>>>>> In query_tree, mode=2, tree_id=1..for item=631247 rev= lot= sub= loc= lpn=
[29-JUN-14 09:17:56] INV_QUANTITY_TREE_PVT: QUERY_TREE Exited with status = S, Qty : 0 :0 :1 :0 :-1 :-1 :0
[29-JUN-14 09:17:56] INV_QUANTITY_TREE_PVT:
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_QOH : 0
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_RQOH : 0
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_PQOH : 0
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_QR : 1
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_QS : 0
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_ATT : -1
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_ITEM_ATR : -1
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: L_TRX_QTY : 1
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: Total Org quantity cannot become negative when there are reservations present
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: At indicator : 170
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: Error in post_temp_validation : Transaction processor error
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: SQL : User-Defined Exception
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: After Error in post_temp_validation continue...
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: ***Undef Error Ex..rel_res : User-Defined Exception
[29-JUN-14 09:17:56] INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: When others Ex..rel_reservations_mrp_update
[29-JUN-14 09:17:56] INV_TRX_MGR: Reservation: res_status=E,msg=null,mrt_statusE
[29-JUN-14 09:17:56] INV_TRX_MGR: Ex.. in BaseTransaction Relieve Reservations...:null
[29-JUN-14 09:17:56] INV_TRX_MGR: **Ex: Ex.. in BaseTransaction Relieve Reseravtions...:null
[29-JUN-14 09:17:56] INV_TRX_MGR: Ex.. in BaseTransaction call Relieve Resv+mrp ..:oracle.apps.inv.transaction.utilities.InvTrxException
[29-JUN-14 09:17:56] INV_TRX_MGR: **Ex: Ex.. in BaseTransaction calling Relieve Reservations ..:oracle.apps.inv.transaction.utilities.InvTrxException
[29-JUN-14 09:17:56] INV_TRX_MGR: BaseTransaction. Rollbacking all changes: oracle.apps.inv.transaction.utilities.InvTrxException
[29-JUN-14 09:17:56] INV_TRX_MGR: error expl :Ex.. in BaseTransaction calling Relieve Reservations ..:oracle.apps.inv.transaction.utilities.InvTrxException
[29-JUN-14 09:17:56] INV_TRX_MGR: TrxUtil: stacked message - An error occurred while relieving reservations.
[29-JUN-14 09:17:56] INV_TRX_MGR: error msg :An error occurred while relieving reservations.
[29-JUN-14 09:17:56] INV_TRX_MGR: error msg2 :An error occurred while relieving reservations.
[29-JUN-14 09:17:56] INV_TRX_MGR: Mssg peeked :An error occurred while relieving reservations.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |