Sales orders not collected in Production Scheduling

Summary:

There are bunch of sales orders that are not finding its way to Production Scheduling when we run "Refresh and Solve" or "refresh". Per Oracle here are the conditions for a sales order to get collected in PS.

- status is not Closed or Cancelled
- it has a Requested Ship Date (in the plan horizon)
- the Sales Order is marked as "Submitted" (SUBMITTED_FLAG in the DOO_HEADERS_ALL table)

A Sales Order in "Draft" status will not have Submitted set - We suspect it may be the case that this customer sales order has the Submitted state set, in which case we consider it like any sales order.