Last updated on JANUARY 20, 2017
Applies to:Oracle Inventory Management - Version 220.127.116.11 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms