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.

Symptoms

On : 12.1.3 version, Receiving Functions

ACTUAL BEHAVIOR
---------------
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


STEPS
-----------------------
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.

Changes

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

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!

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