My Oracle Support Banner

Prior Receipt Quantity is not Reduced with RTV Quantity Generated in the Select Purchase Order (PO) Page (Doc ID 2552951.1)

Last updated on JANUARY 13, 2020

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Prior Receipt Quantity is not Reduced with RTV Quantity Generated in the Select Purchase Order (PO) Page.

This issue will occur only if there is change in 'RTV Adjust Source' flag in BU setup at navigation 'Set Up Financials/Supply Chain -> Business Unit Related -> Purchasing -> Purchasing Definition -> Business Unit Options'

After <Bug 28182083> was applied, the error message (28001,10) is still triggered.

 

It was observed that only BU is passed in the SQL to pull RTV_ADJ_SOURCE. RTV_ID is not passed here which is creating the issue.

In the Select Purchase Order (PO) Page it is expected as Prior Receipt Quantity to be less than the PO Quantity with the RTV Quantity Generated.

 

Steps to Reproduce the Issue:
The issue can be reproduced at will with the following steps:
1. Business unit options for purchasing BU US001. Note: ‘RTV Adjust Source’ flag is unchecked
Allow Business Item Attributes = Y
Allow Multicurrency Reqs = Allow Multicurrency PO = Y
Default Contract On Req = Default Contract on PO = Y

2. Notice PO was received

3. Create RTV for Line 2 from PO
Action = Replace, Disposition = Ship, Reason = WRG, Return Qty = 10. Save RTV.

4. Notice RTV_ADJ_SOURCE flag is set to ‘N’ in RTV_HDR as per the BU options set

5. Now change the business unit options for purchasing BU US005. Check ‘RTV Adjust Source’ flag

6. Create RTV for PO Line 2

Action = Replace, Disposition = Ship, Reason = WRG, Return Qty = 5. Save RTV.

7. RTV_ADJ_SOURCE flag is set to ‘Y’ in RTV_HDR as per the BU options set.
Notice the second RTV has RTV_HDR.RTV_ADJ_SOURCE = Y


8. Create a new receipt for PO Line 3

Notice users cannot create the receipt with the right remaining quantity.

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.