Interface Trip Stop Errors With Your Change Invalidates The Customer Item Number On The Line
(Doc ID 2411105.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Shipping Execution - Version 11.5.9 and laterInformation 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.
or
4) wsh select error ORA-01403: no data found
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.
or
4) wsh select error ORA-01403: no data found
Steps to Reproduce
- Inventory Responsibility
- Create Customer Item Reference with Customer Item code X, linked with local item: A
- Order Management Super User Responsibility
- Enter and book order using Customer Item: X
- Local Item has been changed from A to B with the Customer Item code: X
- 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 |