Sales Orders Not Showing In the MDS After Load/Copy/Merge. Planning Manager Is Active. Rows Stuck In Table MRP_SO_LINES_TEMP With Proces_Status = 2 (Doc ID 841978.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

On 12.0.6 in Test:
Users are creating new sales orders and running MDS Load/Copy/Merge to pick up the sales orders.
However the sales orders are not showing up in the MDS after the MDS run. Further investigation
yields the sales order data makes it to table mrp_so_lines_temp but the records are still in
process_status = 2 (Pending) for the Planning Manager to pick up and process. But the Planning
Manager and MRP Manager are setup and running properly but are not processing these records.

EXPECTED BEHAVIOR
Expect sales orders that are scheduled in OM to be picked up by the MDS run

STEPS
The issue can be reproduced at will with the following steps:
1. Launch MRP and Planning Manager
2. Create and schedule new sales order lines for an item
3. Create an MDS and run Load/Copy/Merge
4. Review the MDS entries and the new sales orders are not picked up
5. The sales order data makes it so table mrp_so_lines_temp with process_status = 2 (Pending)
6. Sales order data does not make it into table mrp_sales_order_updates

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.