Order Import Issue - Item with inventory_item_id=XXXXXX is not defined in Item validation Org XXX

IR-ISO - Order Import Issue

Issue:

Approved Internal Requisitions are not converted into Internal Sales Orders.

Description:

In Purchasing Responsibility, an Internal Requisition (447493) has been created and approved. “Create Internal Orders” Request is submitted and completed successfully.

In Order Management Responsibility, “Order Import” Program is submitted with Order Source as Internal and Order Source Reference as Internal Requisition Number (447493). But the Internal Sales Order is not imported.

Actions Taken:

Step 1: Check the "Order Import Corrections" Form

Check the Order Import Corrections form for any errors.

Responsibility: Order Management Super User

Navigation: Import Orders > Corrections

Checked in "Order Import - Corrections" form for the problematic requisition and found the line with Error Message "Item with inventory_item_id=327809 is not defined in Item validation Org 367" 

Step 2: Check the Item Validation Organization in System Parameters

The Item Validation Organization in "OM System Parameters " has been defined as 

Step 3: Check the Item Assignments:

Check whether that problematic item has been assigned to that Item Validation Organization or not.

This problematic Item has not been assigned to the Item Validation Organization.

Note:

If the Item Validation Organization is valid and the Item is not assigned to that organization, then assign this Item to the Item Validation Organization Org and then fix the errors in Corrections form.

OR

If the Item Validation Organization is invalid, Change the Item Validation Organization in System Parameter Value.

In our case, assume that the Item Validation Organization is invalid.

Solution:

Step 1: Change the Item Validation Organization as Item Master Organization

Change the Item Validation Organization as "XXX Item Master Organization".

Step 2: Query the Problematic Requisition in Order Import Corrections Form

Open the Order Import Corrections form for the problematic order based on the "Order Source".

Order Source = Internal

Order Reference = Click on LOV and query by the Requisition number 

Note: While querying by "Requisition number" in the Order Reference field, the Order Reference ID will be populated instead of the Requisition number.

Click "Find"

Corrections form will populate the problematic order line.

Step 3: Remove the "Request ID" value:

In "Main" TAB, remove the "Request ID" value

Step 4: Uncheck "Error Flag":

Navigate to "Status" TAB

Uncheck the "Error Flag"

Step 5: Uncheck Error Flag in Lines:

Click on "Lines" Button and navigate to "Status" TAB

If the "Error Flag" is checked, uncheck.

Step 6: Save

Save and Close the "Lines" form.

Now the Corrections Header form will be displayed.

Step 7: Validate:

Click on "Validate"

Will get the Notification like "Order processed successfully". Click "OK".

Step 8: Import:

Click on "Import"

Will get the Notification like "Order processed successfully". Click "OK".

Line will be removed from the "Corrections" form and display the pop-up message. Click OK.

Step 9: Query the ISO in Order Organizer form:

Go to "Order Organizer" form and query the Internal Sales Order by Order Source.

Click "Find"

Query has retrieved the Internal Sales Order record

Click "Open"

Click on "Line Items"

Step 10: Query the Requisition in Requisition Summary form to check the ISO No:

Navigate to Purchasing Module and query the Requisition Summary to check the ISO Number

Responsibility: Purchasing Super User

Navigation: Requisition > Requisition Summary

Click "Find" 

We can find the respective ISO Numbers in the Requisition Lines Summary Form.