Order Import does not spawn child request

Even after running “Create Internal Orders” and doing “Order Import Request”, if the internal sales order (ISO) is not generated check whether Order Import concurrent has triggered the child concurrent.

 

If the child concurrent is not triggered, follow the below procedure to resolve the issue.

Why the child concurrent is not triggered?

This issue is caused because there was a value for Request Id column in OE_Headers_Iface_All table when the Order Import is submitted.

Order Import program would not pick up records for processing if the Request Id is already populated in the Interface table OE_Headers_Iface_All, and hence no child request would be spawned.

When Order Import sees a value for Request Id already populated, this is interpreted as an already processed record and is not picked up again.

Navigation:

Order Management – Orders, Returns – Import Orders – Corrections

Enter corresponding Order source & Order reference and click find.

 

This will put out the data from the Interface table. Clear out the Request Id and uncheck the Error_Flag, which is present in the status tab of the Corrections screen.

Now re-submit Order Import, now the child concurrent will be triggered & ISO will be generated.