Interface Trip Stop Program Is Ending Is Warning Due to Incorrect OE_INTERFACED_FLAG (Doc ID 2244989.1)

Last updated on JULY 06, 2018

Applies to:

Symptoms

Problem Statement
Interface trip stop program is completed with warning, log file was print below error message.

Error
ship_confirm_new UNEXPECTED 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 1
rollback to om_ship_confirm :
  After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 03/14/2017 12:43:24 PM
  l_return_status ==> U
  NO. OF OE MESSAGES :1
  Calling program unit OE_MSG_PUB.GET
  ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/#######'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt
Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified acti
vity for item 'OEOL/22830823'. in Package OE_Delayed_Requests_PVT Procedure Proc
ess_Request_Pvt
  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 ==> 3
  current index ==> 2
  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

Steps to Reproduce

1. Cannot reproduce at will

Cause

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