My Oracle Support Banner

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

Last updated on JULY 12, 2018

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

INV_RSV_RLF_FAILED: An error occurred while relieving reservations
(Type-o: An error occured while relieving reservations.)
(Type-o: An error ocurred while relieving reservations.)
(Type-o: An error ocured while relieving reservations.)

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 occurred 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

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!


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