My Oracle Support Banner

Transaction Processor Error An Error Occurred While Relieving Reservations (Doc ID 1903128.1)

Last updated on MARCH 12, 2020

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


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