Duplicate Accept And Deliver Transactions Exceed Receive Quantity Negative Mtl_supply Rcv_supply (Doc ID 1365896.1)

Last updated on JUNE 04, 2017

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Quality - Version 12 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Form:RCVTXERT.FMB - Enter Receiving Transactions


Symptoms

Find duplicate ACCEPT and DELIVER transactions have been created thereby exceeding the total RECEIVE quantity, also resulting in negative supply records in mtl_supply and rcv_supply tables.
 
The accept transactions are created in Quality Module.

Rcv11i output from <Note 402245.1> shows

PO_LINE_LOCATIONS_ALL



Expected Behavior
No duplicate transactions should exist.  The delivered quantity / accepted quantity for the distribution Line /
shipment line should not be greater than the ordered quantity / received quantity.


Steps
1. Navigate to Receiving Transaction Summary form
2. Search for Receipt Number / PO Number
3. See duplicate transactions

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