Why RCV_SHIPMENT_LINES table shows records with split quantity when receiving against ASN using Receiving Open Interface (ROI) ? (Doc ID 2225176.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Goal

Why RCV_SHIPMENT_LINES table shows records with split quantity when receiving against ASN using Receiving Open Interface (ROI) ?

Steps Followed to reproduce the reported issue:

> Create a Purchase Order with one PO Line of Quantity 1500 EACH
> Create four PO Shipments and PO Distributions of Quantity 450 EACH, 300 EACH, 250 EACH and 500 EACH
> Approve the Purchase Order.
> Insert one record in RCV_HEADERS_INTERFACE using Standard SQL Script in Doc ID 549609.1
> Insert four records in RCV_TRANSACTIONS_INTERFACE, each record for Quantity 450 EACH, 300 EACH, 250 EACH and 500 EACH using Standard SQL Script in Doc ID 549609.1
> Perform Commit manually.
> Run the concurrent request - Receiving Transaction Processor for the GROUP_ID

Following are the results shown in RCV_SHIPMENT_LINES table:

SHIPMENT_LINE_ID       QUANTITY_SHIPPED         PO_LINE_ID     PO_LINE_LOCATION_ID
5968458                         450                                    5036606          5954175
5968459                         300                                    5036606          5954176
5968460                         200                                    5036606          5954177
5968461                           50                                    5036606          5954177
5968462                         300                                    5036606          5954178
5968463                         200                                    5036606          5954178

This results in observing more RCV_SHIPMENT_LINES records than corresponding RCV_Transactions_Interface table records.


 

Solution

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