Datafix: Interface Trip Stop - SRS Failes by ORA-20002 on SHIP_LINE Due to Incorrect OE_INTERFACED_FLAG Flag for Kit Item (Doc ID 2244615.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
Interface Trip Stop - SRS Fails due to the following error for Kit Item. And order lines are stuck as "Awaiting Fulfillment"

Error
Interface Trip Stop - SRS concurrent log.

          Calling program unit OE_MSG_PUB.GET
          ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/XXXXX'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt
Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/XXXXX'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt
          ERROR
          Rollback to savepoint its_process_order_non_bulk

Steps to Reproduce

  1. Unable to reproduce the issue at will

Changes

 

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