Sequence of Shipment Records in RCV_SHIPMENT_LINES Mismatch PO_LINE_LOCATIONS_ALL (Doc ID 1570834.1)

Last updated on JANUARY 19, 2015

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The sequence of shipment records in rcv_shipment_lines does not match the sequence order in po_line_locations_all.
Neither match the sequence showed in Receipts form, it is ordered by "NEED_BY_DATE" in Receipts form.

Steps to reproduce
-----------------------

1. Navigate to Purchasing responsibility>Purchase Orders.

2. Create Purchase order(PO) with one Purchase order line and several shipment lines, below is an example with 4 shipment lines:

Num      Quantity      Need-By

 1           1            2013-06-19

 2           2            2013-06-18
 3           3            2013-06-20
 4          14           2013-06-21 

3. Approve  the Purchase Order.

4. Create ASN again above PO by ROI script which insert one row only with total quantity.

5. Run concurrent request "Receiving Transaction Processor" successfully.

6. Then in the po_line_locations_all table, the shipment records are sorted by following sequence:

     QUANTITY    
             1            
             2
             3
            14

In the rcv_shipment_lines table, the records are shown as below:

 QUANTITY_SHIPPED 
           2 
          14 
          3 
          1

7. Go to Receiving>Receipts, find out the ASN, the transaction lines are ordered by "NEED_BY_DATE".

      Quantity      Need-By

          2            2013-06-18
          1            2013-06-19
          3            2013-06-20
         14           2013-06-21

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms