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.

  • October 30, 2014 | 20 views