Interface Trip Stop (ITS) Completes With Error: INV-RSV-TOO-MANY-TARGET (Doc ID 3059710.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Symptoms

Interface Trip Stop errors with the following error :

ERROR
ship_confirm_new EXC ERROR: User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
rollback to om_ship_confirm
  After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 10/31/2024 12:55:49 PM
  l_return_status ==> E
  NO. OF OE MESSAGES :2
  Calling program unit OE_MSG_PUB.GET
  Internal error: there are more than one existing reservation records that have the same item, organization, demand source, and supply source information. Please contact your system support.
Error msg: Internal error: there are more than one existing reservation records
that have the same item, organization, demand source, and supply source informat
ion. Please contact your system support.
  Calling program unit OE_MSG_PUB.GET
  Error: Inventory - Transfer Reservation has failed with Error : INV INV-RSV-TOO-MANY-TARGET
Error msg: Error: Inventory - Transfer Reservation has failed with Error : INV I
NV-RSV-TOO-MANY-TARGET
  ERROR
  Rollback to savepoint its_process_order_non_bulk
  No DCP Error
  Inside Loop WSH_DCP_PVT.G_INIT_MSG_COUNT ==> 0
  before deleting tables ==> 2
  current index ==> 1
  next index ==> is NULL
  l_loop_count ==> 1
  l_error_count ==> 1
  l_warn_count ==> 0
  Process Order Error
  Rollback to savepoint its_process_order_non_bulk
  Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_STOP_TO_OM (10/31/2024 12:55:49 PM, 1.22 seconds)
  Process_Stop_To_OM l_return_status ==> E

Replication Steps:
1. Goto Order Management > Shipping > Shipping Transactions.
2. Query the related order.
3. Choose the delivery tab.
4. Choose ship confirm.
5. Monitor for the Interface trip stop concurrent program to complete.
6. The Interface trip stop completes in error noted.

Cause

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