My Oracle Support Banner

Receipt Picking Up Invalid UOM Conversion Rate (Doc ID 2061462.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Steps to Reproduce the Issue:

1) Vendor UOM item setup
Item 10002 setup with Rate Type = Override value =20.00
Item 10006 Setup with Rate Type = Override Value =30.00
Item 10009 Setup with Rate Type = Override Value =50.00

2) Create Purchase Order (216) with 3 lines with above items

3) Query from PS_PO_LINE_SHIP:

SELECT A.BUSINESS_UNIT, A.PO_ID, A.LINE_NBR, A.SCHED_NBR, A.CANCEL_STATUS, A.BAL_STATUS, A.CHANGE_STATUS, A.CONVERSION_RATE
FROM PS_PO_LINE_SHIP A WHERE A.BUSINESS_UNIT = 'US001' AND A.PO_ID = '0000000216'

Conversion rate correct from Vendor UOM item setup definition shows correctly

4) Delete the first line (with Item 10002) and change the quantity of the second line (10006). save

5) Query:
SELECT A.BUSINESS_UNIT, A.PO_ID, A.LINE_NBR, A.SCHED_NBR, A.CANCEL_STATUS, A.BAL_STATUS, A.CHANGE_STATUS, A.CONVERSION_RATE
FROM PS_PO_LINE_SHIP A WHERE A.BUSINESS_UNIT = 'US001' AND A.PO_ID = '0000000216'

6) Conversion Rate updated incorrectly.The field for line 1(10006) should be 30 but shows as 20

7) The system does not updated with the conversion rate from UOM page.

This is causing  Receipt picking up invalid UOM conversion rate



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