An error occurred while relieving reservations.Total Organization Quantity cannot become Negative when there are reservations present (Doc ID 2228014.1)

Last updated on JANUARY 29, 2017

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Reservations

When attempting to run Interface trip Stop, one reservation is not correctly processed.

ERROR

INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: Total Org quantity cannot become negative when there are reservations present
INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: At indicator : 180
INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: Error in post_temp_validation : Transaction processor error
INV_TXN_MANAGER_PUB.POST_TEMP_VALIDATION: SQL : User-Defined Exception
INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: After Error in post_temp_validation continue...
INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: ***Undef Error Ex..rel_res : User-Defined Exception
INV_TXN_MANAGER_PUB.REL_RESERVATIONS_MRP_UPDATE: When others Ex..rel_reservations_mrp_update
INV_TRX_MGR: Reservation: res_status=E,msg=null,mrt_statusE
INV_TRX_MGR: Ex.. in BaseTransaction Relieve Reservations...:null
INV_TRX_MGR: **Ex: Ex.. in BaseTransaction Relieve Reseravtions...:null
INV_TRX_MGR: Ex.. in BaseTransaction call Relieve Resv+mrp ..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: **Ex: Ex.. in BaseTransaction calling Relieve Reservations ..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: BaseTransaction. Rollbacking all changes: oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: error expl :Ex.. in BaseTransaction calling Relieve Reservations ..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: TrxUtil: stacked message - |An error occurred while relieving reservations.|Total Organization Quantity cannot become Negative when there are reservations present

STEPS
The issue can be reproduced at will with the following steps:
1. Run Interface Trip Stop


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms