"Interface Trip Stop" Fails Due To "Inactive Customer Item Cross Reference found in MTL_CUSTOMER_ITEM_XREFS table."

(Doc ID 2271453.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Order Management - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Problem Statement
"Interface Trip Stop" fails due to the following error.

Error
"Inactive Customer Item Cross Reference found in MTL_CUSTOMER_ITEM_XREFS table."

Additional Error in Log file

         Calling program unit OE_MSG_PUB.GET
         Your change invalidates the Customer Item Number on the Line.
         Error msg: Your change invalidates the Customer Item Number on the Line.
         ERROR

Steps to Reproduce

  1. Run "Interface Trip Stop" or "Interface Trip Stop - SRS" for problematic data

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