Receipt Picking up Different Rates for PO Receipt Amount and Discounts When Purchase Order Created With Foreign Currency (Doc ID 2991908.1)

Last updated on DECEMBER 07, 2023

Applies to:

Symptoms

Receipt picking up different rates for PO Receipt amount and discounts when Purchase Order created with foreign currency

Found differences between RECV_LN_DISTRIB.MERCH_AMT_BSE and RECV_LN_DIST_LC.MISC_CHG_AMT_BSE and also the RATE_MULTI for both tables are wrong.


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

1. Go to Menu> Setup Financials/Supply Chain > Common Definitions > Market Rates. Check Market Rates: GBP to USD.    
2. Go to Menu > Purchasing > Purchase Orders > Add/Update POs. Create a PO with foreign currency. Conversion rate takes based on the last effective date. Make sure the PO header picked up the latest market rate.
3. Add Misc. charges (Discount) 100% to make the PO with 0 (zero) amount
4. Save PO, Budget check and dispatch
5. Add the Market rate for May 15, 2023 before receiving
6. Go to Menu > Purchasing > Receipt > Add/Update Receipts. Receive the PO created above 
7. Query RECV_LN_DISTRIB:
      SELECT A.BUSINESS_UNIT, A.RECEIVER_ID, A.PO_ID,
                  A.MERCH_AMT_BSE, A.MERCH_AMT_PO_BSE, A.MERCHANDISE_AMT, A.MERCHANDISE_AMT_PO,  A.CURRENCY_CD, A.CURRENCY_CD_BASE, A.RATE_MULT, A.RECV_DS_STATUS FROM PS_RECV_LN_DISTRIB A   WHERE ( A.BUSINESS_UNIT = 'XXXXX'   AND A.RECEIVER_ID = 'XXXXXXXXXX')
8. MERCH_AMT_BASE is converted correctly using the new one rate, but the RATE_MULT is showing the old rate
9. Query RECV_LN_DIST_LC:
     SELECT A.BUSINESS_UNIT, A.RECEIVER_ID, MISC_CHARGE_CODE, MISC_CHG_AMT_BSE,  A.CURRENCY_CD, A.CURRENCY_CD_BASE, A.RATE_MULT FROM PS_RECV_LN_DIST_LC A   WHERE ( A.BUSINESS_UNIT = 'XXXXX'   AND A.RECEIVER_ID = 'XXXXXXXXXX')
10. MISC_CHG_AMT_BSE should be the same amount of RECV_LN_DISTRIB.MERCH_AMT_BSE and RATE_MULTI should be the new one.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.