Over receive ASN shipped quantity 导致的 bug

1.     Createa PO with quantity 120.

2.     Create 2 ASN, ASN48 forquantity 48, ASN33 for quantity 33.

        Note here, ASN33is split into 2 lines, one is 24, another is 9.

3.     Go to receive 48 for ASN48.

4.   Receive ASN33.customer see 3 records here. 30 is against po, and the other two for ASN33.

5.     Customer may think they couldreceive these 24+9=33 in one transaction, and Oracle allows over receive theshipped quantity.

        So Ct received 33 against the record 24.

6.     After that, Ct found the record9 is still there. So he has to receive it.

7.     In this way, Ct has received 33+ 9 for ASN33. So Ct corrected all of them.

8.     After correction for Deliver,in MTL_SUPPLY, there are 3 records, 9 and 33 for receiving, 30 for PO.

9.     Continue correct for Receive.

10.     After this step, MTL_SUPPLY has3 records, 9 and 33 for shipment, 30 for PO

11.     Then Ct go to receive the 24+9at one transaction

12.     By this step, MTL_SUPPLY has 2records, 9 for shipment, 30 for PO.

          The 9 leftbecause the original quantity is 33, and 24 received.

 

13.     Ok, until this step, we have exactlythe same data as customer. please refer to RCV11i_po_5908-_.html.

 

14.     In form, when query for thisPO, we can only find 30, other 9 is missing.

15.     Why 9 is missing?

         Because PO_LINE_LOCATIONS_ALL.QUANTITY_SHIPPED = 9.

         While MTL_SUPPLY.SUPPLY_SOUCE_CODE = SHIPMENT.

 

        So there are 3incorrect records here:

        PO_LINE_LOCATIONS_ALL.QUANTITY_SHIPPED = 9 which should be 0.

        MTL_SUPPLY.QUANTITY= 30, which should be 39.

        MTL_SUPLLY.SUPPLY_SOURCE_CODE= SHIPMENT, this record should not exist.