Stuck Transaction Interface Sales Order Issues: An Error Occured While Relieving Reservations (INV_RSV_RLF_FAILED) (Doc ID 280400.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
INV_RSV_RLF_FAILED-Failed to Relieve Reservations error
WSHINTERFACES-Interface Trip Stop
This document includes all versions of 11i and R12

Symptoms

Find Sales Orders where inventory was not relieved.
Transaction type 'Sales Order issue' is stuck in Inventory Transaction Open Interface MTL_TRANSACTIONS_INTERFACE MTI.
The error in the interface table follows.

Error

INV_RSV_RLF_FAILED
An error occured while relieving reservations


Error - Example from Logfile

 You might see an error like the following in the trip stop log file when this issue occurs.

WSHINTERFACES module: Interface Trip Stop - SRS
...
INV_TXN_MANAGER_PUB.post_temp_validation: Error : Negative balances not allowed
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: Exception Raised : 150
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

Steps
1. Inventory > Transactions > Transaction Open Interface
2. Click Find.
3. See transaction error.

The error in question has an error code of "INV_RSV_RLF_FAILED".  You might see this error code in log files. You could also find the error code in the message table:

SELECT M.MESSAGE_NAME, M.MESSAGE_TEXT, M.MESSAGE_NUMBER, A.APPLICATION_SHORT_NAME
FROM FND_NEW_MESSAGES M, FND_APPLICATION A
WHERE M.MESSAGE_TEXT LIKE '%AN ERROR OCCURRED WHILE RELIEVING RESERVATIONS%'
AND M.LANGUAGE_CODE = 'US'
AND M.APPLICATION_ID = A.APPLICATION_ID
/
INV_RSV_RLF_FAILED

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