PO_REQLOAD Updating Monetary Amount and Monetary Amount Base Incorrectly (Doc ID 2007386.1)

Last updated on MAY 06, 2015

Applies to:

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

Symptoms

PO_REQLOAD updating Monetary amount and Monetary Amount Base incorrectly using standard item price.


STEPS
The issue can be reproduced at will with the following steps:

Test 1 - Standard Price 0
1 - Item setup
2 - Item Purchasing Attributes Setup. Standard Price of the Item is Zero, EA is the standard UOM for this item.
3 - Purchasing Attributes – Item Supplier Page. Supplier is not setup to accept any UOM.
4 - Purchasing Attributes – Item UOM Supplier Page. Supplier is setup for EA UOM with non-zero price for which the req will be created.
5 - Req Load Default Setup for Purchasing Requisition – Req Loader Defaults Page
6 - Req Load Default Setup for Purchasing Requisition – Overrides and Options Page
7 - Stage New Requisition for REQLOADER
8 - Run the Req Loader Process
9 - Requisition created
10 - Query:
SELECT A.BUSINESS_UNIT, A.REQ_ID, A.LINE_NBR, A.SCHED_NBR, A.DISTRIB_LINE_NUM, A.QTY_REQ, A.MERCHANDISE_AMT, A.MERCH_AMT_BSE, A.MONETARY_AMOUNT, A.MONETARY_AMT_BSE
  FROM PS_REQ_LN_DISTRIB A
  WHERE ( A.BUSINESS_UNIT = 'xxxxx'
  AND A.REQ_ID = 'xxxxxxxxxx')
Monetary Amounts are not Populating. It is showing Zero.

Test 2 - Standard Price different then Supplier Price
1 - Item Purchasing Attributes Setup. Standard Price of the Item is 2, EA is the standard UOM for this item.
2 - Purchasing Attributes – Item Supplier Page. Supplier is not setup to accept any UOM.3
3 - Purchasing Attributes – Item UOM Supplier Page. Supplier is setup for EA UOM with non-zero price for which the req will be created.
4 - Req Load Default Setup for Purchasing Requisition – Req Loader Defaults Page
5 - Req Load Default Setup for Purchasing Requisition – Overrides and Options Page
6 - Stage New Requisition for REQLOADER
7 - Run the Req Loader Process
8 - Requisition created
9 - Query:
SELECT A.BUSINESS_UNIT, A.REQ_ID, A.LINE_NBR, A.SCHED_NBR, A.DISTRIB_LINE_NUM, A.QTY_REQ, A.MERCHANDISE_AMT, A.MERCH_AMT_BSE, A.MONETARY_AMOUNT, A.MONETARY_AMT_BSE
  FROM PS_REQ_LN_DISTRIB A
  WHERE ( A.BUSINESS_UNIT = 'xxxxx'
  AND A.REQ_ID = 'xxxxxxxxxx')
Monetary Amounts are wrong. Getting Standard Price.


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