PO_POCHNG process leading to mismatch in MERCH_AMT_BSE and MONETARY_AMT_BSE when processing PO Acknowledgements (Doc ID 1509161.1)

Last updated on FEBRUARY 19, 2016

Applies to:

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

Symptoms

On PO_LINE_DISTRIB, MERCH_AMT_BSE and MONETARY_AMT_BSE are no longer equal when PO_POCHNG is used for processing PO Acknowledgements sent by the Supplier to increase the PO Price. The problem occurs only for Purchase Orders using a foreign currency.


STEPS TO REPLICATE
-----------------------

1)-Add/Update PO –Add a PO in Foreign Currency example CAD where base Currency is USD.

2)-Dispatch via EDX

3)- Run the script below and notice that the MERCH_AMT_BSE field calculated as the PO amount multipled by the exchange rate between the PO currency and the business unit currency equals the MONETARY_AMT_BSE field.

Script:

-------------
SELECT A.MERCH_AMT_BSE, A.MONETARY_AMT_BSE, A.REQ_ID, B.CHNG_ORD_SEQ, A.*, B.*
  FROM PS_PO_LINE_DISTRIB A, PS_PO_HDR B
  WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
  AND A.PO_ID = B.PO_ID
  and a.po_id='XXXXXXXXXXX';

4)-Fake a PO Acknowledgement transmission to submit a PO price change. You can use the Handler Tester utility in Integration Broker to do this process.

5)-Navigate to PeopleTools-Integration Broker-Service utilities-Handler tester-Search for PURCHASE_ORDER_ACKNOWLEDGEMENT

6)-Click on the Service Operation-Select Handler Type as On Notify and Handler Name as Purchase Order Acknowledgement

7)-Click on Button Provide XML-Upload the XML

8)-Click on OK-Click on Execute Event until it is Done.

9)-Navigate to Manage PO Acknowledgements

10)-Click on the PO ID say "XXXXXXXXX"--Select the flag “Review” and select “Accepted” from prompt and Click Approve

11)-Click on Save

12)-Navigate to Acknowledgements-Process Change order- Run the PO_AUTO_CHNG Process to Success and Posted.

13)-Navigate to Manage change Orders-Approve Change Request- Approve the Change Request

14)-Navigate to Manage Change Orders-Process Change Orders- Run the PO_POCHNG process to Success and Posted

15)-Run this query again
SELECT A.MERCH_AMT_BSE, A.MONETARY_AMT_BSE, A.REQ_ID, B.CHNG_ORD_SEQ, A.*, B.*
  FROM PS_PO_LINE_DISTRIB A, PS_PO_HDR B
  WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
  AND A.PO_ID = B.PO_ID
  and a.po_id='XXXXXXXXXX';
 By running this query we realize that there is a difference in amount MERCH_AMT_BSE as well as MONETARY_AMT_BSE.

16)-Lets run the PO Dispatch again. Currently PO is in Approved status after price change.

17)-After PO Dispatch-  Run the same query again and you will realize that amounts are same.
 

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