Stuck Transaction Interface Sales Order Issues: An Error Occurred While Relieving Reservations (INV_RSV_RLF_FAILED)
(Doc ID 280400.1)
Last updated on JUNE 26, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterOracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
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
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 |