How to clean up already received ASNs still found in MSC_SUPPLIES?
We are on 12.0.3.
We are seeing an order number, an ASN for a PO shipment still showing up in supply demand screen, even after it is completely received. Users are getting confused by this.
Verified that this record is present in MSC_SUPPLIES. Further, for a combination of MSC_SUPPLIES.plan_id and MSC_SUPPLIES.transaction_id the corresponding record MSC_FULL_PEGGING.DEMAND_ID = -1, implying excess supply.
When verified in RCV_SHIPMENT_LINES for the ASN line, the QUANTITY_SHIPPED = QUANTITY_RECEIVED. So the ASN has already been received.
We have about 8 such cases /= 2 inter-Org shipments.
How to clean the 'Excess Supply' record in MSC_SUPPLIES?