workaround for Supply Demand(ASN) Corruption Issue
Issue : Supply Demand screen shows in-transit supply against Shipment which has Fully received.
Details of the Issue : We have faced this issue couple of times wherein we found that Supply Demand form shows some quantity from Shipment as In-transit. We checked the Shipment details and found that shipment line for corresponding item is Fully received. When further checked we observed that PO line is also Fully received. Oracle has provided one script to identify such problematic records from system. Using this query we can confirm the problematic records and need to take corrective actions against those.
Oracle Note - Supply Data Exists After Full Correction to Over Received ASN (Data Fix)