Thursday, 30 October 2014

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.


4 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. Thanks for sharing very good information about OCI Punchout.
    OCI Punchout

    ReplyDelete
  3. Thanks for sharing article about What is OCI Punchout
    What is OCI Punchout

    ReplyDelete