My Oracle Support Banner

Transactions Stuck In Open Interface: An Error Occurred While Relieving Reservations - ITS failing with INV_RESERVATION_PVT: ERROR CODE0 (Doc ID 1363851.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Error:INV_RSV_RLF_FAILED - An error occurred while relieving reservations

Symptoms

Transactions are getting stuck in the MTL_TRANSACTIONS_INTERFACE with the following error:

Error
An error occurred while relieving reservations

Another symptom is: Interface Trip Stop ITS completing in Warning - INV_RESERVATION_PVT: error code0

[18-NOV-13 16:25:37] INV_Reservation_PUB.Update_Reservation: Raising expected errorE
AFTER UPDATE_RESERVATION: E
LEAVING OE_MSG_PUB.ADD_TEXT
  ERROR : A reservation record with the same item, organization, demand source,
  and supply source already exists. Please use transfer reservation if you
  still want to make the changes.

Also, issues with reservations splitting in the Sales Orders for no apparent reason

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
Solution
References


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