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

Last updated on JUNE 12, 2017

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

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 hundreds of Community platforms