My Oracle Support Banner

The record for Transaction_Type = DELIVER exists in RCV_Transactions table without its parent record of Transaction_Type = RECEIVE (Doc ID 2272089.1)

Last updated on MAY 31, 2017

Applies to:

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


On : 12.1.3 version, Receiving Functions

DELIVER transaction in RCV_TRANSACTIONS table has Parent_Transaction_ID populated but Parent_Transaction_ID record does not exist in RCV_Transactions table.
Due to which PO Delivered Quantity is shown greater than PO Received Quantity

1. Purchasing Responsibility > Receiving > Receiving Transactions Summary
2. Query the relevant Purchase Order Number and click on Find.
3. View Receipt Transactions that are executed under the given Receipt Number.


 It is required to check if the user has run any script that could have purged the receipt entry.


To view full details, 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 a vibrant support community of peers and Oracle experts.