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 JUNE 07, 2021

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.

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
Cause
 HELPFUL SCRIPTS
Solution
 1. Not Enough Onhand
 2. Old Reservations
 3. Duplicate Transactions
 4. Wrong Order On Reservation
References

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