E1: 43: PO Entry (P4310) Does Not Use 7 Decimal Exchange Rate to Calculate Large Domestic Amounts (Doc ID 2962981.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

PO Entry (P4310) does not use 7 decimal exchange rate to calculate large domestic amounts.

Steps to Duplicate

1. The Currency Exchange Rate field (CRR) has 7 decimal places in the PO Detail (F4311) table.
2. The Dictionary Item CRR has 7 File Decimals.
3. Set Currency Exchange Rates (P0015A) for USD to AUD using all 7 decimal places.
   1. Multiplier Rate is 1.4692918 AUD per USD.
   2. Divisor Exchange Rate is 0.6806000.
4. Create a Purchase Requisition (P4310) with an Amount that is 7 digits to the left of the decimal (in millions).
   1. Enter AUD Currency Branch Plant.
   2. Enter USD Currency Supplier.
   3. Quantity Ordered 500,000.00.
   4. Unit Cost 2.0000 (USD) – four decimals.
   5. Extended Cost = 1,000,000.00 – seven digits to the left of the decimal.
5. Review Requisition Header Inquiry.
   1. USD Foreign Amount = 1,000,000.00
   2. AUD Domestic Amount = 1,469,300.00 (exchange rate was rounded up to 1.4693)
   3. Using Calculator with Multiplier Rate Domestic Amount is 1,469,291.80 (1,000,000.00 x 1.4692918)
   4. AUD Amount Difference due to rounding = 8.20
   5. Using Calculator with Divisor Rate Amount is 1,469,291.801351748 (1,000,000.00 / 0.6806000)
   6. AUD Amount Difference due to rounding still 8.20

Exchange Rate has 7 Digits to the Right of The Decimal 1.4692918.

In Purchase Order Domestic Amount is calculated with Exchange rate Rounded to 4 Digits to the Right of the Decimal.

Using Calculator with Multiplier Rate Domestic Amount should be 1,469,291.80 (1,000,000.00 x 1.4692918).

Using Calculator with Divisor Rate Amount is 1,469,291.801351748 (1,000,000.00 / 0.6806000)

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.