Decimal Precision Is Increasing Upon Receiving Against A Foreign Currency PO (Doc ID 1587774.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Symptoms

On : 12.1.1 and later

ACTUAL BEHAVIOR
---------------
Through iProcurement receipts are created with junk rate when the following conditions are met:

- PO is created with foreign currency
- PO line type is of 'Amount'
- No conversion rate has been defined for the date that the receipt is created

When a Purchase Order is created in foreign currency and the Match option is 'Receipt',
then the currency conversion rate date for today defaults in.
If no rate has been defined for that date, then the user should receive an error and not be allowed to create the receipt.
However, for PO lines with type of 'Amount' no error is displayed and the receipt is created with the following junk rate:
9.990000000000000000000000000000000E+125

This issue does not occur for PO line type of 'Goods'.
Then the user is prevented from creating the receipt and an error is inserted into table po_interface_errors: PO_CPO_NO_RATE_FOR_DATE.

This issue only occurs when creating the receipt through iProcurement.
When creating a receipt for type 'Amount' through the Receipt form the following error is received:
APP-PO-14258: No rate has been defined for this date
and the user is prevented from creating a receipt.

EXPECTED BEHAVIOR
-----------------------
Expect also an error to be displayed in iProcurement when the line type is 'Amount' which will prevent
the user from creating a receipt with junk rate.

STEPS TO REPRODUCE:
------------------------------
1. Create a Purchase Order in a foreign currency, rate type 'Corporate' and with line type 'Amount'
2. Make sure that no Corporate rate has been defined between the foreign and functional currency for today
3. Navigate to iProcurement > Receiving
4. Create a receipt
5. No error message is received and a receipt is created
6. Query the receipt through Receipt Transactions Summary form
7. The currency conversion rate is displayed as: 9.990000000000000000000000000000000E+125

SYMPTOMS
--------------
- Rate Type = Corporate
- Match Option = Receipt

Cause

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