My Oracle Support Banner

Interface Trip Stop Errors With Your Change Invalidates The Customer Item Number On The Line (Doc ID 2411105.1)

Last updated on JANUARY 10, 2022

Applies to:

Oracle Shipping Execution - Version 11.5.9 to 12.2.10 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

Interface Trip Stop errors with any of the following:

Error

Your change invalidates the Customer Item Number on the Line.  <<---Note this error is raised along with any of the following:


1) ship to address:12345 - Customer:123456
INVENTORY_ITEM_ID Before calling CI_Attribute_Value 12345678
p_x_line_rec.line_category_code = ORDER
Its a Normal Order Line
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for MASTER_ORGANIZATION_ID
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter value exists.
PARAMETER VALUE: 123456
INVENTORY_ITEM_ID After call is
Issue error message
l_error_code: APP-123456
l_error_flag: Y
l_error_message: No Customer Item Cross Reference found in the MTL_CUSTOMER_ITEM_XREFS table with the specified criteria.

or

2)  Entering Get_Inventory_Item
ship to address:1863406 - Customer:1046
INVENTORY_ITEM_ID Before calling CI_Attribute_Value 58319
INVENTORY_ITEM_ID After call is
Issue error message
l_error_code: APP-43099
l_error_flag: Y
l_error_message: INV_INVALID_CUST_ADDRESS
p_x_line_rec.ordered_item_id:1044610
LEAVING OE_MSG_PUB.ADD
Return Status after calling CI_Attribute_Value E
Exiting Get_Inventory_Item

or

3) Inactive customer item cross reference found in MTL_CUSTOMER_ITEM_XREFS table.

 


Steps to Reproduce

  1. Inventory Responsibility
  2. Create Customer Item Reference with Customer Item code X, linked with local item: A
  3. Order Management Super User Responsibility
  4. Enter and book order using Customer Item: X
  5. Local Item has been changed from A to B with the Customer Item code:X
  6. Ship confirm order and Interface Trip Stop completed with error.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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