My Oracle Support Banner

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

Last updated on APRIL 29, 2024

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.

Duplicates are seen in Rcv11i output from <Note 402245.1>

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.