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:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms